Data Mining table from List of Values

EvertonRosa Will have to research what is possible in Power Query. There is fuzzy matching available for Merge queries but seems like you might want things to be more customized. Might have to do something with a custom function. I'm not clear on whether your product description columns are identical for both tables or if they would be if you dropped the numeric digits and dash from the second table? From your description of what you want, it seems like nothing would match between the two tables or am I missing something?

In DAX, I created a highly customizable fuzzy matching pattern.

Fuzzy - Microsoft Power BI Community

In DAX you could use FIND or SEARCH to look for words in other columns as well.