The .38 Super is a completely different animal than the .38 Special is. .38 Super is a semi-automatic cartridge with a semi-rimmed, tapered case 23mm in length while the .38 Special is a revolver cartridge with a rimmed, straight-walled case 29mm in length. .38 Super will drive a 130grn .355 diameter bullet at 1200-1300fps from a 5" semi-automatic barrel while .38 Special will drive the same weight bullet at 800-900fps in standard pressure loadings and 900-1000fps in +P loadings from a 4" revolver barrel.
.38 Super is comparable in ballistics to a hot-loaded 9mm +P or +P+ or a .357 Sig. Unlike the latter two cartridges, however, the .38 Super's overall length requires a larger frame gun like those of a .45 ACP or 10mm Auto. The .38 Super is most commonly encountered in a 1911-type platform and, in single-stack magazines, will usually have a magazine capacity of 8-10 rounds.
The .38 Super was developed by Colt in the 1920's by simply loading the older .38 ACP cartridge to higher pressure. The cartridge was introduced in the Government Model semi-automatic pistol (1911) in response to the needs of law enforcement for a more powerful handgun that could reliably penetrate the car bodies of the day. Similar circumstances surrounded the introduction of the .357 Magnum cartridge by S&W but it ultimately became much more popular than the .38 Super due to its ability to accept .38 Special ammunition as a subload, greater power, and chambering in revolvers rather than semi-automatics (revolvers remained the favored arm of police until the 1980's and early 1990's).
The .38 Super did enjoy a resurgence in popularity among competitors in the action-oriented shooting sports. This was because it could more easily make major power factor than the 9mm but offered less recoil and higher magazine capacity than most of the larger calibers like .45 ACP and 10mm Auto.
As a self-defense cartridge, the .38 Super is excellent though ammunition selection and availability are much more limited than more mainstream cartridges like 9mm, .40 S&W, .357 Sig, .45 ACP, .38 Special, and .357 Magnum.