It does fit in a standard .22LR chamber. Some "target" or "match" grade guns have a short chamber so the bullet gets closer to the rifling. In these short chambered guns, the Stingers extra length can become a problem.
There aren't special guns made for Stingers. There are special match chambered guns that don't fit them. *edit* or several other "High Velocity" ammos.