Red wine vinegar is probably the closest for taste, but the color obviously can be an issue. If you are trying to get rid of vinegar all together then try using lemon or lime juice, just use a smaller amount.
I have always used apple cider vinegar as a substitute for white wine vinegar when cooking. It has a slightly different taste, but never one that I've found to be unapealing in anything I've tried. It's suposedly more healthy for you as well.
You should use apple cider vinegar due to the similar sweet flavor and rich taste qualities.Both can be also used in pickling or canning, as can almost any vinegar.
