Aperture Assistant can find and tag duplicate Masters in your Aperture Library, whether the Masters are managed, referenced or even offline.
More details here.