We must rely on an additional tool to flag and merge duplicate records with fuzzy matching addresses because the system sees "123 Sesame Street", "123 Sesame St", and "123 Sesame St." as 3 distinct addresses; we would be doing manual override/matches all and every day otherwise. It would be helpful if the system could parse out the building number and street name and ability to add (or just baked in) fuzzy/replacement values for the street names so Dr = Drive = Dr.; St = Street = St.; PO Box = P.O. Box = POB, etc.
We must rely on an additional tool to flag and merge duplicate records with fuzzy matching addresses because the system sees "123 Sesame Street", "123 Sesame St", and "123 Sesame St." as 3 distinct addresses; we would be doing manual override/matches all and every day otherwise. It would be helpful if the system could parse out the building number and street name and ability to add (or just baked in) fuzzy/replacement values for the street names so Dr = Drive = Dr.; St = Street = St.; PO Box = P.O. Box = POB, etc.