Sheet Piling is an "in-suit" type of retaining wall.
Do not rely on their mass to retain the soil, as opposed to a gravity wall.
In-situ walls rely on their flexural strength to retain soil, supported either by their own penetration into the soil or by an anchoring system.
Other types of in-situ walls
Soldier pile walls - use H-beam to hold timber or concrete lagging to retain soil on a temporary or permanent basis.
Slurry walls - bentonite slurry is injected into a trench after which reinforcement and concrete are placed into the trench, forming a wall.