This is an implementation in SQL for MySQL 5.0+. It creates a function you can use in your SQL queries a la: "SELECT Name FROM tblPeople WHERE dm(Name) = dm(@Search)". (Updated Nov 27, 2007 to fix a type-o in the 'CC' section. Updated June 1, 2010 to fix a bug in the 'Z' section. Updated June 25, 2010 to fix many bugs - see the file opening comments.)

metaphone.sql — SQL code, 23 kB (24049 bytes)

metaphone.sql — AtomBoy Plone Portal