ON LEFT(l.name_normalized, 4) = LEFT(r.name_normalized, 4)