Anonymous

	$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 ("<center> ERROR: ".mysql_error()."</center>");


	$rows = array();
	
	while ($row = mysql_fetch_assoc	($result)) { 
		$compare = $row[term];
		$levenshtein = levenshtein($trimmed, $compare);
		$lengthdifference = max($trimmed, $compare) - min($trimmed, $compare);
		$levenshtein-=$lengthdifference;
		$similarity = $levenshtein/strlen(min($trimmed, $compare));
		$row['similarity'] = $similarity; $rows[] = $row;
		
		print_r($rows);

		}
			
			function levsort($a, $b)
			{
			    { if ($a['similarity'] > $b['similarity']) return 1; else return -1; }
			}
			usort($rows, "levsort");