title: Need to Search a Text Field in Teradata SQL against a list of words and return that word
body: <p>I am searching a large database for a list of words of varying length between 5-7 characters. 
  So far, I have:</p>
  
  <pre><code>Select *
    from sometable
   Where upper("Description") like any ("%ABC_123%", "%ABC_124%", "%DE_25%")
  </code></pre>
  
  <p>I would like to also return the word that was found in the query but am stuck on how to do this without duplicating the list of words in a subtr function. </p>
  
  <p>There is probably a much better way of doing this and I'd appreciate some direction.</p>