title: Select similar like rows within the same table
body: <p>I am trying to write a query to find all USERS in a USERS table that are similar. Its like finding all non distinct rows but using a LIKE statement not an equals statement. Below is an example column of a USERS table</p>
  
  <pre><code> USERNAME 
  ------------
  tim.smith
  doug.funny
  tim.smith1
  dan.snyder
  tim.smith20
  doug.funny2
  emily.hunt
  </code></pre>
  
  <p>after query the output should look like this.</p>
  
  <pre><code>tim.smith
  tim.smith1
  tim.smith20
  doug.funny
  doug.funny2
  </code></pre>