Matching rows by sound

With the SOUNDEX function, you can match rows by sound. For example, suppose a phone message was left for a name that sounded like "Ms. Brown". You could execute the following query to search for employees that have names that sound like Brown.

List employees with a last name that sound like Brown

In Interactive SQL, execute the following query:

SELECT Surname, GivenName
   FROM Employees
   WHERE SOUNDEX( Surname ) = SOUNDEX( 'Brown' );

Surname	GivenName
Braun	Jane

The algorithm used by SOUNDEX makes it useful mainly for English-language databases. See SOUNDEX function [String].

Discuss this page in DocCommentXchange.