I have a column of single words that I would like to filter a bit. It is like a duplication search but I am not searching for only the exact matches but I would like to filter the substring matches as well.
What I mean is for example I have the words “accomplish”, “accomplished”, “accomplishment” and from these ones I need only the “root” word, so the “accomplish”, all the others must be removed from my list.
Could you please help me how should I do this?
Thank you for your help in advance!