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

358 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
liter5473634(None) 
biter75030031biter
citer74827321citer
kiter95523211kiter
later54843921later
liber74723611liber
lier45942461li_er
lifer85822151lifer
lifter93814811lifter
liger65024461liger
liker95627061liker
liner55938911liner
linter64625331linter
lister64527251lister
lite47054541lite_
liters65429871liters
lither94520951lither
litre55421461litre
litter64324851litter
liver85132961liver
loiter64619171loiter
miter75734791miter
niter55028971niter
titer55430611titer
after85719792after
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
aliner65621982aliner
alter54828502alter
apter76120202apter
aster55434892aster
baiter84422552baiter
bider85728372bider
bier65531822bi_er
biker116022562biker
biner75930692biner
bister84922762bister
bite66546992bite_
biters83925232biters
bites75641172bites
bitter84622672bitter
blister94415312blister
blite76225352blite_
blites84721212blites
blither124812172blither
blitzer18447662blitzer
cater74840702cater
cider84723312cider
cite65640342cite_
cited84421952cited
citers85022972citers
cites74435582cites
cither114616682cither
cuter74728222cuter
dater65332312dater
deter65028042deter
dicer85426422dicer
dieter73516772dieter
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
dite55547552dite_
dites66339152dites
dither104417682dither
diver94827802diver
doter65428622doter
eater54639842eater
eider64624742eider
either94517422either
elater64724202elater
elite56230182elite_
elites66027122elites
enter54726382enter
ester54727712ester
fiber104921132fiber
fifer115519972fifer
filer85433002filer
filter94517632filter
finer85431562finer
firer811229252firer
fitter94120032fitter
fiver116024942fiver
fixer154717832fixer
flier86023402fli_er
flirter10318672flirter
flite85424962flite_
flited104616582flited
flites95122442flites
flitter103413902flitter
fluter95316862fluter
gaiter73819502gaiter
gater64533642gater
giber85417702giber
gite55438612gite_
gites65630182gites
giver94921202giver
glider84614262glider
glister84013342glister
glitter84211802glitter
goiter74116202goiter
hater85034752hater
hider95024082hider
hiker125119392hiker
hinter94021302hinter
hirer85423122hirer
hither124417252hither
hitter94419862hitter
iller54821292iller
inter55028492inter
item65620382_item
ither84617602_ither
jiber145115702jiber
jilter133512512jilter
jitter133314992jitter
jiver155119052jiver
kier86526802ki_er
kilter103714342kilter
kite85338232kite_
kited105120092kited
kiters105218582kiters
kites95432542kites
klister113410642klister
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
laser54633322laser
laster64830632laster
late47560482late_
lated65240672lated
laten54328342laten
latex124717112latex
lather95124352lather
latter65027892latter
laver85031792laver
laxer125420332laxer
layer84626472layer
leer46239352l_eer
lefter93613432lefter
leger65721502leger
leister73212752leister
leper74820742leper
letter63722582letter
lever85125162lever
liar47229682li_ar
libber104414002libber
libel74116102libel
libers84721432libers
lice66045062lice_
licker125222042licker
lictor83610852lictor
lidar6312722lidar
lie38264522li_e_
lied55838092li_ed
lieder74912322lieder
lief76036982li_ef
liefer9529572liefer
lien45339802li_en
liers55130402li_ers
lies46454192li_es
lieu46534362li_eu
liever94611862liever
life75433732life_
lifers95617842lifers
lifted104413522lifted
lifters104313772lifters
ligers75022022ligers
lighter113113422lighter
like86040842like_
liked104523812liked
liken911818842liken
likers104620912likers
likes96231902likes
lilted73715372lilted
limber104316772limber
lime66244932lime_
limed85426802limed
limen75426032limen
limes75636502limes
limey104721042limey
limier83518712limier
limiter92710852limiter
limmer104314792limmer
limner84112862limner
limper104117852limper
line46965572line_
linear65113332linear
lined64934642lined
linen55728722linen
liners65428842liners
lines57054572lines
liney87029622liney
linger75225992linger
linier64423782linier
linker104321462linker
linted74021822linted
lintel64013992lintel
linters73822612linters
lintier73613792lintier
lipe66839732lipe_
lipper104219632lipper
lire47845292lire_
lisper84114432lisper
listed74322832listed
listee64223062listee
listel64214732listel
listen64816812listen
listers74026522listers
lit39377312lit__
litai55216362litai
litas54923772litas
literal7613262literal
lithe84922012lithe
litho86513782litho
litres65220392litres
lits46252492lit_s
litten64014872litten
litters73422562litters
littery103710482littery
littler7348552littler
litu47631562lit_u
live76540992live_
lived95523722lived
liven85021732liven
livers94927822livers
livery124910892livery
lives86133192lives
livier97514592livier
livre85613252livre
livyer12426292livyer
lofter94614722lofter
loiters74116612loiters
loner55431032loner
looter64222322looter
loper75129232loper
loser54728672loser
lotter64025602lotter
lover85526452lover
lower85830412lower
luger65322082luger
lurer54625312lurer
luster64023672luster
lute46341012lute_
lutea54819072lutea
luted64826142luted
lutes55836662lutes
mater74438862mater
meter75130322meter
miler75733062miler
milter84921232milter
mimer94825762mimer
miner76933542miner
minter84425102minter
miser75430402miser
mister84728562mister
mite66249402mite_
miters84328772miters
mites75141802mites
mither114218562mither
mitier83620662mitier
mitre75522422mitre
mixer145017642mixer
muter74525542muter
nicer74618292nicer
nite45943582nite_
niters64624202niters
nitery94412172nitery
nites55736342nites
nitre57519682nitre
noter55025642noter
oater55433732oater
ofter84116872ofter
oiler54628282oiler
otter54423972otter
outer55633302outer
oxter123414092oxter
pater74740722pater
peter74427592peter
pier66035292pi_er
piker115622842piker
piper96523192piper
pitier84019822pitier
plaiter93615392plaiter
plater84427692plater
plier75221282pli_er
politer92417072politer
rater54943282rater
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
rioter64817282rioter
riper74328402riper
riser55431052riser
rite45849452rite_
rites54442552rites
ritter63822412ritter
river85731692river
sifter94516232sifter
siker95326032siker
sinter63625922sinter
sister64421582sister
sitar54820542sitar
site47052412site_
sited65130742sited
sites56045432sites
sitter63323382sitter
siver85728612siver
sizer145521812sizer
slater64429182slater
slicer84117602slicer
slider73918362slider
slier54827242sli_er
slither104112982slither
slitter73615872slitter
sliver94116592sliver
smiter83616412smiter
suiter64121812suiter
tater54138612tater
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
tilter63417692tilter
timer75626042timer
tinter63923642tinter
titers64526402titers
titfer9409522titfer
tither94920282tither
titre54619392titre
titter63421162titter
toter55932132toter
triter65120592triter
ulster63712102ulster
uniter64619142uniter
utter54218762utter
vier75428152vi_er
viler86324162viler
viper105017302viper
voter85121052voter
waiter94321252waiter
water84733312water
whiter124316392whiter
wider94826352wider
winter94222802winter
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wite75443272wite_
wited94727142wited
wites85536962wites
wither124321352wither
wiver115924512wiver
writer94416512writer
zither183813082zither

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.1701051123.5
2DLD Change Limit538003581.94027732.0
3Display Results3583580.1063377.4
 (SQL Overall)1786913582.21680636.7
 
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.