I have a large customer list, and want to check for duplicate records that
might be slightly misspelled.

First I will use a formula that will check the first 8 or 10 characters of a
customer name and look for a match in the list.

Is there a formula that will look at a customer name and see if there is any
other customer that has 80% or 90% of the same letters.

I want to try to catch things like --

'The A One Bank' and 'A One Bank' - recognizing as the same customer

but also catch with the same formula

'The A One Bank' and 'A-One Bank Inc'