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 “lenos” 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.

178 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
lenos5602486(None) 
kenos95220621kenos
lends65326251lends
lenes54738521lenes
lenis56326861lenis
leno47331391leno_
lens46146491len_s
lentos65317401lentos
linos55631501linos
aeons57624652aeons
beanos85516512beanos
bends85628972bends
benes75536232benes
bens65945702ben_s
bentos86218302bentos
bents76033692bents
blends96012882blends
centos85920462centos
cents74730332cents
ceros74726072ceros
decos85522122decos
demos86022992demos
denes65639722denes
dens55945072den_s
dents65031802dents
dinos65428062dinos
egos55821652_egos
ends56528522_ends
engs56121392_engs
enol45823822_enol
enols54718402_enols
enow77819872_enow
enows85115492_enows
ens37245922_en_s
eons46638712_eons
epos66723732_epos
eros45238452_eros
fanos85926502fanos
fends96324972fends
fens76139762fen_s
finos86226952finos
genes65133092genes
genoa64315822genoa
genoas74013622genoas
genom83716842genom
genoms94412482genoms
genros74211332genros
gens55740072gen_s
gents65729612gents
genus65319832genus
glens66519852glen_s
helos84928062helos
hens75642572hen_s
hents87330742hents
heros84930862heros
kendos114510662kendos
keno87926432keno_
kens85435232ken_s
kinos96626142kinos
lands65426902lands
lanes54946792lanes
lanose6313592lanose
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182le_as
leeks95318892leeks
leers54828982leers
lees45455882le_es
leets54927122leets
lefts86517812lefts
leges64427282leges
legs56133692le_gs
lehrs86111132lehrs
leis45739602le_is
leks85427602le_ks
lemon75618182lemon
lemons84415052lemons
lend56233672len_d
lense54523432lense
lenses64620892lenses
lent46360532len_t
lento57223392lento
leone55018822leone
leones64417722leones
les35663072le__s
lesbos837402lesbos
leses54930812leses
less45635102le_ss
lets47147942le_ts
leuds66214812leuds
levis85818552levis
levo76820062levo_
lewis85315842lewis
lexes127225262lexes
lexis125916032lexis
leys76430182le_ys
lidos65219882lidos
liens56525502lien_s
lilos55821872lilos
limos75320812limos
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
lino46343372lino_
lins47059052lin_s
lints57137192lints
lions55923212lions
llanos6108332llanos
lobos75921842lobos
locos75822602locos
logos67225332logos
longs65527062longs
loons55731722loons
loos49051122l_oos
lotos54724632lotos
lunas55025012lunas
lunes55337772lunes
lungs65223882lungs
lunks94822452lunks
lunts55826902lunts
manos74933612manos
memos95719112memos
mends84927692mends
meno66031352meno_
menus75822842menus
monos75930862monos
nenes55329672nenes
neons55818682neons
nos38859322__nos
oleos55419682ole_os
onos46229002_onos
pends85527192pends
penes75839222penes
pengos94612412pengos
penis75129322penis
pens65649642pen_s
peons75327182peons
pepos96620082pepos
pesos77221622pesos
pleons84213342pleons
redos65126762redos
rends65129952rends
rents55935182rents
repos74725792repos
segnos73610442segnos
segos64919482segos
sends65528242sends
senor53822792senor
senors63620782senors
stenos63915772stenos
telos55424522telos
tends65425582tends
tenon53320512tenon
tenons62916602tenons
tenor53620252tenor
tenors63217752tenors
tens45647412ten_s
tents56434212tents
vends95520892vends
venom103914862venom
venoms114211212venoms
venose9310842venose
venous93713192venous
vents86125932vents
venus84918902venus
vinos84723072vinos
wends95822812wends
wens76337932wen_s
winos84625042winos
xenon122612452xenon
xenons132710482xenons
yens75832262yen_s
zeros144918102zeros

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001781.97027309.6
3Display Results1781780.0602966.7
 (SQL Overall)1786911782.12384169.1
 
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.