Oracle Text Search - fuzzy results not having exact length
-1
i am currently using fuzzy search like my search criteria is 'mine' here.
select * from media_detail where contains(description,'fuzzy(mine)')>0;
it returns me
mine
mini
mani
where as i want these to be included in result like
mine
mini
mani
mining
minded
minimum
miner
min
nine
sql oracle search
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
add a comment |
-1
i am currently using fuzzy search like my search criteria is 'mine' here.
select * from media_detail where contains(description,'fuzzy(mine)')>0;
it returns me
mine
mini
mani
where as i want these to be included in result like
mine
mini
mani
mining
minded
minimum
miner
min
nine
sql oracle search
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
add a comment |
-1
-1
-1
i am currently using fuzzy search like my search criteria is 'mine' here.
select * from media_detail where contains(description,'fuzzy(mine)')>0;
it returns me
mine
mini
mani
where as i want these to be included in result like
mine
mini
mani
mining
minded
minimum
miner
min
nine
sql oracle search
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
i am currently using fuzzy search like my search criteria is 'mine' here.
select * from media_detail where contains(description,'fuzzy(mine)')>0;
it returns me
mine
mini
mani
where as i want these to be included in result like
mine
mini
mani
mining
minded
minimum
miner
min
nine
sql oracle search
sql oracle search
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
edited Nov 26 '18 at 13:57
rykhan
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
asked Nov 26 '18 at 8:37
rykhanrykhan
119214
119214
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
0
see if this is ok:
table ns_words
mine
mini
mani
nikhil
sugandh
mining
mining
CREATE INDEX myindex2 ON ns_words(a) INDEXTYPE IS CTXSYS.CONTEXT;
select * from ns_words where contains(a,'fuzzy(mine)')>0 or
contains(a,'fuzzy(mining)')>0;
output:
mine
mini
mining
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
noun and pronoun here is just an example here to understand, actually i need all those results in return which may be of exact length (like in case of fuzzy) or may vary in length with fuzziness.
– rykhan
Nov 26 '18 at 13:55
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477302%2foracle-text-search-fuzzy-results-not-having-exact-length%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
see if this is ok:
table ns_words
mine
mini
mani
nikhil
sugandh
mining
mining
CREATE INDEX myindex2 ON ns_words(a) INDEXTYPE IS CTXSYS.CONTEXT;
select * from ns_words where contains(a,'fuzzy(mine)')>0 or
contains(a,'fuzzy(mining)')>0;
output:
mine
mini
mining
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
noun and pronoun here is just an example here to understand, actually i need all those results in return which may be of exact length (like in case of fuzzy) or may vary in length with fuzziness.
– rykhan
Nov 26 '18 at 13:55
add a comment |
0
see if this is ok:
table ns_words
mine
mini
mani
nikhil
sugandh
mining
mining
CREATE INDEX myindex2 ON ns_words(a) INDEXTYPE IS CTXSYS.CONTEXT;
select * from ns_words where contains(a,'fuzzy(mine)')>0 or
contains(a,'fuzzy(mining)')>0;
output:
mine
mini
mining
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
noun and pronoun here is just an example here to understand, actually i need all those results in return which may be of exact length (like in case of fuzzy) or may vary in length with fuzziness.
– rykhan
Nov 26 '18 at 13:55
add a comment |
0
0
0
see if this is ok:
table ns_words
mine
mini
mani
nikhil
sugandh
mining
mining
CREATE INDEX myindex2 ON ns_words(a) INDEXTYPE IS CTXSYS.CONTEXT;
select * from ns_words where contains(a,'fuzzy(mine)')>0 or
contains(a,'fuzzy(mining)')>0;
output:
mine
mini
mining
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
see if this is ok:
table ns_words
mine
mini
mani
nikhil
sugandh
mining
mining
CREATE INDEX myindex2 ON ns_words(a) INDEXTYPE IS CTXSYS.CONTEXT;
select * from ns_words where contains(a,'fuzzy(mine)')>0 or
contains(a,'fuzzy(mining)')>0;
output:
mine
mini
mining
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
answered Nov 26 '18 at 9:23
nikhil sugandhnikhil sugandh
1,3262820
1,3262820
noun and pronoun here is just an example here to understand, actually i need all those results in return which may be of exact length (like in case of fuzzy) or may vary in length with fuzziness.
– rykhan
Nov 26 '18 at 13:55
add a comment |
noun and pronoun here is just an example here to understand, actually i need all those results in return which may be of exact length (like in case of fuzzy) or may vary in length with fuzziness.
– rykhan
Nov 26 '18 at 13:55
noun and pronoun here is just an example here to understand, actually i need all those results in return which may be of exact length (like in case of fuzzy) or may vary in length with fuzziness.
– rykhan
Nov 26 '18 at 13:55
noun and pronoun here is just an example here to understand, actually i need all those results in return which may be of exact length (like in case of fuzzy) or may vary in length with fuzziness.
– rykhan
Nov 26 '18 at 13:55
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477302%2foracle-text-search-fuzzy-results-not-having-exact-length%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
