Alternative to sql course

I am currently using sql cursor to find a table to update another table. I have a table that contains many phrases. I want to update another table to be set to 1 if any of these phrases hit any column in the update table. I am using cursor and char to find a phrase. The cursor takes a long time and I'm just wondering if I can use anything else instead of the cursor. Thank you. I am using sql server and here is the code

declare @word varchar(max)
    declare @aCursor cursor for
SELECT col from table
    open acursor
    fetch next from acursor into @word
    while @@fetch_status=0
    begin
SET @word = '' + @word + ''
UPDATE updatetable
SET updatecol = 'y'
FROM updatetable u, tableb b
WHERE u.id = b.id AND (CHARINDEX(@word, u.name) > 0 OR CHARINDEX(@word, u.city) >
    fetch next from acursor into @word
    end
    close acursor
    deallocate acursor