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)) * 100;
		
		$row['similarity'] = $similarity; $rows[$similarity] = $row;
		
		print_r($rows);
		sort($rows);
foreach($rows as $key=>$value){ echo $key.'#'.$value;}
		}
			
	//		function levsort($a, $b)
	//		{
			    { if ($a['similarity'] > $b['similarity']) return 1; else return -1; }
	//		}
	//		usort($rows, "levsort");