[Codeproject daily recommendation] implements the double metaphone speech matching algorithm [2]: The com Implementation of Visual Basic and the relational database solution

Implement phonetic ("sounds-like") name searches with double metaphone Part II: Visual Basic and relational database solutions by Adam Nelson

For COM, only the usage is described here: regsvr32 metaphonecom. dll, then you can use mphone. computemetaphonekeys searchword, primarykey, alternatekey

Relational databases are introduced to express the common dynamic speech data in reality. The map (hashtable) data structure is not required for queries to record the matching of keys and words. you can use this SQL statement: Select word from words where (key1 =-25654) or (key2 =-25654) or (key1 =-25651) or (key2 =-25651 ), the Access Database demo is used in this article, but other databases can also be conveniently used.