Perform Storage, and Camera Lock with the Wind Waker. Get into a body of water, and hold Up on the analog stick. Link will begin to spin around rapidly, gaining speed with each turn. When you're satisfied with your speed, release the analog stick with Link's back pointing where you want to go, and Link will rocket backwards with the speed you attained. You can better judge where you're aiming by opening up your map.
Pressing alternate directions on every other frame while swimming will also cause Link's speed to increase exponentially. This is barely possible on console using lots of pauses, however, and will likely never be worth doing. However it is possible to emulate such an affect by resetting the neutral position of the analog stick using Black Wind. If the correct analog stick angle is acquired, you can then mash down on the analog stick to build up speed. Using Storage will also give you this same effect due to the way the camera works while the glitch is active.
The following graph illustrates the correlation of frames and overall velocity for one air gauge worth of time:
The only limit to the speed you can gain is your air meter, and the positioning of the land, including things you can climb up on out of water. You can continuously refresh your air meter if you happen to swim close to the shore of an island without going on land. If you Superswim up on land, your speed is retained, and Link will run backwards. If you go off an edge or back into the water while on land, your speed will reset back to 0. With enough speed, it is possible to reach an island before it loads. Using this allows to be loaded underneath an island, similar to a Wind Waker dive.
A TAS would use superswimming to cross vast amounts of overworld extremely quickly (much faster than sailing). The sail is still a necessary item, however.