"Loose string matching" in two columns

[anf1sher]

I have data from two different sources in a table and I want to do a "loose pattern match".

For example, data in the first column might be "Harvard University" and data in the other column might he "Harvard U".

I want the two columns to show as a match even though they are not identical.

Does that make sense?

[Phil_Seamark]

Hi @anf1sher

There might be some R based functions that allow you to match as per your needs.  Have you done anything similar in other tools/languages?

[anf1sher]

I've done something similar in Perl but I haven't seen any way to do this in Power BI.

[Phil_Seamark]

Or would you be happy to match simply based on the sequence of characters from the shorter of the two?

[anf1sher]

I'm not sure I understand what you're asking.