SCOTT@orcl12c> CREATE TABLE domain_index_test
  2    (id	 NUMBER,
  3  	column1  VARCHAR2(30))
  4  /

Table created.

SCOTT@orcl12c> INSERT ALL
  2  INTO domain_index_test VALUES (1, 'French')
  3  INTO domain_index_test VALUES (2, 'French and business')
  4  INTO domain_index_test VALUES (3, 'Business French')
  5  INTO domain_index_test VALUES (4, 'French and economic science')
  6  INTO domain_index_test VALUES (5, 'Francais')
  7  SELECT * FROM DUAL
  8  /

5 rows created.

SCOTT@orcl12c> BEGIN
  2    CTX_DDL.CREATE_PREFERENCE ('test_mcds', 'MULTI_COLUMN_DATASTORE');
  3    CTX_DDL.SET_ATTRIBUTE ('test_mcds', 'COLUMNS', 'column1, ''start '' || column1 startcol');
  4  END;
  5  /

PL/SQL procedure successfully completed.

SCOTT@orcl12c> CREATE INDEX test_idx ON domain_index_test (column1)
  2  INDEXTYPE IS CTXSYS.CONTEXT
  3  PARAMETERS ('DATASTORE  test_mcds')
  4  /

Index created.

SCOTT@orcl12c> SELECT id, column1,
  2  	    DECODE
  3  	      (score,
  4  	       0, 1,
  5  	       DECODE
  6  		 (UTL_MATCH.EDIT_DISTANCE (UPPER (column1), UPPER ('French')),
  7  		  0, 4, score)) score
  8  FROM   (SELECT id, column1, MAX (score) score
  9  	     FROM   (SELECT a.*, 3 score
 10  		     FROM   domain_index_test a
 11  		     WHERE  CONTAINS (column1, 'start ' || 'French') > 0
 12  		     UNION ALL
 13  		     SELECT a.*, 2 score
 14  		     FROM   domain_index_test a
 15  		     WHERE  CONTAINS (column1, 'French') > 0
 16  		     UNION ALL
 17  		     SELECT a.*, 1 score
 18  		     FROM   domain_index_test a
 19  		     WHERE  CONTAINS (column1, 'French') = 0)
 20  	     GROUP  BY id, column1)
 21  ORDER  BY score DESC
 22  /

        ID COLUMN1                             SCORE
---------- ------------------------------ ----------
         1 French                                  4
         4 French and economic science             3
         2 French and business                     3
         3 Business French                         2
         5 Francais                                1

5 rows selected.