Something to get you started:Put the keywords into a table and join with that table. See the example below. If you have more than one keyword to be removed in a single sentence, the update statement would need to be run multiple times. Also, it is not quite perfect - if a keyword happens to be the starting or ending portion of a sentence, that gets replaced as well.CREATE TABLE #keywords(word VARCHAR(32));INSERT INTO #keywords VALUES ('Blu R'),('Dvd'),('Blu Ray'),('Dvd/bl'),('Dvd & Blu'),('D/b'),('Dvd Box Se'),('Dvd & Blu Ray'),('D/bl'),('D/');CREATE TABLE #test(sentence VARCHAR(255));INSERT INTO #test VALUES ('Bad boys dvd'),('Advd'),('xyz');UPDATE t SET sentence = COALESCE(REPLACE(REPLACE(t.sentence,' '+word,''),word+' ',''),t.sentence)FROM #test t LEFT JOIN #keywords k ON t.sentence LIKE '%'+k.word+'%'SELECT * FROM #test;DROP TABLE #testDROP TABLE #keywords