Parse words that have don't have spaces

I'm starting another project and haven't thought the best way through this.

I am using MS-SQL. I have a table with dictionary words that I can add or subtract words as needed.

I get data from a source where the words come in with no spaces.

ButThis for example. In this case I could get two results:

But This
Butt His

I would go about getting that?

We will have a look at this one for you

Thanks,
I am just in the brainstorming phase. I think there's a way to do that right in SQL though.

Dean

Having thought about it I think a separate transformation function would be the best approach
It will be based on lookup transformation

We still have not decided how to call it
Keyword transformation? Or Dictionary transformation...

Any suggestions?

I started working with in SQL. So if you run back to the db, for various combinations of characters. You'll hit the db a lot. 20 character word is about 517,000,000 combinations.

Then I was working with Chat (Open AI) and develop the code via SQL stored procedure. I was starting off by looking for word patterns. Then compare those results to in the dictionary tabel.

At this point I've decided not to work on this.