Hi @WestCoastIFS 

I would suggest below options.

    1.    Standardization: Make sure all addresses are written in the same way, like including the street number, street name, city, and postal code. You can use tools or APIs, such as Google Maps API, to help format the addresses correctly.
    
    2.    Data Entry Controls: Use drop-down menus for options like country, state, or city to minimize mistakes. Make certain fields required to ensure all important information is collected.

I'm happy to share my advice on this issue. If you found the answer helpful, please mark it as the correct answer. This will allow us to close the thread and make it easier for other community users to find and benefit from in the future.

Regards 

Chanuka