title: Google Refine: merge two data sets on similar-but-different column?
body: <p>I've got two datasets, with common column name that are just slightly different. </p>
  
  <p>Dataset A:</p>
  
  <pre><code>Name,Number
  Hartlepool UA,306
  Tyne and Wear Met County,683
  </code></pre>
  
  <p>Dataset B:</p>
  
  <pre><code>Name,Number
  Hartlepool,366
  Tyne and Wear,353
  </code></pre>
  
  <p>I thought Google Refine / Open Refine was designed to help reconcile this sort of messy data in a fuzzy way, but <a href="https://stackoverflow.com/questions/10472601/google-refine-recipe-for-reconciling-messy-entities-in-two-databases">it seems not</a>. </p>
  
  <p>Is there any tool I can use to match these in a fuzzy way, without having to write code? I can write code easily enough if needed, but I'm surprised that Google Refine does not seem to do what I though it did. </p>