Novocaine was discovered as a safer alternative to cocaine for use as a local anesthetic. It became highly important to dentists for pain management. However, a similar experiment modifying a molecule of morphine revealed an even more effective pain-reliever. It was heroin.
A visual chronology of Asimov's ~1500 scientific inventions and discoveries.