Depending on the model this LoRA can vary between very wet looking dresses, or dresses that are straight-up formed out of water itself.
The main tag is water dress, but extra tags like transparent, rippling, dripping can help with the effect. See the example images for ideas.