Unveiling Similarity Search Agents: A Deep Dive