You need to use offset with limit, to select where in the results to display from. You should also order the SQL results by some useful field or they will simply show in database insertion order.

my $results = $db->selectall_arrayref('SELECT word ,line FROM dickens 
+WHERE word="$concordance" ORDER BY line LIMIT 50 OFFSET 50');
[download]