Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    7

    Unanswered: Soundex for Dutch ?

    Hello,
    Does the SOUNDEX function only apply to english (surnames) or can it be used for other languages e.g. Dutch.
    Well, it can be used ofc. but does it produce meaningful output ?

    Thanks,
    Rick

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    Oversimplified, Soundex generates a code based upon the following:
    1. Toss vowels unless the first character.
    2. Group non-vowels into "sounds similar" categories.

    Even though I should know more about Dutch than I do (my great grand parents "came over on the boat") I'm not sure if the hard consonates are the same.

    If you are interested, I do have the t-sql code for soundex and metaphone. We use both here. And we have our own Soundex becuase we need to generate a 5 vs. 4 position result.

    F.
    Fred Prose

  3. #3
    Join Date
    Jun 2003
    Posts
    7

    soundex and metaphone t-sql code

    Hi Fred,
    That would be great if you could mail me the t-sql code. I can use it to adapt it (if neccessary) for the dutch language.
    Both the soundex and metaphone I am interested in.
    email : shylock{removespam}mccoy@hotmail.com

    Thanks inadvance,
    Rick

  4. #4
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    Sent @ 13:05
    Fred Prose

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •