store detective vs sherlock

store detective and sherlock both are nouns.

Word	Noun	Adjective	Verb	Adverb
store detective	Yes	No	No	No
sherlock	Yes	No	No	No

As nouns, sherlock is a hypernym of store detective; that is, sherlock is a word with a broader meaning than store detective:

store detective: a private detective employed by a merchant to stop pilferage
sherlock: someone who can be employed as a detective to collect information and assist in criminal investigations

Other hypernyms of store detective include operative, PI, private detective, private eye, private investigator, shamus.

store detective (noun)	sherlock (noun)
a private detective employed by a merchant to stop pilferage	someone who can be employed as a detective to collect information and assist in criminal investigations