Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
How soundex works (Read 4548 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
How soundex works
14.05.08 at 10:50:24
How soundex works
I read an interesting article by Patrick Sinke "Ever wondered how Soundex works?" at
Soundex returns a character string which represents the phonetic representation of the inputstring. This representation is, according to the The Art of Computer Programming (by Donald E. Knuth) defined as follows:....


Retain the first letter of the string and remove all other occurrences of the letters a, e, h, i, o, u, w, y.

Assign numbers to the remaining letters (after the first) as follows:

b, f, p, v = 1
c, g, j, k, q, s, x, z = 2
d, t = 3
l = 4
m, n = 5
r = 6


If two or more letters with the same number were adjacent in the original name (before step 1), or adjacent except for any intervening h and w, then omit all but the first.

Return the first four bytes padded with 0

Patrick goes on to give an example. He also gives the algorithm for soundex in Dutch. He notes that the above definition for soundex is for the English language and for other languages another definition can (or should?) be used.
Back to top
« Last Edit: 14.05.08 at 10:52:17 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1