Where X is unknown.
I have 47,881 rows.

I have used =COUNTIF(A1:A47881,"*"&"search phrase"&"*")
with success.

However, this is suggesting I know what "search phrase" is.

The cell could contain any number of medical diagnoses, so I want to run a search the most common matches.

Example, I want to see how many times HYPERTENSION appears in ANY of the cells, or ASTHMA, or even DIABETES.

Since the number of searchable cells is so large, using =SUMPRODUCT((A1:A47881)/COUNTIF(A1:A47881,A1:A47881&"") takes way too long to even see if it works.

What I would love, if possible, is to be able to see the top 100 most commonly used words within the sheet. There is only one column that is being searched so there's nothing else to compare it to except another A column.

Thanks in advance...
an over-zealous excell user

----- EDIT -----
I should probably clarify that the cells in column A could have up to a whole paragraph of unformatted text.

EXAMPLE OF CELL Ax:

HYPERTENSION #401.9
LOW BACK PAIN #724.2
PREGNANCY #V22.2
PPD-NOS
CONT MEDICATION

[END EXAMPLE]
Of course in Excel the format would look more like
...etc.

Doc