[Edit]

MySQL - soundex usage example

1 contributors

2 contributions

0 discussions

5 points

Created by:

Teilsa

1315

In this short article, we would like to show how to use Soundex algorithm in MySQL.

Soundex is implemented by default in MySQL by SOUNDEX() function.

Practical example:

xxxxxxxxxx
 
SELECT 
    SOUNDEX('Robert'),    -- R163
    SOUNDEX('Rupert'),    -- R163
    SOUNDEX('Rubin'),     -- R150
    SOUNDEX('Ashcraft'),  -- A2613 (not A226)
    SOUNDEX('Ashcroft'),  -- A2613 (not A226)
    SOUNDEX('Tymczak'),   -- T520  (not T522)
    SOUNDEX('Pfister'),   -- P236
    SOUNDEX('Honeyman');  -- H500  (not H555)

Warning: MySQL modifies Soundex algorithm a little to own way.

Output:

xxxxxxxxxx
 
R163
R163
R150
A2613
A2613
T520
P236
H500

More complicated example

Edit

The below example shows how to group similar words/keywords with SOUNDEX().

With SOUNDEX() Without SOUNDEX()

xxxxxxxxxx
 
SELECT COUNT(`id`) as `group_size`
FROM `keywords`
GROUP BY SOUNDEX(`keyword`)

Conclusion: groups are bigger
(SOUNDEX() used to transform keywords before equals operator was used).

Example output:

xxxxxxxxxx
 
SELECT COUNT(`id`) as `group_size`
FROM `keywords`
GROUP BY `keyword`

Conclusion: groups are smaller
(equals operator used to compare keywords).

Example output:

Show discussions ...

MySQL - soundex usage example

More complicated example

Native Advertising

🚀

Dirask - we help you to

solve coding problems.

Ask question.

❤️💻 🙂