$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()); $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)); // or do this to compress the data and ensure it all stays together $userarray[count($userarray)] = $term.",".$similarity; } echo $term."
"; echo $similarity."
";