We report an original design approach based on the modal dispersion curves for the development of long period gratings in transition mode near the dispersion turning point exhibiting ultrahigh refractive index sensitivity. The theoretical model predicting a giant sensitivity of 9900 nm per refractive index unit in a watery environment was experimentally validated with a result of approximately 9100 nm per refractive index unit around an ambient index of 1.3469. This result places thin film coated LPGs as an alternative to other fiber-based technologies for high-performance chemical and biological sensing applications.