Oracle Query Using Like

Different databases have different ways of concatenating strings. In Oracle or Postgres, try this:

SELECT SUM(K.Score)
FROM Wreck_it_Ralph WIR, Keyword k
WHERE t_text LIKE '%' || k.word || '%'