Compact groups in theory and practice – III. Compact groups of galaxies in the Sixth Data Release of the Sloan Digital Sky Survey