$sql = "SELECT DISTINCT term FROM logs WHERE term_soundex LIKE LEFT(SOUNDEX('$trimmed'),4) AND results2 >0 AND term REGEXP '[0-9]' !=1 LIMIT 10"; $result = mysql_query($sql) or die("Error: ".mysql_error()); $i = 0; $userarray = array(); while(list($term) = mysql_fetch_row($result)){ $compare = $term; //levenshtein $levenshtein = levenshtein($trimmed, $compare); $lengthdifference = max($trimmed, $compare) - min($trimmed, $compare); $levenshtein-=$lengthdifference; $similarity = $levenshtein/strlen(min($trimmed, $compare)); $userarray[$i][0] = $term; $userarray[$i][1] = $similarity; $i++; // or do this to compress the data and ensure it all stays together $userarray[count($userarray)] = $term.",".$similarity; } echo $term."<br>"; echo $similarity."<br>";