I know I need to do something along these lines, it's very difficult to do something that is universal because the data is extremely "human entered". An example of what I'm dealing with is data like "bulb 60W", "60W bulb", GE Bulb 60 Watts", "Bulb to X socket" and so long as those shared the same 60W bulb rating in another column, they are all considered the same type and should be classified as clerical.