Find all family names in Family that sound like “Joan”.
SELECT family_name FROM family WHERE SOUNDEX(TRIM(family.family_name)) = SOUNDEX('Joan');
Result:
family_name ----------- John Joan Joanne
Find all family names in Family that sound like “Joan”.
SELECT family_name FROM family WHERE SOUNDEX(TRIM(family.family_name)) = SOUNDEX('Joan');
Result:
family_name ----------- John Joan Joanne