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

240 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
miterers1021968(None) 
miterer92511331miterer_
alterers82512492alterers
caterers102814402caterers
ditherers13196682ditherers
enterers82214152enterers
filterers12206972filterers
litterers9228192litterers
loiterers936262loiterers
maturers1037372maturers
miserere1049272miserere
misereres1148182misereres
mitered103213232mitere_d
miters84328782mit__ers
mithers123516732mit_hers
mitres83922072mit_re_s
mutterers11247372mutterers
titterers9236992titterers
utterers8218652utterers
waterers112312782waterers
winterers12209722winterers
witherers15146842witherers
adherers1296923adherers
airers64922313ai__rers
alterer72713993alterer_
banterers112410003banterers
barterers11269633barterers
batterers113110713batterers
bickerers17115593bickerers
biters83925243bit__ers
bitterer10309773bitterer_
bitters94920363bit_ters
caperers122611723caperers
caterer92815943caterer_
cateress102311613cateress
cheerers13319543cheerers
cipherers1644893cipherers
citers85022983cit__ers
cithers124315773cit_hers
cithrens13355933cithrens
coherers132310733coherers
coverers132712123coverers
detergers11147183detergers
deterrers10116593deterrers
dieters83216433di_eters
diethers1257453diethers
dimeters11411093dimeters
ditchers143610363ditchers
ditherer12187763ditherer_
dithers114016153dit_hers
diverters13227873diverters
emitters10349643emit_ters
enterer72015633enterer_
falterers12238033falterers
fetterers12267043fetterers
figurers12254873figurers
filterer11258143filterer_
fingerers13136303fingerers
firers94922683fi__rers
fitters104517753fit_ters
fosterers12238023fosterers
fritterers13203393fritterers
fruiterers1343003fruiterers
gatherers13156883gatherers
hinderers1337353hinderers
hirers94518063hi__rers
hitchers16379993hitchers
hitters104717593hit_ters
hoverers14289023hoverers
impeders13346593impeders
integers937783integers
jeerers14328923_jeerers
jitters144314473jit_ters
kipperers17233823kipperers
kiters105218593kit__ers
latherers12158853latherers
letterers9228113letterers
libelers10238623libelers
lingerers10126923lingerers
listeners9147323listeners
liteness82213213liteness
literals8312293literals
literary1147753literary
liters65429883lit__ers
litres65220393lit_re_s
litterer82810173litterer_
litters73422573lit_ters
liveners11217933liveners
loiterer837083loiterer_
manurers1037593manurers
marrers93414313m_arrers
matchers153012433matchers
mateless102711293mateless
materiels1147833materiels
maters85032393mat__ers
matres84522233mat_re_s
matters94421753mat_ters
mattress1036533mattress
maturer938973maturer_
matures9314303mature_s
meeters94714543m_eeters
mercers114412773m__ercers
merer75126233m__erer_
meres75143573m__ere_s
mergers103813423m__ergers
metamers1249623metamers
meteors94610013mete_ors
metered103514013metere_d
meters85625833m__eters
metiers93312843met_iers
metres85121563met_re_s
middlers123410193middlers
midterms13284863midter_ms
milers84625163mi__lers
milkers134411613mi_lkers
millers93621343mi_llers
milliers102611903milliers
milreis937323mi_lreis
milters93619093mi_lters
mimers105520183mi__mers
mimeses1139073mimese_s
minarets1048843minarets
mincers113714853mi_ncers
minders103720123mi_nders
minerals10311373minerals
miners84126633mi__ners
minglers113011293minglers
minivers1337483minivers
minsters103813923minsters
minters93822473mi_nters
mires75640883mi__re_s
mirexes1636993mirexe_s
mirrors938623mi_rrors
misavers1348063misavers
misdoers1137103misdoers
misenters1139533misenters
miseries10320403miseries
misers85025703mi__sers
misorders1245883misorders
misrefers1445363misrefers
missteers1135913misste_ers
mistakers15117083mistakers
misterms123711353mister_ms
misters93927513mi_sters
mistress10310703mistress
misusers10348083misusers
miter75734793mit__er_
mitering113015403mitering
miterwort1476693miterwort
miterworts1584233miterworts
mites75141803mit__e_s
mither114218563mit_her_
mitier83620673mit_ier_
mitises9315543mitise_s
mitogens1146973mitogens
mitoses9312183mitose_s
mitre75522423mit_re__
mitred94414343mit_re_d
mittens9349883mit_tens
mixers154513563mi__xers
mixtures1735753mixture_s
modelers1138463modelers
moisteners1244783moisteners
moneyers1337423moneyers
mothers123717623mot_hers
mottlers10388183mottlers
murderers1244593murderers
muteness1039013muteness
mutterer10218913mutterer_
mutters94117143mut_ters
niteries8318383niteries
niters64624213nit__ers
nitres65519333nit_re_s
offerers1434933offerers
omitters10277653omit_ters
orderers9116563orderers
oysterers1245573oysterers
palterers11249533palterers
paperers122410453paperers
patterers112410123patterers
pesterers112510453pesterers
pewterers14216043pewterers
piecers114112253pi_ecers
piercers12316723pi_ercers
pilferers1444583pilferers
pitchers153211483pitchers
pitiers93812653pit_iers
potterers11218663potterers
putterers11238363putterers
quiverers2143713quiverers
retirers84311533retirers
reverers113113153reverers
rievers104311453ri_evers
ripeners1036833ripeners
ritters74020623rit_ters
riveters11228163riveters
roisterers1045113roisterers
shiverers15155773shiverers
silverers12215753silverers
simperers1335933simperers
sitters74221553sit_ters
sliverers12196363sliverers
smatterers12174873smatterers
smiters93414363smit__ers
smithers13369793smit_hers
smotherers1543813smotherers
sneerers8309803sneerers
starers74522313_starers
steerers82511353steerers
steers63820983_ste_ers
stereos74314973_stereos
steres63929533_stere_s
stirrers8266943stirrers
storers75018683_storers
taperers10269773taperers
tearers75218233__tearers
termers95414503__termers
tinkerers1395423tinkerers
titers64526413tit__ers
titfers10318933tit_fers
tithers104216733tit_hers
titres64718933tit_re_s
titterer8268523titterer_
titters74219623tit_ters
totterers9186813totterers
twitterers1342673twitterers
utterer71910463utterer_
viewers1337173vi_ewers
vitamers1334683vitamers
wagerers12247613wagerers
waterer103314073waterer_
waverers14318613waverers
whiteners1535243whiteners
wideners12257993wideners
wieners103212483wi_eners
winterer112110443winterer_
wirers94617893wi__rers
witherer14187953witherer_
withers134417753wit_hers
zithers193911973zit_hers

Search took 9 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461622407.83018666.9
3Display Results2402400.1102181.8
 (SQL Overall)1786912408.09322079.7
 
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.