Can Cypher do phonetic text search with only a part of the text, without using elastic search?

Question

Say I have a job as financial administrator (j:Job {name: 'financial administrator'}).

Many people use different titles for a 'financial administrator'. Therefore, I want abovementioned job as a hit, even if people type only 'financial' or 'administrator' and their input has typos (like: 'fynancial').

CONTAINS only gives results when the match is 100% - so without typos.

Thanks a lot!

Answer 1

It took a while, this is how I solved my question.

MATCH (a)-[:IS]->(hs)
UNWIND a.naam AS namelist
CALL apoc.text.phonetic(namelist) YIELD value
WITH value AS search_str, SPLIT('INPUT FROM DATABASE', ' ') AS input, a
CALL apoc.text.phonetic(input) YIELD value
WITH value AS match_str, search_str, a
WHERE search_str CONTAINS match_str OR search_str = match_str
RETURN DISTINCT a.naam, label(a)