Hi,
I'm using SQL queries with LIKE operator to search for keyword(s) in a
VARCHAR field of a table. This works fine for basic search but now I want my
web application to search for not only specified terms but also suggest user
for alternate spellings incase of any misspellings, just like Google. e.g. If
I enter 'Pakstan' it should search for this keyword as well as suggest the
correct word 'Pakistan' or any other word as it also appear in MS Word when
there is a spelling mistake.
I know there is Full-Text Catalog in SQL Server but it doesn't suggest
alternate spellings or misspellings, does it? Is there any off the shelf
component I can download? I donโt have to build and check this manually, do I?
Any suggestions/responses will be highly appreciated. Or should I be
looking/posting at some other forum for this issue. MSDN comes first thing in
my mind for solutions ๐