Ya, I read about it in a SQL book I have, the author provided a
SOUNDEX which would detect for the
"Ffiefer
Pfiefer"
Cases, But it can still be useful for certain types of searches
so I figured I would toss it out there.
I actually read in a book Programming Pearls (really great)
About how the algorithms to generate unique signatures for
words (Like say in a dictionary).. Interesting stuff...
Does it suprise you taht the MS Implementation is more
or less not that great? :-P
Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]
-----Original Message-----
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 10:32 AM
To: [EMAIL PROTECTED]
Subject: RE: Fuzzy Logic Searches in SQL
The SOUNDEX function returns a 4-character Phonetic code. It is
primarily used to compensate for spelling differences in last names:
Smith
Schmidt
Smythe
all generate the same code, S630, as I recall.
It will not resolve differences in the first character:
Ffiefer
Pfiefer
This is a very old technology (predates computers) that was developed
for the government. I temember an old IBM SOUNDEX manual that was a
reprint of a government manual. It was available in the '60s for
development oh Police Information systems and the like.
I did a sherlock search and found:
http://www.cimorelli.com/pie/faq/pfaq_a15.htm
HYH
Dick
At 9:48 AM -0400 8/22/00, Jeremy Allen wrote:
>There is something called SOUNDEX searches in SQL also which
>in theory return phonetical spellings of words.
>
>Jeremy Allen
>[EMAIL PROTECTED]
>[Insert cool title here]
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 21, 2000 5:39 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Fuzzy Logic Searches in SQL
>
>
>CONTAINS Predicate is exactly what you are looking for.
>
>However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new
feature
>full-text searching/indexing was added. In which I think CONTAIN relies on?
>
>Any hope of upgrading to 7.0? Or possibly using Verity search capability?
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
