Searching for misspelled keywords?
From: AKG (AKG_at_discussions.microsoft.com)
Date: 02/14/05
- Next message: Ahmad Jalil Qarshi: "Re: Why Query Response is Slow?"
- Previous message: Vinod Kumar: "Re: UPDATE - UNION"
- Next in thread: David Gugick: "Re: Searching for misspelled keywords?"
- Reply: David Gugick: "Re: Searching for misspelled keywords?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Feb 2005 02:31:03 -0800
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 :)
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.
Thanks
AKG
- Next message: Ahmad Jalil Qarshi: "Re: Why Query Response is Slow?"
- Previous message: Vinod Kumar: "Re: UPDATE - UNION"
- Next in thread: David Gugick: "Re: Searching for misspelled keywords?"
- Reply: David Gugick: "Re: Searching for misspelled keywords?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
