Coalesce a row of data based on the text in a column

I have the following information I need to coalesce on based on the Application/Software Name. The problem is the export I had got the data from lists multiple versions of each application. Is there a way to group based on the main portion of text in a cell? Say 70% the same text or so?

I'm up for any ideas or recommendations here, I have almost 10k records and I don't want to have to manually group the data myself. I've attached a screencap for reference.



Thanks in advance.