A "shiny" fossil found in an Alabama creek has been identified as the tooth of a large dinosaur that doesn't quite belong at the site, experts say.