I need some help with full text search.
I have created an index like so:
CALL db.index.fulltext.createNodeIndex("ReasourceName",["Resource"],["name"])
I can query it and get results:
CALL db.index.fulltext.queryNodes('ReasourceName', 'bmc pumping station~') YIELD node, score
WITH node, score
RETURN node.name, score
limit 10
output:
ββββββββββββββββββββββββββββββββββ€βββββββββββββββββββ
β"node.name"β"score" β
ββββββββββββββββββββββββββββββββββͺβββββββββββββββββββ‘
β"BMC Pumping Station" β8.143752098083496 β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"BMC Office" β2.944127082824707 β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"BMC Office" β2.944127082824707 β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"BMC Dispensary" β2.944127082824707 β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"BMC Office" β2.944127082824707 β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"BMC Dispensary" β2.944127082824707 β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"BMC Office" β2.944127082824707 β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"Police Station" β2.6569595336914062β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"Momo Station" β2.6569595336914062β
ββββββββββββββββββββββββββββββββββΌβββββββββββββββββββ€
β"BMC Shikshak Bhavan" β2.515393018722534 β
ββββββββββββββββββββββββββββββββββ΄βββββββββββββββββββ
However it performs poorly if the input query differs in whitespace. For example, I would expect the query "bmcpumpingstation" to have a similar result set, however it returns nothing.