Hi
Welcome to the MedHelp forum!
Sharp groin and hip pain with limited and painful internal rotation of the thigh along with tingling can be due to several causes (not cancer) such as: osteoarthritis, tendonitis, muscle pull and strain, femoral neck stress fractures, sports hernia or hidden/occult hernia of oblique aponeurosis, or Obturator or ilioinguinal nerve entrapment.
You would need all or any of the following for diagnosis: Clinical examination by an orthopedic specialist, X-rays, blood tests, MRI or ultrasonnography.
MRI of pelvis will not pick up hip pathology unless targeted at that.
Hope this helps. Please let me know if there is any thing else and do keep me posted. Take care!
I wonder if your sciatic nerve has become impinged?