

A waterspout is a tornado, over water usually a non-supercell tornado. Waterspouts do not suck up water; the water seen in the main funnel cloud is actually water droplets formed by condensation. It is usually weaker than its land counterparts.
Waterspouts that do not come from the turning updraft of a supercell thunderstorm, are known as "non-tornadic" or "fair-weather waterspouts", and are by far the most common type.
Fair-weather waterspouts are usually form from tall cumulus clouds with dark, flat-bottoms.

Sometimes a regular tornado, made by a supercell, just happens to be on water. This is called a tornadic waterspout. It could have formed on water or moved there from land. Waterspouts like this can be big and cause a lot of destruction if they hit land. They occur a lot less than non-tornadic waterspouts.
A winter waterspout, also known as a snow devil, an icespout, an ice devil, a snonado, or a snowspout, is a very rare meteorological phenomenon in which a vortex from snow develops that looks like a waterspout. One does not know much about this rare happening and there are only six known pictures of this event so far.
There are three main things that produce a winter waterspout: