In what movies does Adam Sandler play as a retard in?

He was a few fries short of a happy meal in "Little Nicky", not retarded but dumb as a box of rocks. He is not really retarded (except socially) in "Waterboy" and he does p college exams, but as they say, "He ain't never been nowhere and ain't never done nothin'".