Who is good at Fuzzy Matching? Please help me :(

[rively90]

Hi,

Hi, I run fuzzy match tool and it's been running for 3+ hours and still keep going. What did I do wrong? what's the proper setting?

I'm trying to correct:

For example,

Correct: Los Angeles

Incorrect: Las Angelas

*Las Angelas is a typo. But, the tool will group them together to the correct one.

Second example:

Correct: Los Angeles@!#@!#

Incorrect: Los Angeles,CA

*I don't need to see ,CA there. Just the name of the city.

Third Example:

Correct: Edmonton

Incorrect: Edmonton Alberta

 *I don't need to see Alberta there. Just the name of the city.

Currently, the Route , Route Departure, Route Arrival, and Via are to be corrected.

There are a lot of typos in my data and just wondering the quickest way to handle this and almost impossible to me to correct one by one. Thank you!