How to find matching columns from two tables

[nh27]

I have two tables, let's call them TableA and TableB.

In Table A, I have two columns, column one consists of an address and column 2 consists of a zip code.
In Table B, I also have the same two columns, however the naming of the address may differ slightly in naming convention.

Both tables have a country column which I have linked to a country lookup table.

In Table B, I also have a 3rd column which contains additional numerical value.

I am trying to link Table A and B to see which records match.

Can someone recommend the most efficient way of doing this? I have tried to Clean/Trim the data and then merged both queries with an inner join but it's not matched many records as I hoped. Wondering if there is a more efficient and successful way of doing this?

Thanks in advance

[Greg_Deckler · Accepted solution]

@nh27 Try using fuzzy matching. It's built into Power Query. I also have a DAX version. Fuzzy - Microsoft Fabric Community. 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[nh27]

Thanks @Greg_Deckler the fuzzy match done the trick, learn something new everyday!