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

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

366 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
miterer9251133(None) 
mitered103213231mitered
miterers10219681miterers
alterer72713992alterer
bitterer10309772bitterer
caterer92815942caterer
ditherer12187762ditherer
enterer72015632enterer
filterer11258142filterer
litterer82810172litterer
loiterer837082loiterer
maturer938972maturer
merer75126232m__erer
metered103514012metered
miserere1049272miserere
miter75734792mit__er
miters84328782miter_s
mither114218562mit_her
mitier83620672mit_ier
mitre75522422mit_re_
mitred94414342mit_red
mitres83922072mit_res
mutterer10218912mutterer
titterer8268522titterer
utterer71910462utterer
waterer103314072waterer
winterer112110442winterer
witherer14187952witherer
adherer1137573adherer
airer54927893ai__rer
altered83215733altered
alterers82512493alterers
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
bickerer16106773bickerer
bistered112913323bistered
biter75030033bit__er
biters83925243biter_s
bitsier9379073bitsier
bitter84622673bit_ter
bittered112711833bittered
bittier94211663bittier
caperer113013403caperer
catered103117773catered
caterers102814403caterers
cheerer123511753cheerer
cipherer1545573cipherer
citer74827333cit__er
citers85022983citer_s
cither114616683cit_her
cithren12306593cithren
coherer122912783coherer
coverer123113523coverer
deterger10147593deterger
deterrer9137013deterrer
dieter73516773di_eter
diether1147443diether
dimeter10411893dimeter
direr64927073di__rer
ditcher134012003ditcher
dither104417683dit_her
dithered13189293dithered
ditherers13196683ditherers
ditsier83010293ditsier
ditzier17307963ditzier
diverter12238623diverter
eagerer8248823eagerer
either94517423eit_her
emitter93211083emit_ter
entered82718883entered
enterers82214153enterers
falterer11239853falterer
fetterer11207813fetterer
fibered1337643fibered
fiercer12356953fi_ercer
fierier103511193fi_erier
figurer11215863figurer
filtered12259043filtered
filterers12206973filterers
fingerer12127223fingerer
firer811229253fi__rer
fitter94120033fit_ter
fosterer11239523fosterer
fritterer12234403fritterer
fruiterer1243333fruiterer
gatherer12147903gatherer
hinderer1238273hinderer
hirer85423123hi__rer
hitcher153712003hitcher
hither124417253hit_her
hitter94419863hit_ter
hoverer13319823hoverer
impeder12438533impeder
impurer1136483impurer
integer837993integer
itemed936603_itemed
iterum837903_iterum
ither84617603_it_her
jeerer13389933_jeerer
jitter133314993jit_ter
jittered16267223jittered
jitterier1644433jitterier
kipperer16294723kipperer
kiter95523213kit__er
kiters105218593kiter_s
kittler11338163kittler
latherer111310443latherer
letterer8259223letterer
libeler9219003libeler
lieder74912323li_eder
liefer9529573li_efer
liever94611863li_ever
limberer12187053limberer
lingerer9118303lingerer
listener8158313listener
liter54736343lit__er
literal7613273literal
literary1147753literary
liters65429883liter_s
lither94520953lit_her
litre55421463lit_re_
litres65220393lit_res
litter64324853lit_ter
littered92511383littered
litterers9228193litterers
littler7348553littler
livener10278943livener
livered113111633livered
loitered938183loitered
loiterers936263loiterers
manurer938583manurer
marrer83716673m_arrer
mastered112614003mastered
matcher143214283matcher
mater74438863mat__er
materiel10311253materiel
maters85032393mater_s
matier84321523mat_ier
matres84522233mat_res
matter84325343mat_ter
mattered112412903mattered
mature8313463mature_
matured10310033matured
maturers1037373maturers
matures9314303matures
meeker12359983m_eeker
meeter83616503m_eeter
mercer105214203m__ercer
mere67244443m__ere_
meres75143573m__eres
merger95016473m__erger
metamer1139613metamer
meteor84910073mete_or
meter75130323m__eter
meters85625833meter_s
metier83517693met_ier
metre74821303met_re_
metred95315143met_red
metres85121563met_res
mickler153310233mickler
middler112712273middler
midterm12316013midter_m
midterms13284863midterms
miffier1537023miffier
milder93818453mi_lder
miler75733063mi__ler
milers84625163miler_s
milker124814323mi_lker
milkier133411163milkier
miller84625413mi_ller
millier93716703millier
milter84921233mi_lter
milters93619093milter_s
miltier93214963miltier
mimeoed1235193mimeoed
mimer94825763mi__mer
mimers105520183mimer_s
mimeses1139073mimeses
minaret9520683minaret
mincer104017363mi_ncer
mincier113512473mincier
minder94822503mi_nder
miner76933543mi__ner
mineral9312733mineral
miners84126633miner_s
mingier103815293mingier
mingler104213843mingler
miniver1238393miniver
minored10310103minored
minster93914323minster
minter84425103mi_nter
minters93822473minter_s
mintier93615993mintier
minuter93510413minuter
mire66748233mi__re_
mired85729223mi__red
mires75640883mi__res
mirex146816623mi__rex
mirexes1636993mirexes
mirier83918363mi_rier
mirker123712693mi_rker
mirkier13319053mirkier
mirror848003mi_rror
misaver1249813misaver
misdoer1048633misdoer
misdrew1335833misdrew
misenter10310833misenter
miser75430403mi__ser
misereres1148183misereres
miseries10320403miseries
miserly12329823miserly
misers85025703miser_s
misery114113543miser_y
misgrew1335523misgrew
misorder1147283misorder
misrefer1346103misrefer
missteer1037223misste_er
mistaker14109333mistaker
mister84728563mi_ster
misterm114314513mister_m
mistermed1438363mistermed
misterms123711353misterms
misters93927513mister_s
misthrew16124763misthrew
mistier93418713mistier
misuser93210443misuser
mite66249413mit__e_
mitering113015403mitering
miterwort1476693miterwort
mites75141803mit__es
mithers123516733mither_s
mitises9315543mitises
mitogen1036963mitogen
mitoses9312183mitoses
mitral81314323mit_ral
mitten83914093mit_ten
mittened1136363mittened
mixer145017643mi__xer
mixers154513563mixer_s
mixture1635413mixture_
mixtures1735753mixtures
modeler1039293modeler
moderner1145523moderner
moistener1145843moistener
moneyer1237903moneyer
mother113718643mot_her
mothered142310103mothered
mothier121910213mothier
motleyer1343263motleyer
motlier92010583motlier
motored1039933motored
mottler94410343mottler
murderer1145263murderer
mustered112511503mustered
muter74525543mut__er
mutter84418883mut_ter
muttered112610793muttered
mutterers11247373mutterers
mythier15125183mythier
niter55028973nit__er
niterie7313743niterie
niteries8318383niteries
niters64624213niter_s
nitery94412173niter_y
nitre57519683nit_re_
nitres65519333nit_res
nittier73512243nittier
offerer1335543offerer
oftener1035923oftener
omitter9298503omit_ter
orderer8127943orderer
oysterer1136103oysterer
palterer102411273palterer
paperer113111903paperer
patterer103112173patterer
pesterer102412703pesterer
petered103314963petered
pewterer13256313pewterer
piecer105213083pi_ecer
piercer11337773pi_ercer
pilferer1344923pilferer
pitcher143813713pitcher
pithier123010293pithier
pitier84019823pit_ier
potterer102310263potterer
putterer10209913putterer
queerer16106503queerer
quiverer2044463quiverer
retirer74715013retirer
reverer103815833reverer
riever94811653ri_ever
ripener937903ripener
ritter63822423rit_ter
ritzier16297203ritzier
riveter10208753riveter
roisterer946433roisterer
serer55935503__serer
severer103511563severer
sheerer103813843sheerer
shiverer14186663shiverer
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
sintered92213903sintered
sistered92612803sistered
sitter63323383sit_ter
sliverer11237633sliverer
smatterer11185813smatterer
smiter83616413smit__er
smiters93414363smiter_s
smotherer1444633smotherer
sneerer73512313sneerer
soberer93110353soberer
starer64027363_starer
steer55423863_ste_er
steerer73113633steerer
stere55328543_stere_
stereo65317913_stereo
steres63929533_steres
sterner7411913_sterner
stirrer7338233stirrer
storer64721673_storer
taperer92511793taperer
tearer64822903__tearer
termer85717253__termer
terser67317823__terser
tiered73613973ti_ered
tinkerer1286803tinkerer
tireder837703tireder
titer55430613tit__er
titers64526413titer_s
titfer9409523tit_fer
tither94920283tit_her
titre54619393tit_re_
titres64718933tit_res
titter63421163tit_ter
tittered9239493tittered
titterers9236993titterers
totterer8217793totterer
twitterer1243303twitterer
unmitered1245853unmitered
uttered82712433uttered
utterers8218653utterers
viewer1237213vi_ewer
vitamer1235473vitamer
wagerer11328493wagerer
waitered1238753waitered
watered113014953watered
waterers112312783waterers
waterier11312083waterier
waverer13319523waverer
whitener1435733whitener
widener11318693widener
wiener94513543wi_ener
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
wirer85124953wi__rer
wither124321353wit_her
withered15169433withered
witherers15146843witherers
withier132910493withier
wittier103910823wittier
zither183813083zit_her

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273666.42320866.7
3Display Results3663660.1402614.3
 (SQL Overall)1786913666.71926594.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.