Address matching patt

I'm using SQL server 2016 I have a customer table First Name,Address1,city state etc.. I have a list with customers with no ID's just names and addresses I need to see how many of them are in my table for the Address I did for example possible match

select PATINDEX('%123 main street%','123 main street APT9') --1

select PATINDEX('%123 main street%','123 main street #9') --1

select PATINDEX('%123 main street%','123 main st. APT9') -- 0

As you can see the last one return 0 but its looks like same address my question is how to make it true positive like the other two? Is there a function to determine that? I can't use SSIS I need TSQL

Thanks, Oded Dror