See Bulletpusher's answer
They are totally different cartidges.
The 38 Special is extremely common- and it's chambered almost exclusively in revolvers.
38 Super ammo is still made, although it's far less common- and it's chambered almost exclusively in semi autos.