Hi

Can you please help me with this request


I have a string say "CHANGE MANAGEMENT ABC"


and also I have a list column with 1000+ data

A1 Change Management ABC
A2 Changemanagementabc
A3 Change
A4 CHANGE MANAGEMENT
A5 CHANGE.MANAGEMENT.ABC
A6 CHANGE ABE


so by comparing with the string that is "CHANGE MANAGEMENT ABC" from the list I should get the best three matches

In the above scenario, I expect to get

1) Change Management ABC
2) CHANGE.MANAGEMENT.ABC
3) Changemanagementabc

* The best three matches should consider space/special characters and ingnore case sensitivness


can you please help