Metaphone sources for Oracle

[ page 2 ]

Metaphone 4GL sources for Oracle.

These are some PL/SQL sources for Metaphone. The pop-up windows show the differences as they all treat the translation differently.
Metaphone is written for the English language - therefore the first version of Metaphone uses the English language rules. The second is adapted by me to more suitable for European languages.

Oracle PL/SQL sources.
Stephens - original source	metaphone10.sql	remarks 1
Stephens - improved for European languages	metaphone12.sql	remarks 2
Crainshaw - original source	metaCrainshaw.sql	remarks 3

Notes on Metaphone rules.

Metaphone reduces the alphabet to 16 consonant sounds:

B X S K J T F H L M N P R 0 W Y ( The 0 is a zero - representing "TH").

All vowels are dropped, except when it's the first letter. Also all double letters are replaced by a single letter.

Metaphone improvements.
The original Stephens version translates all D's to T. I don't agree with this: fooD might sound somewhat like fooT, however riDe doesn't sound like riTe; and Down not like Town. Therefore I've modified it in version 2 to make D translate to D. The T is still translated to T.

The DT is translated to D (Smidt translates to Smid) in Stephens improved version. The DT is very common in German and Dutch, e.g. Schmidt (Smith).

Also i removed all G to J translations in Stephens improved version, since G sounds like J only in English, not in other languages. In most North-european languages the G is a hard sound, very different from the soft English pronunciation (Jee).

See the remarks 2 for the changed rules.

The Crainshaw source is more simplified then the Stephens source and makes a lot less matches, so in my opinion it's inferrior.

Metaphone for Oracle introduction on page 1 : metaphone Page 1

For any questions :

Please e-mail : info AT bytelife.nl
Bytelife is a registered trademark.