SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Always A Novice bronze trophy
    K. Wolfe's Avatar
    Join Date
    Nov 2003
    Location
    Columbus, OH
    Posts
    2,075
    Mentioned
    53 Post(s)
    Tagged
    0 Thread(s)

    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?

    edit:
    heres what I was running, with real data though of course
    Code:
    where
    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',

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,576
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    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.

  3. #3
    Always A Novice bronze trophy
    K. Wolfe's Avatar
    Join Date
    Nov 2003
    Location
    Columbus, OH
    Posts
    2,075
    Mentioned
    53 Post(s)
    Tagged
    0 Thread(s)
    Yeah I gave double metaphone a try to no avail. Thanks!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •