Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE WORDLIST (WORD) AS
  SELECT 'BROCCOLI' FROM DUAL UNION ALL
  SELECT 'ARTICHOKE' FROM DUAL UNION ALL
  SELECT 'BEET' FROM DUAL
3 rows affected

select regexp_replace('home care','home care','care') as column1,
           regexp_replace('home care','home care','home') as column2,
           regexp_replace('care home','care home','home') as column3,
           regexp_replace('care home','care home','care') as column4
      from WORDLIST w


COLUMN1
COLUMN2
COLUMN3
COLUMN4


care
home
home
care

care
home
home
care

care
home
home
care


SELECT s1.COLUMN1,
           s1.COLUMN2,
           s2.COLUMN3,
           s2.COLUMN4 
      FROM (select regexp_replace('home care','home care','care') as column1,
                   regexp_replace('home care','home care','home') as column2
            from WORDLIST) s1
      CROSS JOIN (select regexp_replace('care home','care home','home') as column3,
                         regexp_replace('care home','care home','care') as column4
                    from WORDLIST) s2


COLUMN1
COLUMN2
COLUMN3
COLUMN4


care
home
home
care

care
home
home
care

care
home
home
care

care
home
home
care

care
home
home
care

care
home
home
care

care
home
home
care

care
home
home
care

care
home
home
care

COLUMN1	COLUMN2	COLUMN3	COLUMN4
care	home	home	care
care	home	home	care
care	home	home	care
care	home	home	care
care	home	home	care
care	home	home	care
care	home	home	care
care	home	home	care
care	home	home	care