Let's start by exploring what address standardization is. It is the process of changing addresses to a uniform format. In mathematical and computer science terms, standardization is also referred to as a canonical model or schema that is a design pattern used to create an agreed data definition that will standardize communication for better business integration.
SQL Database queries are great at performing exact matches fast and accurately when addresses are in a standardized format. It is also easier for business analytics and developers to identify duplicate customers with uniformity to simplify the duplication (de-dupe) process to find and identify unique customers based on postal and delivery addresses.
In an ideal world, everyone would enter their full address in a consistent format but this is seldom the case. Below is a list of common user input inconsistencies that address data cleansing and address correction software resolve.
Addresses capitalization formatting can include lower case, upper case, camel case and mixed cases:
It is common that only the city is entered in all capital letters.
Abbreviations are one of the most common reasons for inconsistencies. Abbreviations can occur at any segment or fragment of an address, including the number, street name, road type, suburb and city:
Spelling mistakes can lead to an undeliverable address so it is important to correct commonly misspelled words such as city names and street names with swapped letters, missing letters or incorrect letters:
Addy uses advanced fuzzy address matching techniques to correct a range of typos.
Unit, street and city names can vary, yet still be correct:
As shown in the abbreviation section, address numbers can vary greatly which will lead to inconsistencies:
Another common issue is when address information is incomplete, missing the suburb, city or postcode:
Even though the postal services may still locate a poorly formatted address, there is a potential for delivery delays and additional charges. For example, if an incorrect postcode is entered, the mail sorting team may look at the postcode first to sort the mail to go to the right city first before realising that the address must be corrected and redirected again.
Having accurate addresses is so important that NZ post offers discounts when companies have accurate mailing addresses verified through the statement of accuracy (SOA) programme.
Using Addy's address finder API will help your customers to find their addresses up to 80% faster and ensure that accurate, validated and standardized addresses are captured at the start.
Addy also provides an address cleaning excel spreadsheet software for bulk address correction.