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

467 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
mettled10351054(None) 
fettled11378931fettled
metaled102913881metaled
mettle83815721mettle_
mettles94115021mettles
mottled10409971mottled
nettled8339941nettled
pettled103611511pettled
settled83210871settled
battled104213122battled
beetled1038222beetled
betted94721162bett_ed
bottled104611232bottled
cuttled10319932cuttled
fetted104817892fett_ed
fettle93713122fettle_
fettles103912732fettles
gentled9389092gentled
guttled9378992guttled
jetted143915082jett_ed
jettied15366972jettied
kettle104311612kettle_
kettles113411612kettles
kittled12388192kittled
letted74118542lett_ed
mantled104113392mantled
matted94521412matt_ed
measled10339302measled
meated94222402meat_ed
medaled113411612medaled
meddled123210032meddled
melled95023022me_lled
melted94219062melt_ed
metalled1148992metalled
meted85424432me_t_ed
metered103514012metered
metred95315142me_tred
mewled123710052me_wled
mottle84116052mottle_
mottler94410342mottler
mottles93415802mottles
nestled8349912nestled
netted74118712nett_ed
nettle64514582nettle_
nettler7349502nettler
nettles73214082nettles
pestled102711452pestled
petaled103614152petaled
petted94121522pett_ed
pettle84116052pettle_
pettles93916482pettles
rattled84012952rattled
retiled84420512retiled
retitled9339552retitled
retted74826312rett_ed
settle63915662settle_
settler73410652settler
settles73916002settles
tattled84311482tattled
vetted104316322vett_ed
vittled11347342vittled
wattled113610502wattled
wetted103717022wett_ed
abetted1058323abett_ed
batted95623653batt_ed
battle85217863battle_
battler94113383battler
battles94517683battles
beetle8311673beetle_
beetler938043beetler
beetles9312083beetles
belittled1243033belittled
belled94626193be_lled
belted94020633belt_ed
berthed13259123berthed
bested94922763best_ed
betaxed17307023betaxed
betided114810203betided
better84723703bett_er
bettered113011843bettered
beveled133811133beveled
bitted94418483bitt_ed
bottle84916073bottle_
bottler94211883bottler
bottles94216273bottles
brattled11196723brattled
brittled11186093brittled
bustled104011523bustled
butled94818603_butled
butted94722063butt_ed
castled104311513castled
catted95422473catt_ed
cattle85118903cattle_
ceiled94114953ce_iled
celled94420323ce_lled
centred103411683centred
cuittled1133993cuittled
cuttle84113893cuttle_
cuttles93613923cuttles
dartled9409853dartled
defiled124013103defiled
deled75326543de__led
dented84120513dent_ed
dentiled1039743dentiled
detailed10319873detailed
detoxed1636103detoxed
develed123611933develed
deviled124112183deviled
dittoed936733dittoed
dotted84717523dott_ed
dottle74212503dottle_
dottles83912283dottles
duetted937023duett_ed
eagled82914043_eagled
emailed10359213emailed
embattled1442563embattled
emitted103010853emitted
emoted94614923emot_ed
empaled12288953empaled
emptied1297393emptied
entitled967503entitled
etched123613703_etched
exiled144712463_exiled
fatted105419843fatt_ed
felled103720303fe_lled
felted103714653felt_ed
feruled11318423feruled
fetched163710473fetched
feted94420933fe_t_ed
fetter94120383fett_er
fettered12259493fettered
fitted104716663fitt_ed
footled113610763footled
fretted113411853frett_ed
gelled84718893ge_lled
gentle74014513gentle_
gentler8378953gentler
gentles83714343gentles
getter74117613gett_er
gettered10258613gettered
ghettoed1342083ghettoed
gitted84015053gitt_ed
gutted84716363gutt_ed
guttle74111973guttle_
guttler8369163guttler
guttles83011933guttles
hatted104921513hatt_ed
healed105121443he_aled
heated104525593heat_ed
heckled17318463heckled
heeled104018413he_eled
hefted134911423heft_ed
heiled104415613he_iled
helled104024703he_lled
hented104218753hent_ed
hotted104319943hott_ed
hurtled11339593hurtled
hustled113210133hustled
hutted104616333hutt_ed
intitled967343intitled
jelled144916063je_lled
jested144416503jest_ed
jettier14358693jettier
jetties143613123jetties
jeweled1845333jeweled
jostled15267083jostled
jotted143615173jott_ed
justled15338093justled
jutted144315023jutt_ed
juttied15417863juttied
keckled13376503keckled
keeled114414273ke_eled
kirtled12287033kirtled
kitted115114833kitt_ed
kittle104012173kittle_
kittler11338163kittler
kittles113012493kittles
letched133912053letched
letter63722583lett_er
lettered92910783lettered
leveled114010383leveled
little63312163little_
littler7348553littler
littles73212783littles
lotted74222403lott_ed
mackled164111923mackled
macled116718113m_acled
maculed123510053maculed
mailed95326753m_ailed
malled94626113m_alled
malted94819863malt_ed
mangled113615263mangled
mantle84420923mantle_
mantles94820703mantles
mantlet93620993mantlet
marbled123212113marbled
marled95523163m_arled
marted94425213mart_ed
martlet93419153martlet
masted94025803mast_ed
matched153513963matched
mated85537783m_at_ed
matte75626843matt_e_
matter84325343matt_er
mattered112412903mattered
mattes85624533matt_es
mattoid1079283mattoid
matured10310043matured
mauled94817823m_auled
measle83513223measle_
measles92412753measles
meathead1436793meathead
meatier93214613meatier
meatless103410863meatless
meatmen1138243meatmen
medalled1246893medalled
meddle103312763meddle_
meddler11319953meddler
meddles113213253meddles
medley1298343me_dley
meed74934703me___ed
meeter83616503meet_er
meetly1138673meetl_y
meikle1236653meikle_
melamed1249633melamed
meld75830473me__l_d
melded104714713me_lded
melee73729103me__lee
melter83520113melt_er
menaced122710093menaced
mended104418683me_nded
mensed93916543me_nsed
mentee84121293ment_ee
mentees93214503mentees
mentored1138003mentored
meoued9118533me_oued
meowed12148003me_owed
merged104214953me_rged
merited10313853merited
merle75824373me_rle_
merles85322763me_rles
meshed124415933me_shed
messed95018183me_ssed
mestee84523883mest_ee
mestees94617753mestees
metage93114453metage_
metages102714973metages
metal75427383metal__
metalhead1543213metalhead
metalised12310463metalised
metalized21412183metalized
metals84520893metal_s
metamer1139613metamer
metate82720533metate_
metates92720013metates
mete64438133me_t_e_
meter75130323me_t_er
metes74736213me_t_es
method1239033me_thod
metier83517693me_tier
metol75917813metol__
metols84115773metol_s
metope10611123metope_
metopes11311363metopes
metre74821303me_tre_
metres85121563me_tres
mewed115218013me__wed
mewler113510233me_wler
miauled1036663miauled
middled123311903middled
milled94326173m_illed
milted93919943milt_ed
mingled113612733mingled
minted94220583mint_ed
misled94719313m_isled
mispled12310463mispled
misted93625823mist_ed
mistitled1246283mistitled
mitered103213233mitered
mitred94414343m_itred
mitten83914093mitt_en
mittened1136363mittened
mizzled18327633mizzled
moated94819003moat_ed
mobled113213183m_obled
modeled1139463modeled
moguled1135933moguled
moiled94318863m_oiled
molted94217473molt_ed
mooted94120373moot_ed
motile83818343motile_
motiles93317433motiles
motived13357763motived
motley1139383m_otley
motored1039933motored
motte75526973mott_e_
mottes85523693mott_es
mottlers10388183mottlers
mottoes93412193mottoes
moulted103310313moulted
mouthed133811043mouthed
muddled124111593muddled
muffled16377783muffled
muled85824433m__uled
mulled94721553m_ulled
mumbled143010763mumbled
muraled10410833muraled
muscled1237783muscled
musted93321073must_ed
mutated102712253mutated
muted85023383m_ut_ed
mutined103311353mutined
mutter84418883mutt_er
muttered112610793muttered
mutule8311423mutule_
mutules9311843mutules
muzzled18267753muzzled
myrtle1135733myrtle_
myrtles1235733myrtles
needled9358513needled
nested74720063nest_ed
nestle63013953nestle_
nestler73510453nestler
nestles73015463nestles
netter63722023nett_er
nettier74211813nettier
nettlers8307513nettlers
nettlier864813nettlier
nettly9459453nettl_y
nutted74316973nutt_ed
omitted10347893omitt_ed
outled74020343_outled
patted94724683patt_ed
pealed95322813pe_aled
pearled10411553pearled
pebbled1445403pebbled
pedaled113711893pedaled
peddled123410543peddled
peeled94119713pe_eled
pelted94617763pelt_ed
peopled1238503peopled
periled10316323periled
pestle83215843pestle_
pestles93217693pestles
petalled1138713petalled
petered103314973petered
petioled1137993petioled
petter83924773pett_er
pettier94213613pettier
pitted94319593pitt_ed
potted94624013pott_ed
pottle84416103pottle_
pottles93816983pottles
prattled11246533prattled
prettied1159253prettied
putted94220253putt_ed
puttied103811163puttied
ratted74923343ratt_ed
rattle64717613rattle_
rattler74012743rattler
rattles73217303rattles
rebottled1243433rebottled
reddled102912323reddled
reeled74725533re_eled
refiled114318653refiled
regaled93615963regaled
rented74426593rent_ed
reoiled84316853reoiled
repled93319783re_pled
resettled1035303resettled
resiled84621983resiled
resoled84119283resoled
rested74430783rest_ed
restyled1236953restyled
retailed94113963retailed
retaped103814283retaped
retaxed153512233retaxed
retched133814273retched
retied75924983re_tied
retile65929673retile_
retiles74426993retiles
retimed104714653retimed
retired84620143retired
retitle73913093retitle_
retitles83612593retitles
retold73013753retol_d
retooled938473retooled
retotaled1045953retotaled
retried84419153retried
retuned86613973retuned
retyped13367303retyped
reveled113917753reveled
reviled114417923reviled
rootled83410533rootled
rotted74524433rott_ed
rustled83311323rustled
rutted74518403rutt_ed
scuttled1134533scuttled
sealed74328363se_aled
seated75131063seat_ed
seeled73922093se_eled
seethed113410193seethed
sepaled10510593sepaled
settee63721023sett_ee
settees73513633settees
setter64023723sett_er
settlers8289023settlers
settlor7314733settlor
shuttled1234673shuttled
smelled103511863sme_lled
smelted10399093smelt_ed
smutted1037463smutt_ed
sotted74121403sott_ed
staled74728103_staled
steeled83513223steeled
stetted82610403stetted
stoled74521593_stoled
styled105613103_styled
tatted74920533tatt_ed
tattle64115653tattle_
tattler73112213tattler
tattles73616283tattles
teated74924023teat_ed
teazled17326833teazled
teethed11318623teethed
templed12278563templed
tented74221003tent_ed
tested74421523test_ed
tetched133010773tetched
tetter64322453tett_er
tiled64832943__tiled
titled73815003_titled
tittle63613323tittle_
tittles73413253tittles
toled65934923__toled
tootled83511043tootled
totaled839693totaled
totted74319953tott_ed
turtled8309683turtled
tutted75117443tutt_ed
twattled1273463twattled
unsettled1055213unsettled
untitled978763untitled
vatted104214733vatt_ed
vealed103916323ve_aled
veiled103714543ve_iled
vented104617923vent_ed
vested104217353vest_ed
vetoed10359823ve_toed
vetter93417643vett_er
vittle94711753vittle_
vittles103211113vittles
wattle94314213wattle_
wattles103814073wattles
wedeled1237783wedeled
weeted103913793weet_ed
welled103820213we_lled
welted103715823welt_ed
wetter93919443wett_er
whetted14256693whett_ed
whittled1594913whittled
wintled11339843wintled
witted104216813witt_ed
wotted104115713wott_ed
wrestled12296763wrestled
yelled104116253ye_lled
zested164214043zest_ed

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 Filter1786911340270.423422437.4
2DLD Change Limit1340274678.09316560.9
3Display Results4674670.1732699.4
 (SQL Overall)1786914678.68920565.2
 
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.