New answers tagged address
I do not think you can do that in ArcGIS OTB functionality. It requires perfect matches. It is sort of like the COMPGED function and as far as I know it is not built into Arc. Maybe if you do the join in another software that supports this function (SAS?)(http://www.lexjansen.com/nesug/nesug11/ps/ps07.pdf) then you will have more success. Check out this ...
Have a look at the Overpass API. It is designed for regional and thematic filtered download of OSM data. Keep in mind that the address coverage in OSM varies from country to country.
Top 50 recent answers are included