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 “leno” with Change Limit: [1] [2]

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

212 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
leno4733139(None) 
keno87926431keno
lend56233671lend
lenos56024861lenos
lens46146491lens
lent46360531lent
lento57223391lento
levo76820061levo
lino46343371lino
meno66031361meno
aeon45634612aeon
aero45435342aero
beano75421552beano
ben56554922ben_
bend76435262bend
bene66439492bene
bens65945702bens
bent67759912bent
bento75922952bento
blend85317452blend
blent76230952blent
cent67451012cent
cento76625172cento
cero66329452cero
deco76125972deco
demo77427552demo
den47554342den_
dene56643412dene
deni56929392deni
dens55945072dens
dent57158412dent
deny86027122deny
dino56036752dino
ego46726052_ego
en28052392_en_
end46834352_end
eng46726782_eng
enol45823822_enol
enow77819872_enow
ens37245922_ens
eon36052082_eon
fano75831692fano
fen66851352fen_
fend84832972fend
fens76139762fens
fino76034692fino
gen45950512gen_
gene56237222gene
genoa64315822genoa
genom83716842genom
genro64914032genro
gens55740072gens
gent56954392gent
genu55929072genu
glen56027202glen_
glens66519852glens
helo75332852helo
hen67555272hen_
hens75642572hens
hent76656382hent
hero74635782hero
jeon116821442jeon
ken76343982ken_
kendo105113222kendo
kenos95220622kenos
kens85435232kens
kent86846962kent
keto86223452keto
kino86233622kino
laevo849362laevo
land56337312land
lane45153332lane
lang56637382lang
lank84734452lank
lea37660182le_a
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leans55536252leans
leant56737782leant
leap66032682leap
lear47045952lear
leas45954182leas
lech96825442lech
led46254552le_d
lee36068142le_e
leek85331732leek
leer46239352leer
lees45455882lees
leet45957902leet
left76340482left
leg46446112le_g
legs56133692legs
lehr75514942lehr
lei36846382le_i
leis45739602leis
lek75640302le_k
leke85527402leke
leks85427602leks
leku86519912leku
lemon75618182lemon
lends65326252lends
lenes54738522lenes
lenis56326862lenis
lense54523432lense
lentos65317402lentos
leone55018822leone
lept66440882lept
les35663072le_s
lesbo739252lesbo
less45635102less
lest46956322lest
let36481472le_t
lets47147942lets
leu36047402le_u
leud57223422leud
lev66139422le_v
leva77020712leva
levy106418502levy
lewd85716592lewd
lex107943822le_x
ley66246812le_y
leys76430182leys
lez125541312le_z
lido56028162lido
lien45339802lien_
liens56525502liens
lilo46731562lilo
limo65529732limo
lin37967372lin_
line46965572line
ling57447962ling
lingo66022112lingo
link86943442link
linn46034592linn
linos55631502linos
lins47059052lins
lint416266232lint
liny78141322liny
lion46334442lion
llano5910602llano
lo28053442l__o
lobo67229862lobo
loco67030742loco
logo57931762logo
lone45849132lone
long56933342long
loo38359822l_oo
loon47344792loon
luna46229852luna
lune47140492lune
lung55732492lung
lunk86030722lunk
lunt46148842lunt
luny77324132luny
lynx1437422lynx
mano66536812mano
memo85924792memo
men59252852men_
mend75334032mend
menu65130232menu
mono66036722mono
nene45932062nene
neon47026422neon
no29353242__no
oleo46630482ole_o
ono36838032_ono
pen56558842pen_
pend75934532pend
pengo84317592pengo
pens65649642pens
pent66559072pent
peon65635242peon
pepo87622152pepo
peso66925822peso
plena75816392plena
pleon74216382pleon
redo56029362redo
rend56136572rend
rent46661242rent
repo66027542repo
segno64814742segno
sego56525182sego
sen36058522sen_
send55237292send
sene46848052sene
senor53822802senor
sent46963012sent
steno54716862steno
ten35856112ten_
tend56433772tend
tenon53320512tenon
tenor53620252tenor
tens45647412tens
tent46159862tent
vena76126292vena
vend86626422vend
venom103914862venom
vent76049052vent
veto76622992veto
vino76128432vino
wen66249602wen_
wend85330452wend
wens76337932wens
went76051872went
wino75933612wino
xenon122612452xenon
yen66847382yen_
yens75832262yens
zero134822472zero

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298722120.86034734.9
3Display Results2122120.0464608.7
 (SQL Overall)1786912121.186150666.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.