Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “jejune” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
jejune123376(None) 
jejuna1243241jejuna
jejunal1342832jejunal
jejunely1741652jejunely
jejunum1542082jejunum
jujube1442412jujube
retune69121952retune
abjure1536733abjure
adjure1435833adjure
aedine73218393aedine
attune637983attune
bedunce1235683bedunce
begone9512133begone
beguine1068503beguine
begun85113443begun_
beigne9148613beigne
bemuse1038943bemuse
bene66439493be__ne
benne76521123be_nne
ceruse83914523ceruse
cetane8315283cetane
cohune1189423cohune
debone93714783debone
debunk1365113debunk
decane93818873decane
deduce1079253deduce
define104718143define
defund11447983defund
defuse105712723defuse
defuze19487843defuze
dejeuner1682933dejeuner
delude81910673delude
deluge8189403deluge
deluxe14197303deluxe
demure9311533demure
dene56643413de__ne
denude8169353denude
depone93616553depone
depute94512303depute
deuce84517493de_uce
dune56137583__dune
educe84313453_educe
elude64517623_elude
elute54822573_elute
enure53520223_enure
equine151711573_equine
erne46727423_e_rne
esne47018793_e_sne
etude63612303_etude
exine125518493_exine
exude134010293_exude
eyne76322463_e_yne
fecund1235433fecund
feline94820143feline
ferine96422583ferine
ferule93413203ferule
gene56237223ge__ne
genuine838373genuine
gerund836163gerund
heaume1137543heaume
hexane16379533hexane
hexone16289233hexone
immune1035433immune
injure133410863injure
jane115031473__jane
jaunce15367433j_aunce
jaunt125025273j_aunt
jean116629283je_an_
jeaned143813463je_aned
jeans126022113je_ans
jee106648643je___e
jeeing144512143jeeing
jeepney1942093jeepney
jefe146516883je__fe
jehu145614863jehu__
jehus15488573jehu_s
jejunity1742453jejunity
jennet134714953je_nnet
jenny153811623je_nny
jeon116821443je_on_
jesse126012833je_sse
jesuit1339583jesuit
jete115927253je__te
jeton124815403jeton_
jetons134512613jetons
jeu105532073je_u__
jeux184311273je_u_x
jewing174411423jewing
jocund1633623jocund
joule124918203j_oule
jounce153310733j_ounce
jube136322783__jube
juju103612123juju__
jujubes1542083jujubes
jujus11347463juju_s
juke154721663__juke
jun105932063__jun_
junk155121033__junk
jupe134921003__jupe
jute115327893__jute
kerne94718213ke_rne
ketene106613003ketene
ketone105014533ketone
kune85424573__kune
lacune8169673lacune
lagune7158633lagune
legume936913legume
leone55018823le_one
lune47140493__lune
mesne75116293me_sne
nebule848753nebule
nene45932063ne__ne
neume74414403ne_ume
penne75423853pe_nne
perjure16327963perjure
peruke123210393peruke
peruse84016843peruse
premune1138933premune
prune75119633_prune
rebuke124010123rebuke
recane83022873recane
recuse85519163recuse
redone74820053redone
reduce9713253reduce
refine95225693refine
refuge105312613refuge
refund104810303refund
refuse94817513refuse
refute95515703refute
rehung1036343rehung
rejudge1634023rejudge
reline65434353reline
relume8313273relume
repine85627813repine
repute84716093repute
rerun58722153rerun_
reruns66413743reruns
resume8313783resume
retene69224273retene
retine66237333retine
retuned86613973retuned
retunes76918403retunes
retuse66617223retuse
reuse56025363re_use
revue81114453revu_e
rexine134719443rexine
rezone153814783rezone
rune45236293__rune
secund937103secund
secure8513533secure
seduce9610023seduce
segue6314413segu_e
seine55732873se_ine
sejant133114483sejant
sene46848053se__ne
serene63522353serene
serine65432673serine
tenure6311613tenure
terne56426153te_rne
triune64210183triune
tune45635863__tune
untune62511603untune
velure939773velure
venene92912523venene
venine93718433venine
venue84918213venu_e
venule94411763venule

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1561145455.1
2DLD Change Limit1127161675.78319490.9
3Display Results1671670.0463630.4
 (SQL Overall)1786911675.98529856.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.