I have a problem and I have yet to solve it with String::Approx. We have 2 or 3(if not more) databases with Physician and/or Group Names. Of course no one can adhere to a common way of entering the data so now I'm left with matching up the 2-3 different ways the data is entered. I've tried and tried...and tried to get all the names to match but haven't found a way that works 95% of the time. Does anyone know something that could match these samples: 

SD Physicians Med Grp-NC
San Diego Physicians Medical Group-North Coastal
SD Phys Med Grp-NC

[download]

And this is just one sample. Each Physician/Group Name could be spelled many different ways but I can't figure out how to match them up. I've tried compressing the string to not include any spaces and puncuation. Then sort the letters and check if to see if at least 90% of the letters are in both. Then there is the problem that some databases/spreadsheets input a name First Middle Last, Title. And others Last, First Middle, Title. If anyone has any ideas please let me know. Thanks

In reply to Matching Names by jakeeboy

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.