Assuming relevance is required, the following 3 results were found.
to articles where the search term is in the article title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches...
So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...
do a levenshtein on two words soundex value and compare these. // Be warned that it does go off track though in terms of relevance... Sources: iamcal.com Nadeau Software