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

181 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
lenis5632686(None) 
leis45739601le_is
lends65326251lends
lenes54738521lenes
lenos56024861lenos
lens46146491len_s
levis85818551levis
lewis85315841lewis
lexis125916031lexis
penis75129321penis
aegis6316782aegis
anis45746462_anis
bends85628972bends
benes75536232benes
bennis84314802bennis
bens65945702ben_s
bents76033692bents
blends96012882blends
blinis85313682blinis
cedis84317082cedis
cents74730332cents
clevis1158962clevis
defis96717502defis
delis64928542delis
denes65639722denes
deni56929392deni_
denies74729642denies
denim85518842denim
denims95214322denims
dens55945072den_s
dents65031802dents
egis56520652_egis
elemis8312382elemis
ends56528522_ends
engs56121392_engs
ens37245922_en_s
fends96324972fends
fens76139762fen_s
finis86824262finis
genes65133092genes
genic85119392genic
genie66124922genie
genies75324942genies
genii64514172genii
genip84415202genip
genips9469942genips
genius74512922genius
gens55740072gen_s
gents65729612gents
genus65319832genus
glens66519852glen_s
hens75642572hen_s
hents87330742hents
kenos95220622kenos
kens85435232ken_s
kepis115313362kepis
lanais6316792lanais
lands65426902lands
lanes54946792lanes
lapis76223152lapis
laris54737462laris
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182le_as
leeks95318892leeks
leers54828982leers
lees45455882le_es
leets54927122leets
lefts86517812lefts
leges64427292leges
legist71315252legist
legit61323502legit
legits71313002legits
legs56133692le_gs
lehrs86111132lehrs
lei36846382le_i_
leks85427602le_ks
lend56233672len_d
lenite6719982lenite
lenites7818442lenites
lenity9612712lenity
leno47331392len_o
lense54523432lense
lenses64620892lenses
lent46360532len_t
lentic83515742lentic
lentil64315392lentil
lentils73912972lentils
lentisk1136062lentisk
lento57223392lento
lentos65317402lentos
leones64417722leones
les35663072le__s
leses54930812leses
less45635102le_ss
lets47147942le_ts
leuds66214812leuds
levies93919862levies
levin84816412levin
levins94514652levins
lexes127225262lexes
leys76430182le_ys
liens56525502lien_s
lines57054572lines
lings67135772lings
linin58025522linin
linins65922142linins
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
lis37162272l__is
loins56728422loins
longs65527062longs
loris55329152loris
louis57322322louis
lunas55025012lunas
lunes55337772lunes
lungis77113022lungis
lungs65223882lungs
lunies64723012lunies
lunks94822452lunks
lunts55826902lunts
lweis8458692lweis
lysis84511462lysis
mends84927692mends
menus75822842menus
metis75025902metis
minis75432992minis
munis75022002munis
nenes55329672nenes
oleins6313522oleins
ornis54616772ornis
peins76128062peins
pends85527192pends
penes75839222penes
pennis84315742pennis
pens65649642pen_s
peris75537072peris
plenish1239942plenish
plenism11310112plenism
plenist9314332plenist
ranis55235832ranis
reins56234562reins
reis45343232re_is
rends65129952rends
renig64518912renig
renigs74314592renigs
renin54830032renin
renins64526452renins
rents55935182rents
seis45542392se_is
semis74623532semis
sends65528242sends
tends65425582tends
tenia55324482tenia
tenias64720072tenias
tennis64015302tennis
tens45647412ten_s
tents56434212tents
tenuis64213082tenuis
veins84620492veins
vends95520892vends
venin85118662venin
venins93816702venins
vents86125932vents
venus84918902venus
wends95822812wends
wens76337932wen_s
xenia124814772xenia
xenias133712972xenias
xenic144114642xenic
yens75832262yen_s
yetis85418392yetis
yonis85020822yonis
zeins144715392zeins

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 Filter178691538000.310576422.6
2DLD Change Limit538001811.53335094.6
3Display Results1811810.0463934.8
 (SQL Overall)1786911811.88994595.6
 
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.