Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-15 : 07:05:08
|
| Ali writes "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.Please note that I need to search for one or more keywords in VARCHAR fields in multiple columns of many tables. I’m catering multiple keywords by separating the String of keywords in the stored procedure using T-SQL. I'm using SQL Server 2000 without servicepacks on Windows 2000 server.ThanksAKG" |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-02-15 : 08:12:34
|
SOUNDEX is a possibility (ex: Smith = Smythe)PATINDEX is also a possibility (can find patterns)Read about both in BOL (Books Online - SQL Help)Corey "If the only tool you have is a hammer, the whole world looks like a nail." - Mark Twain |
 |
|
|
|
|
|
Searching for misspelled keywords?