Ok, first off, I am working with a legitimate customer database. Real people who have really ordered stuff from my company, Ingersoll-Rand. Just so you know I am not a spammer. I am working with our sales team to de-dupe their customer database. However the duplicates it is filled with is not: 555 Some Street and 555 Some Street, but instead it might be:


555 Some Street
555 Some St.
555 Some Street, ste 666
555 Some St., Suite 666

etc...

You get the idea.

They will have human eyes with experience with the customers to vet list, but I would like to be able to at least flag the problem children and make their lives easier.

Any hints on how to attack this from a regex point of view?

Thanks in advance, Pat Rock

In reply to De Duping Street Addresses Fuzzily by patrickrock

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.