title: Match the words in two columns oracle sql by breaking the string and comparing each word
body: <p>I have two columns in my table for instance <code>column_A</code> and <code>column_B</code></p>
  
  <p>Suppose <code>column_A</code> has data "best buy card credit" and <code>column_B</code> has "credit no take buy order",
  here i need to match the words in both the columns and return the number of matching words .
  In this case it should return 2 as "buy" and "credit" match.
  Can anyone please suggest sql code to do the same.</p>
  
  <p><strong>Please NOTE</strong>:  size of <code>column_a</code> and <code>column_b</code> is not fixed i.e the number of words in both might change.</p>