Realization of text information similarity search by Oracle Full-text retrieval cut-word mechanism

Application Scenarios:

According to the keyword query similar to this keyword information, some of the keywords to exclude such as: "Limited", "limited liability Company", "Co., Ltd.", need to create an exclusion thesaurus table;

First step: Thesaurus table

Part II: Creating a function P_split_keyword

Part III: Keyword processing

Part fourth: Testing

SELECT * FROM (select ' Hebei Cangzhou Dong Plastic Co., Ltd. ', name,

SYS. Utl_match.edit_distance_similarity (' Hebei Cangzhou Dong Plastic Co., Ltd. ', name) similarity from TEST_PP t) Order by similarity DESC

Cond...

Realization of text information similarity search by Oracle Full-text retrieval cut-word mechanism