1821 Norfolk/Long Island hurricane was probably close to the 1938 hurricane in strength when it hit NYC. It caused a lot of damage there, read the newspapers for that storm. It was estimated to have been a category 3 over NYC and Category 4 over Southern NJ. That would be the worst case scenario for Long Island/NYC and worse than Sandy.