Anyone with SOUNDEX() experience?

I’m trying to find some records based on property address. The property address string contains the numeric street number as well as street name. I’ve got it set to check within the exact state/city/zip combo and soundex(prop_address) must match, but its returning WAY too many results for my liking, apparently everything sounds the same? Does anyone have any input on this function I may find useful?

heres what I was running, with real data though of course

soundex(TRIM(REGEXP_REPLACE(UPPER(P.PROPERTY_STREET_ADDRESS), '( ){2,}', ' ' )))||'-'||p.city_name||'-'||p.property_alpha_state_code||' '||p.property_zip_code in (
soundex('1234 STREET NAME')||'-CITYNAME-OH xxxxx',

Soundex probably isn’t great for street names – it was really designed to handle last names for the census bureau. You might want to look at other phonetic algorithms, or just look into paying for an address correction tool to normalize them; it is probably worth it.

Yeah I gave double metaphone a try to no avail. Thanks!