$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."
";