A detective was a person who investigated crimes so as to solve them, usually as part of an official police force. A private investigator was a freelance detective.
In the Victorian era, in London, the Silurian Vastra was known as "the Great Detective" (HOMEVID: The Great Detective) for solving crimes, sometimes alongside the Doctor, one of her oldest friends. (TV: The Snowmen, The Crimson Horror, Deep Breath)
Arguably, the most famous detective of the 19th century was Sherlock Holmes. (PROSE: All-Consuming Fire, Erasing Sherlock) During the War in Heaven Holmes' life was erased from time and turned into fiction, (PROSE: The Book of the Enemy) in the form of the writings of Arthur Conan Doyle. (PROSE: Evolution, Revenge of the Judoon, AUDIO: Jago in Love, COMIC: Character Assassin)
In 1920, detective Merrivale Carr investigated the apparent murders of Sebastian Marten and Paul Steiffers at Lord Farthingale's country retreat. The Ninth Doctor and Rose aided in the investigation. (PROSE: Doctor vs Doctor)