Re: soundex and difference

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joe Celko (jcelko212_at_earthlink.net)
Date: 06/04/04 

Date: Fri, 04 Jun 2004 11:47:00 -0700

>> What about using them to compare string in an other language such as
french? <<

Soundex is bad for any language except English. Look up Metaphone and
various national Soundex algorithms. Some of the details are given in
SQL FOR SMARTIES.

REFERENCES:
 
 "A Better Phonetic Search", Gary A. Parker, THE C GAZETTE, 1991
Jun/Jul, p. 55.
 
 "Hanging on the Metaphone", Lawrence Philips, COMPUTER LANGUAGE, 1990
Dec, p.39.
 
 "Approximate String Matching", John Rex, THE C GAZETTE, Autumn 1988, p.
26.
 
 "Pattern Matching: The Gestalt Approach", John W. Ratcliff & David E.
Metzener, DR. DOBB'S JOURNAL, 1988 Jul, p. 46.
 
 "An Alternative to Soundex", Jim Howell, DR. DOBB'S JOURNAL, 1987 Nov,
p. 62.
 
 "Wordz that Almost Match", Dave Taylor, COMPUTER LANGUAGE, 1986 Nov,
p. 47.
 
 "Soundex", C GAZETTE Staff, The C GAZETTE, Winter 1988, p. 4.
 
 "Optimized Soundex", Joe Celko, The C GAZETTE, Autumn 1989, p. 29.
 
 "C program finds words that sound alike", Robert D. Grappel, EDN, 1985
Jul 11, p. 288.
 
 "Soundex algorithm is good but not perfect (letter referring to
above)", William T. Manheim, EDN, 1985 Nov 14, p. 288.

--CELKO--
 ===========================
 Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Phonetic Name Algorithms
    ... Does anyone have any info/insights about good phonetic algorithms? ... We are all very familiar perhaps with the Soundex, Metaphone or Double- ... but these were all designed for Latin/English language ...
    (comp.databases.pick)
  • Re: phonetic field
    ... You don't say what language you're working with -- but is phonetic necessary? ... Is a soundex() variant ok? ... i am writing a dictionary and i need use phonetic in one field. ...
    (microsoft.public.fox.helpwanted)
  • Phonetic Name Algorithms
    ... Does anyone have any info/insights about good phonetic algorithms? ... We are all very familiar perhaps with the Soundex, Metaphone or Double- ... but these were all designed for Latin/English language ...
    (comp.databases.pick)
  • Re: Counting elements in a list wildcard
    ... Susy, Susi, Susie all work.) ... Apparently a soundex module used to be built into Python but was ... MetaPhone is generally considered better than SoundEx for "sounds-like" ... A Python MetaPhone implementations (there must be more than ...
    (comp.lang.python)
  • Re: SoundEx and FullText
    ... I quickly found - "Double Metaphone Sounds Great" at ... In regards to NYSIIS, SQL Server does not directly support this method as it ... only supports SOUNDEX and the soundex related DIFFERENCE function. ...
    (microsoft.public.sqlserver.fulltext)