Replacing values in Query Editor

Hi there If I want to clean up a text field by removing text such as "CO" "LTD" "UK" I have an issue where if those values are within a word, they are also removed. I cannot include spaces either si...