This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Clean up the addresses in both datasets to a standard value
Translate the addresses into latitude / longitude then compare these coordinates instead
Both of these solutions can be accomplished either with tools in the Address tool palette if you have the additional license for the CASS dataset (CASS tool & Street Geocoder tool) or by making API calls to Google or Bing Maps.
Hmm I bet there is a way to get this accomplished without using a Fuzzy Match, the question more is it worth the trouble? In addition to parsing out the City from the Street address, what you would need to do is create a series of Look-up tables to standardize the Street and Cardinal Direction abbreviations. The process would look something like a series of Find-Replace Tools to correct the address, then a join tool once the addresses from the two datasets look the same.
Sometimes the Fuzzy Match tool gets a bad wrap of being very difficult. I will point out that it is equal parts art and science, however, addresses are some of the easier fuzzy matches to establish. I would recommend trying it if creating the look-up tables prove to be too much work. Here is a great training led by Nick Smith.