[Igi Noumi]

Option 2

But how can I extract the most similar words from the ordered list in this case?

Or do you mean first by matching, and then a macro that will display the similarity percentage in a separate column?

[Igi Noumi]

I’m asking EI about a macro that would process a document with tens of millions of rows and display the similarity percentage in a separate column. He says it would be very slow using the Levenshtein algorithm.

So I want to know how I can initially filter the database using the program’s powerful tools.

[Igi Noumi]

For example, how can I make similar strings categorized so that the column appears clearly and shows the percentage similarity of the words?

So that I can quickly select from 80 to 90 percent similarity.

[Igi Noumi]

You can’t find an answer to this question on the internet, only those who have used it can answer

[Igi Noumi]

Are there Telegram channels or other places where I can ask questions or get advice?

Since there’s not much activity here with answers.

[Author]

Posts