Row matching 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.

Note

The algorithm used by SOUNDEX makes it useful mainly for English-language databases.

Example

In Interactive SQL, execute the following query to list employees with a last name that sound like Brown:

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

Surname	GivenName
Braun	Jane

Row matching by sound

Note

Example

See also