Top Occuring Phrases/Words in a Column

[default_name]

Hello,

I have a very large database of items of different names and descriptions.
Some items are similar to others (ie: cable type X, blue, 3ft or cable type X, green, 9ft, or heat shrink sleeve,clear,55cm or main wire assembly,mft,out)

I have been browsing around online (including other threads here on this board), trying to find a way to implement similar functionality that this website has with strings of text:
https://www.online-utility.org/text/analyzer.jsp

This website outputs the "top phrases containing 8 words (without punctuation marks)", then 7 words, 6, words, etc, including a list of the single word occurrences.
But I would only be interested in:
top 30 "phrases containing 3 words (without punctuation marks)"
top 30 "phrases containing 2 words (without punctuation marks)"
as well as the top 50 most occurring words in the column

I have seen a similar method which involves INDEX and MATCH but that seems like overkill for a large spreadsheet.
Is there a VBA method that can do this?