Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) [3] => Array ( [term] => Buddhism for Beginners [similarity] => 0.727272727273 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) [3] => Array ( [term] => Buddhism for Beginners [similarity] => 0.727272727273 ) [4] => Array ( [term] => bhddhism and judaism [similarity] => 0.7 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) [3] => Array ( [term] => Buddhism for Beginners [similarity] => 0.727272727273 ) [4] => Array ( [term] => bhddhism and judaism [similarity] => 0.7 ) [5] => Array ( [term] => Buddhism for Beginners: A Complete Course on the Heart of the Buddha's Teachings [similarity] => 0.925 ) )


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