How to equate several words?

Question

excel

Good afternoon.
There are several spellings of the word:
Aulor is the correct variant,
but there are also incorrect input options in the table:
Au10r, Aul0Г, Au1oг ....
How to make all spellings equated to the correct variant, or automatically corrected when added?
Table example Customer : amount

Au10r : 1105
Vaal : 522
Aul0Г : 2051
Karp : 110
Au1oг : 146

And the result:

Aulor : 1105
Vaal : 522
Aulor : 2051
Karp : 110
Aulor : 146

Answer 1

The task is not easy, and if in a general sense, it is also unsolvable, because only you know what is right .
And on the topic, you can read about the Levenshtein distance

Answer 2

The task is not easy. It depends on how many correct options you have and what variations exist for the wrong ones.
It is necessary to identify a pattern and distinctive parameters by which it can be compared with the correct option.
Based on your example, where there are not so many values, then I see a similarity in the first two characters of Au. There is only one Aulor of such first two symbols in the Correct variants. So if you write a formula opposite all the wrong and right options, you will find the correct value.
For example, in correct variants, use LEFT to specify the first two characters.
Further, in the wrong options, look at the first two characters of the value and look for the correct one in the correct ones. I usually use INDEX and MATCH.
For example Index('reference to valid values) ; MATCH (LEFT('wrong value'; 2);'reference to 2 characters of the array of correct values';0);1)
Something like this.