Automatically group text with words in common

[Anonymous]

I think this is a long shot but I am going to ask anyway. I have a dataset with a list of computers in our company and what software is installed on each computer. There are over 27,000 unique softwares in this dataset, but many of them are similar. For example, there are over 1,200 unique software names that contain 'ArcGIS', some of which are updates and different versions of the same software. 

I there a way to automatically group softwares with a common word, such as 'ArcGIS' or 'Firefox' without me having to go through and figure out what words to group by? 

Install Date	Installed On	Software Name	Software ID
2022-06-29	f6de9bb21bc4441052b33224cc4bcba5	Autodesk App Manager	252c67fc471fcd90e9d97134846d430c
2021-11-18	2e4f2e881b8c1850947d41d8cd4bcb58	ArcGIS Desktop 10.6.1 TLS Patch	42a572721b8404108f40fc49cc4bcb72
2022-10-03	9f5c2a2587a01d90227d87b7cebb35dd	ArcGIS Desktop 10.5.1	2b0fb2761b00441052b33224cc4bcbfb
2021-09-01	f6de9bb21bc4441052b33224cc4bcba5	Adobe Character Animator 2020	7ecfb79d472011d4e9d97134846d43a0

--

[wdx223_Daniel]

= let SoftList={"Autodesk","ArcGIS","Adobe"},fx=(t)=>List.PositionOf(SoftList,t,0,(x,y)=>Text.Contains(y,x)) in Table.Group(SampleData,"Software Name",{"tbl",each _},1,(x,y)=>Value.Compare(fx(x),fx(y)))

you can add new software name in the SoftList

[Anonymous]

Is this for a new column or a new table?

[Anonymous]

I was hoping there was a way to get it to automatically create the list of softwares so I don't have to manually search through 27,000 software instances to figure out what to group them by