I am looking for a formula that will help me match a long list of account names.

Have 2 sheets from data from separate databases, containing Account names. I know there are matches in Accounts from our database, that do not appear in the 2nd database. Spot checking a few i noticed many are matched account but the spelling and/or wording is slightly different.
- Using a VLookup "True" verdict is not sufficient to use
- I tried using the "Exact" verdict, but this was not helpful either

Any ideas for better find/match formulas to help minimize the manual checking for all 1200 rows of data.

Thanks again
RohanF