select ename,job from emp where soundex(ename) = soundex('adams') or soundex(ename) = soundex('James') or soundex(job) = soundex('man')