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 - 2001-04-29 : 22:53:40
|
Guillermo writes "Hi,
Here is my question. Its probably simple, but I haven't found anybody who can help me, not even on the Microsoft SQL forums.
I need to find a way to do approximate text searches inside SQL.
Its not necessarily a spell checker, but it should do the same
thing.
That is...
-I try to add a new element to the database (the element
is a company name)
-the database checks to see if a company name with an approximate spelling exists. If it does, it presents all the existing ones (as suggestions) and lets you select one.
Its pretty much what a spell checker does (with suggestions)
I found two programs that work on windows that do this
AGREP ( http://www.tgries.de/agrep/ ) and
YGREP ( http://perso.magic.fr/roumazeilles/ygrep.htm )
but both of these work on text files, not on SQL databases
(i need to retrieve the key). The guy from YGREP suggested
I do a SQL query and generate a text file, then use the program
and go back into SQL, but that seems awefully complicated (and slow).
Is there any way to this that you might know?
thanks,
-Guillermo
PS.- The soundex function is a different algorithm and works
better in English (most of my searches are in spanish)" |
|
|
|
|
|
approximate text searches (spell cheking suggestions)