Can machine learning rewrite/recognize text to one truth

Question

Hi there,

My dataset has a lot of productnames, all the product of the shops are not written by the same.
So i want azure can recognize if it's the same:

So if the productgroup is X and productname looks like/contains tomato. The product is tomato.
Example: Tomatoes, tomato, bunch of tomatoes, a bag of tomatoes, small tomatoes = new colom tomato.

Hopefully someone can help me with this?

Thanks a lot.

Answer 1

@Borget Thanks for the details. With a variety of data inputs, Can you try fuzzy matching/regex’s or Azure Search would be a complete Information Retrieval engine. Azure Search works well for this.
but using full Lucene syntax you can do fuzzy and proximity search.
https://learn.microsoft.com/en-us/azure/search/search-query-lucene-examples