Remove words by substring list

Originally Posted by Glenn Kennedy

Is it necessary to include the case? Could you just not use LOWER($A2) instead of $A2?

I try LOWER and its enough for me, very nice. But I still have curiosity how to do this without touch capitalization in string.