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

496 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
mitered10321323(None) 
metered103514011metered
miterer92511331miterer
mitred94414341mit_red
altered83215732altered
bistered112913322bistered
bittered112711832bittered
catered103117762catered
dithered13189292dithered
entered82718882entered
fibered1337642fibered
filtered12259042filtered
itemed936602_itemed
jittered16267222jittered
littered92511382littered
livered113111632livered
loitered938182loitered
mastered112614002mastered
mattered112412902mattered
matured10310032matured
metred95315142met_red
mimeoed1235192mimeoed
minored10310102minored
mired85729222mi__red
mistermed1438362mistermed
miter75734792miter__
miterers10219682miterers
miters84328772miter_s
mitre75522422mit_re_
mitres83922072mit_res
mittened1136362mittened
mothered142310102mothered
motored1039932motored
mustered112511502mustered
muttered112610792muttered
petered103314962petered
sintered92213902sintered
sistered92612802sistered
tiered73613972ti_ered
tittered9239492tittered
unmitered1245852unmitered
uttered82712432uttered
waitered1238752waitered
watered113014952watered
wintered122111572wintered
withered15169432withered
adhered1239233adhered
aired66032923ai__red
alterer72713993alterer
angered93013473angered
anteed75616113ante_ed
antired82316193antired
antlered938253antlered
attired8238913attired
bantered113313633bantered
bartered113113013bartered
battered113315053battered
bettered113011833bettered
bickered17108003bickered
birred94713203bi_rred
bistred103311853bistred
bitched153212923bitched
biter75030033biter__
biters83925233biter_s
bitted94418483bit_ted
bitterer10309773bitterer
blistered12167683blistered
blithered15156123blithered
bothered142110393bothered
bowered133113043bowered
buttered112712623buttered
cantered113415983cantered
capered123014043capered
caterer92815933caterer
centered112513523centered
cered85227443__cered
cheered133713293cheered
chittered15166413chittered
cindered1239793cindered
ciphered1637053ciphered
cited84421953cit__ed
citer74827323citer__
citers85022973citer_s
cithren12306593cithren
citied94014143cit_ied
cohered133514693cohered
cottered112511733cottered
covered133315293covered
cowered133214643cowered
cratered1149673cratered
daikered1495223daikered
deterged11127923deterged
deterred10137803deterred
diapered1238003diapered
dickered16117533dickered
dieted83115493di_eted
differed1635523differed
ditched143711903ditched
ditherer12187763ditherer
dittoed936733dittoed
diverged14256883diverged
diverted13199583diverted
dizened18267333dizened
dowered122811553dowered
embittered1542543embittered
emitted103010853emit_ted
enterer72015633enterer
faltered122810983faltered
fathered151510433fathered
festered122512103festered
fettered12259493fettered
fevered14339723fevered
figured12196473figured
fileted1159093fileted
filterer11258143filterer
fingered13128323fingered
fired94829743fi__red
fitted104716663fit_ted
fleered11309503fleered
flittered13196253flittered
fostered122210443fostered
frittered13205163frittered
gartered10319583gartered
gathered13149373gathered
gettered10258613gettered
gibbered1444303gibbered
gingered11127733gingered
gitted84015053git_ted
glistered11176293glistered
glittered11195403glittered
guttered10259153guttered
haltered123112553haltered
hatred104814333hat_red
havered144011453havered
hindered1339453hindered
hired95226263hi__red
hitched163312253hitched
homered133212713homered
hovered143411573hovered
imbittered1542083imbittered
imitated1138263imitated
immerged1444023immerged
immersed1344833immersed
immured1235063immured
impeded13418183impeded
inbred93010393_inbred
inhered11313163inhered
interbed112413103interbed
interned93016653interned
interred92615263interred
inured73114813_inured
ired55131873_i__red
itched123812023_itched
iterated91213813_iterated
iterum837903_iterum
jeered143912793_jeered
jiggered1834203jiggered
kindred13316953kindred
kippered17255623kippered
kited105120093kit__ed
kiter95523213kiter__
kiters105218583kiter_s
kithed144613013kit_hed
kitted115114833kit_ted
kittened1334523kittened
kittled12388193kittled
lagered92311153lagered
latened8711923latened
laterad8310833laterad
lathered121512323lathered
layered11259413layered
leered73816223_leered
leistered1037043leistered
lettered92910783lettered
levered114212303levered
libeled10249413libeled
lightered1446263lightered
likened12267353likened
limbered13158113limbered
linebred1144953linebred
lingered10129633lingered
lippered13287953lippered
listened9168813listened
liter54736343liter__
literal7613263literal
liters65429873liter_s
lithoed1137833lithoed
litre55421463lit_re_
litres65220393lit_res
litterer82810173litterer
livened11238933livened
liveried1238733liveried
loiterer837083loiterer
lowered112711913lowered
lustered92510603lustered
majored1735853majored
mammered12237653mammered
mannered11249653mannered
manured1039473manured
marred95421043m_arred
martyred1434283martyred
matched153513963matched
mated85537783mat__ed
mater74438863mater__
materiel10311253materiel
maters85032383mater_s
matres84522233mat_res
matted94521413mat_ted
mature8313463mature_
maturer938973maturer
matures9314303matures
meed74934703m__e_ed
membered1535903membered
mentored1138003mentored
merde84320123m__erde
mere67244443m__ere_
merer75126233m__erer
meres75143573m__eres
merged104214943m__erged
metaled102913873metaled
meted85424433m__eted
meter75130323meter__
meters85625833meter_s
metre74821303met_re_
metres85121563met_res
mettled103510543mettled
mewed115218013m__ewed
miaoued1034583miaoued
miaowed1333883miaowed
miauled1036663miauled
miched143913393mi_ched
middled123311893middled
midterm12316013midter_m
midterms13284853midterms
miffed15398713mi_ffed
miked125020453mi__ked
milded104416153mi_lded
mildened1235773mildened
mildewed1543763mildewed
miler75733063miler__
milers84625163miler_s
milked134612573mi_lked
milled94326173mi_lled
milleped1335173milleped
milord999563milor_d
milted93919943mi_lted
milter84921233milter__
milters93619083milter_s
mimed105622733mi__med
mimer94825763mimer__
mimers105520183mimer_s
mimeses1139073mimeses
minaret9520683minaret
minced114114913mi_nced
minded103817833mi_nded
mined85333353mi__ned
miner76933543miner__
mineral9312733mineral
miners84126633miner_s
mingled113612733mingled
ministered1344963ministered
minted94220583mi_nted
minter84425103minter__
minters93822463minter_s
minuted10329503minuted
mire66748223mi__re_
mires75640883mi__res
mirex146816623mi__rex
mirexes1636993mirexes
mirrored1145773mirrored
misaltered1344563misaltered
miscued1239293miscued
misdeed113211053misdeed
misdrew1335833misdrew
misentered1345913misentered
miser75430403miser__
miserere1049273miserere
miseries10320403miseries
miserly12329823miserly
misers85025703miser_s
misery114113543miser_y
misfed124113023mi_sfed
misfeed13389683misfeed
misfired14238543misfired
misgrew1335523misgrew
misleared1277453misleared
misled94719313mi_sled
mispled12310463mispled
misread10339723misread
missed94423603mi_ssed
missteered1343553missteered
misted93625823mi_sted
mistend103812523miste_nd
mistended13137333mistended
mister84728563mister__
misterm114314513mister_m
misterms123711333misterms
misters93927503mister_s
misthrew16124763misthrew
mistimed1339123mistimed
mistuned1157723mistuned
mistyped1685173mistyped
misused104111273misused
mite66249403mit__e_
mitering113015393mitering
mites75141803mit__es
mither114218563mit_her
mithers123516733mither_s
mitier83620663mit_ier
mitises9315543mitises
mitogen1036963mitogen
mitoses9312183mitoses
mitral81314323mit_ral
mitten83914093mit_ten
mixed155717253mi__xed
mixer145017643mixer__
mixers154513563mixer_s
mixture1635413mixture_
mixtures1735753mixtures
mizzled18327633mizzled
modeled1139453modeled
modemed1336723modemed
moistened1246003moistened
moldered1237173moldered
moneyed1337493moneyed
mongered1238953mongered
monitored1245583monitored
moored93814173m_oored
mortared1137213mortared
moseyed1336133moseyed
motived13357763motived
mottled10409973mottled
murdered1236023murdered
mured85726703m__ured
murthered1544473murthered
mutated102712253mutated
muted85023383mut__ed
muter74525543muter__
mutined103311353mutined
mutterer10218913mutterer
nattered92011623nattered
natured838963natured
neutered937423neutered
nickered15117023nickered
niffered1544143niffered
niter55028973niter__
niterie7313743niterie
niteries8318373niteries
niters64624203niter_s
nitery94412173niter_y
nitre57519683nit_re_
nitres65519333nit_res
nitrid72812233nit_rid
ochered132610283ochered
offered1436143offered
omitted10347893omit_ted
ordered9108533ordered
osiered837123osiered
outbred10311263outbred
overed102216623_overed
oystered1236913oystered
paltered113012483paltered
papered122513163papered
pattered112714203pattered
peered93819483_peered
peltered112510443peltered
pestered112814953pestered
philtered1545493philtered
pictured1346573pictured
pieced113912103pi_eced
pierced12347593pi_erced
pilfered1435853pilfered
pitched153512923pitched
pithed124615613pit_hed
pitied94017253pit_ied
pitted94319593pit_ted
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powered132911643powered
puttered112611143puttered
queered17117213queered
quivered2144823quivered
raftered1237663raftered
retired84620143retired
revered112819333revered
ripened1038203ripened
ritard74812083ritar_d
riverbed14245143riverbed
riveted11258573riveted
rogered939553rogered
roistered1037633roistered
sabered103213023sabered
sered65737293__sered
severed113513863severed
sewered112911243sewered
sheered113515453sheered
shivered15177103shivered
sieged85212713si_eged
sieved104611443si_eved
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sinewed1137053sinewed
sired66134283si__red
sited65130743sit__ed
skittered1434633skittered
slithered13136623slithered
slivered12218103slivered
smattered12186783smattered
smiter83616413smiter__
smiters93414363smiter_s
smothered1545683smothered
sneered83113973sneered
sobered102912433sobered
speered103614813speered
sphered133512313sphered
spiered104412463spiered
stared75429873_stared
steed66024943_ste_ed
steered83615253steered
stere55328543_stere_
stereo65317913_stereo
steres63929533_steres
stewed104814243_stewed
stirred8359693stirred
stored75524213_stored
supered10316123supered
sutured8310373sutured
swithered16135463swithered
tabered103311593tabered
tapered102612933tapered
tared69340053__tared
tattered92011443tattered
teared75722153__teared
teed55439263__te_ed
teetered9258303teetered
tentered96412103tentered
teredo7310783__teredo
termed94816703__termed
tethered1238493tethered
tewed94718533__tewed
tierced10347053ti_erced
tillered937433tillered
timbered13137383timbered
tinkered1387683tinkered
tired65228903__tired
titer55430613titer__
titers64526403titer_s
tithed104115593tit_hed
titled73815003tit_led
titre54619393tit_re_
titres64718933tit_res
titterer8268523titterer
tottered9208703tottered
towered112911403towered
treed65626733__treed
tutored837553tutored
twittered1333813twittered
tyred95816433__tyred
ulcered1037973ulcered
umbered121510113umbered
unmitred1136843unmit_red
untired82316383untired
ushered1139153ushered
utterer71910463utterer
veered103612743_veered
viewed1345993vi_ewed
viseed105310983vise_ed
visored1138143visored
vittled11347343vittled
vizored2034133vizored
wafered14288433wafered
wagered12299333wagered
waterbed1436443waterbed
waterer103314073waterer
wavered142910433wavered
weltered12238433weltered
westered122511863westered
whitened1535173whitened
widened12328053widened
wildered1336633wildered
winterer112110443winterer
winterfed1644993winterfed
wired95327643wi__red
witched163012193witched
wited94727143wit__ed
withed134416233wit_hed
witherer14187953witherer
witherod15156153witherod
witted104216813wit_ted
wizened20275423wizened
wuthered15157433wuthered
yattered12239533yattered
yirred10426963yi_rred
zippered22244823zippered

Search took 8 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.1531167915.0
2DLD Change Limit1340274966.80019709.9
3Display Results4964960.1862666.7
 (SQL Overall)1786914967.13925030.3
 
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.