title: How can I check how many words in common two strings have in Bigquery?
body: <p>I have a list of documents in a Bigquery table. Some of those have very similar names. I need to check each pair of documents, and see how many words they have in common, so I can suggest eliminating one of those.</p>
  
  <p>For instance:</p>
  
  <pre><code> Spreadsheets
   Quality Control.xlsx
   Product Structure.xlsx
   Invoices Sent April.xslx
   Invoices Sent March.xlsx
   Total Costs April.xlsx
   Total Costs March.xlsx
   Process of Quality Control.xlsx`
  </code></pre>
  
  <p>I would have the result like</p>
  
  <pre><code> Spreadsheet                        |Matching Spreadsheet             |Words
   Quality Control.xlsx               |Process of Quality Control.xlsx  |2
   Product Structure.xlsx             |null                             |null
   Invoices Sent April.xslx           |Invoices Sent March.xlsx         |2
   Invoices Sent March.xlsx           |Invoices Sent April.xlsx         |2
   Total Costs April.xlsx             |Total Costs March.xlsx           |2
   Total Costs March.xlsx             |Total Costs April.xlsx           |2
   Process of Quality Control.xlsx    |Quality Control.xlsx             |2
  </code></pre>