Fuzzy Matching

posted Aug 2, 2010, 1:08 PM by Ezra Kenigsberg
So there's a bit of fuzzy-matching code in Synchronizer already--try using the Metaphone() and GetFuzzyCompanyName() functions in any query for a sample--but what I'd really like to do is get that fuzzy-matching logic into Salesforce, so that de-dupe work doesn't require constantly exporting and importing data.

  • making it behave a bit more like DemandTools does;
  • figuring out how to work more gracefully with governor limits (if I try to process more than 5-10 recs at once, I get a too-many-lines error).
This is all rather educational for me; my Apex/Java code skillz are beginner-level, so any advice is welcome!