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

316 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
miter7573479(None) 
biter75030031biter
citer74827331citer
kiter95523211kiter
liter54736341liter
mater74438861mater
meter75130321meter
miler75733061miler
milter84921231milter
mimer94825761mimer
miner76933541miner
minter84425101minter
miser75430401miser
mister84728561mister
mite66249411mite_
miters84328781miters
mites75141801mites
mither114218561mither
mitier83620671mitier
mitre75522421mitre
mixer145017641mixer
muter74525541muter
niter55028971niter
smiter83616411smiter
titer55430611titer
after85719792after
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
alter54828502alter
apter76120202apter
aster55434892aster
baiter84422552baiter
bider85728372bider
bier65531832bi_er
biker116022562biker
biner75930692biner
bister84922762bister
bite66547002bite_
biters83925242biters
bites75641172bites
bitter84622672bitter
cater74840722cater
cider84723312cider
cite65640342cite_
cited84421952cited
citers85022982citers
cites74435592cites
cither114616682cither
cuter74728232cuter
dater65332312dater
deter65028042deter
dicer85426422dicer
dieter73516772dieter
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
dite55547552dite_
dites66339152dites
dither104417682dither
diver94827802diver
doter65428622doter
eater54639842eater
eider64624742eider
either94517422either
emitter93211082emitter
emoter85415192emoter
enter54726382enter
ester54727712ester
fiber104921132fiber
fifer115519972fifer
filer85433002filer
filter94517632filter
finer85431562finer
firer811229252firer
fitter94120032fitter
fiver116024942fiver
fixer154717832fixer
gaiter73819502gaiter
gater64533652gater
giber85417702giber
gite55438612gite_
gites65630182gites
giver94921202giver
goiter74116202goiter
hater85034752hater
hider95024082hider
hiker125119392hiker
hinter94021302hinter
hirer85423122hirer
hither124417252hither
hitter94419862hitter
inter55028492inter
item65620382_item
ither84617602_ither
jiber145115702jiber
jilter133512512jilter
jitter133314992jitter
jiver155119052jiver
kier86526812ki_er
kilter103714342kilter
kite85338242kite_
kited105120092kited
kiters105218592kiters
kites95432542kites
later54843922later
liber74723622liber
lier45942462li_er
lifer85822152lifer
lifter93814812lifter
liger65024472liger
liker95627062liker
limiter92710852limiter
liner55938922liner
linter64625342linter
lister64527252lister
lite47054542lite_
liters65429882liters
lither94520952lither
litre55421462litre
litter64324852litter
liver85132962liver
loiter64619172loiter
macer912126942macer
mailer84724182mailer
maimer104514592maimer
maker114127812maker
maser75029972maser
master84831342master
mate65154222mate_
mated85537782mated
maters85032392maters
mates75251362mates
matey107022662matey
matier84321522matier
matter84325342matter
mazer165722422mazer
meeter83616502meeter
meister93114162meister
melter83520112melter
merer75126232merer
mete64438132mete_
meted85424432meted
meteor84910072meteor
meters85625832meters
metes74736212metes
metier83517692metier
metre74821302metre
mice87442232mice_
midterm12316012midterm
mien65028362mi_en
mike105535292mike_
miked125020452miked
mikes115129892mikes
milder93818452milder
mile66352572mile_
milers84625162milers
miles74645072miles
milker124814322milker
miller84625412miller
milted93919942milted
milters93619092milters
miltier93214962miltier
mime85736402mime_
mimed105622732mimed
mimeo96018682mimeo
mimers105520182mimers
mimes95732022mimes
mincer104017362mincer
minder94822502minder
mine67256172mine_
mined85333352mined
miners84126632miners
mines75651952mines
minor74920062minor
minster93914322minster
minted94220582minted
minters93822472minters
mintier93615992mintier
minuter93510412minuter
mir57046772mi__r
mire66748232mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918362mirier
mirker123712692mirker
mise66043582mise_
misers85025702misers
misery114113542misery
mises74740562mises
misted93625822misted
misterm114314512misterm
misters93927512misters
mistier93418712mistier
mitered103213232mitered
miterer92511332miterer
mithers123516732mithers
mitis75425992mitis
mitred94414342mitred
mitres83922072mitres
mitt66145492mit_t
mitten83914092mitten
mitts75523752mitts
mity95528212mit_y
mixed155717252mixed
mixers154513562mixers
mixes147224402mixes
mizen164815272mizen
moiler84017262moiler
moister94015372moister
molter84119422molter
mooter83921092mooter
moper94925922moper
mote67048082mote_
motel76623242motel
motes75944002motes
motet75641192motet
motey105922952motey
mother113718642mother
motor75317292motor
mover104220862mover
mower104523452mower
muser76024122muser
muster84724522muster
mute65136872mute_
muted85023382muted
mutes75033782mutes
mutter84418882mutter
nicer74618292nicer
nite45943582nite_
niters64624212niters
nitery94412172nitery
nites55736342nites
nitre57519682nitre
noter55025642noter
oater55433732oater
ofter84116872ofter
oiler54628282oiler
omitter9298502omitter
otter54423972otter
outer55633302outer
oxter123414092oxter
pater74740722pater
peter74427592peter
pier66035292pi_er
piker115622842piker
piper96523192piper
pitier84019822pitier
rater54943282rater
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
rioter64817282rioter
riper74328402riper
riser55431052riser
rite45849452rite_
rites54442552rites
ritter63822422ritter
river85731692river
sifter94516232sifter
siker95326032siker
sinter63625922sinter
sister64421582sister
sitar54820542sitar
site47052412site_
sited65130742sited
sites56045432sites
sitter63323382sitter
siver85728612siver
sizer145521812sizer
smiler83916682smiler
smite75224872smite_
smiters93414362smiters
smites83921922smites
suiter64121812suiter
tater54138612tater
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
tilter63417692tilter
timer75626042timer
tinter63923642tinter
titers64526412titers
titfer9409522titfer
tither94920282tither
titre54619392titre
titter63421162titter
toter55932132toter
triter65120592triter
uniter64619142uniter
unmiter9310392unmiter
utter54218762utter
vier75428152vi_er
viler86324162viler
viper105017302viper
vomiter1237952vomiter
voter85121052voter
waiter94321252waiter
water84733312water
whiter124316392whiter
wider94826352wider
winter94222802winter
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wite75443272wite_
wited94727142wited
wites85536962wites
wither124321352wither
wiver115924512wiver
writer94416512writer
zither183813082zither

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.313570897.8
2DLD Change Limit538003161.50035866.7
3Display Results3163160.0933397.8
 (SQL Overall)1786913161.90693751.8
 
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.