Re: SoundEx and FullText
From: John Kane (jt-kane_at_comcast.net)
Date: 09/03/04
- Next message: John Kane: "Re: Full text search performance problem"
- Previous message: Sylvain: "Re: Full text search performance problem"
- In reply to: DavidSp8: "Re: SoundEx and FullText"
- Next in thread: John Kane: "Re: SoundEx and FullText"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 11:30:46 -0700
DavidSp8,
You might not of seen my post on this issue yet, but I have a follow-up
after 'Googling' for 'METAPHONE soundex "sql server" fuzzy name search' and
I quickly found - "Double Metaphone Sounds Great" at
http://www.winnetmag.com/Article/ArticleID/26094/26094.html You can freely
download the code in a zip file that has several a user-defined function
(UDF) that implement Double Metaphone.
In regards to NYSIIS, SQL Server does not directly support this method as it
only supports SOUNDEX and the soundex related DIFFERENCE function. See SQL
Server 2000 BOL for more info on both of these functions. However, I did
find this web page (via google too:) "Matchmaker, Mitchmoker - is that a
Match?" at http://www.civilsolutions.com.au/publications/dedup.htm that
describes more about NYSIIS relative to FoxPro and there are .prg files you
can download from this article on NYSIIS.
Regards,
John
"DavidSp8" <DavidSp8@discussions.microsoft.com> wrote in message
news:49949630-28DD-4780-B0C1-8E7D7ACCC825@microsoft.com...
> Thank you for your response. I had not even considered storing it in
another
> feild and indexing that. That is probably the solution I will implement.
>
> I mentioned SoundEx, but the acutal request (this is a client driven
> request), is to have fuzzy name searches.
>
> They've asked that we use the NYSIIS standard to perform the search.
>
> "Hilary Cotter" wrote:
>
> > The way to do it would be to convert all of your textual information to
> > soundex equivalents, and index this. You might want to consider a
parallel
> > table with the soundex equivalent or another column with it.
> >
> > You would also have to trap and convert your queries to soundex as well.
> >
> > The problem with doing this is that
> >
> > 1) stemming will be broken
> > 2) soundex is not really reliable. It has been replaced in favor or
> > metaphones, and even then metaphones are not considered to be that
accurate.
> >
> > What is motivating you to consider soundex? Perhaps there is a better
> > solution to your problem.
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "DavidSp8" <DavidSp8@discussions.microsoft.com> wrote in message
> > news:62124D12-D59A-4EF4-8F17-811C46D56BF8@microsoft.com...
> > > Is it possible to utilize FullText Indexes with a SoundEx Function, or
for
> > > that matter a User-Defined Function. I have a table with
approxiamately 2
> > > million rows, that i need to perform SoundEx Queries on frequently and
I'm
> > > concerned about performance.
> >
> >
> >
- Next message: John Kane: "Re: Full text search performance problem"
- Previous message: Sylvain: "Re: Full text search performance problem"
- In reply to: DavidSp8: "Re: SoundEx and FullText"
- Next in thread: John Kane: "Re: SoundEx and FullText"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
