Keyword Search a single SQL Server table for multiple search terms and create a new table from results?
Your search:

SELECT col 
  FROM dbo.existing_table
  WHERE col LIKE '%keyword1%'
     OR col LIKE '%keyword2%'
     ...;


To put the results into a new table:

SELECT col
  INTO dbo.new_table_name
  FROM dbo.existing_table
  WHERE col LIKE '%keyword1%'
     OR col LIKE '%keyword2%'
     ...;