Finding The Nearest Text Match

[Noonoo]

I have an table of terms and would like to find the the nearest match to searched terms. For example, if the search term is 'Holand' the query returns 'Holland' as the nearest matching term in the table. The idea being to allow for mistypes, mispellings and plurals.

I can think of one way of doing this: Searching for the full term and if there is'nt a match, removing the last character and searching again and so on until there us a match.

Does anyone know if this is the best method. It seems a bit longwinded. If it is the best way does have anyone have an example of the code.

Thanks in advance for your help.

 

[tlbroadbent]

I recommend reading about SOUNDEX and FULL-TEXT Search in SQL Books Online. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.