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

516 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
mottled1040997(None) 
bottled104611231bottled
mettled103510541mettled
mottle84116051mottle_
mottler94410341mottler
mottles93415801mottles
battled104213122battled
bottle84916072bottle_
bottler94211882bottler
bottles94216272bottles
cuttled10319932cuttled
dotted84717522dott_ed
dottle74212502dottle_
dottles83912282dottles
fettled11378932fettled
footled113610762footled
guttled9378992guttled
hotted104319942hott_ed
jostled15267082jostled
jotted143615172jott_ed
kittled12388192kittled
lotted74222402lott_ed
mantled104113392mantled
matted94521412matt_ed
metaled102913882metaled
mettle83815722mettle_
mettles94115022mettles
moated94819002moat_ed
mobled113213182mo_bled
modeled1139462modeled
moguled1135932moguled
moiled94318862mo_iled
molted94217472molt_ed
mooted94120372moot_ed
motile83818342motile_
motiles93317432motiles
motived13357762motived
motley1139382mo_tley
motored1039932motored
motte75526972mott_e_
mottes85523692mott_es
mottlers10388182mottlers
mottoes93412192mottoes
moulted103310312moulted
mouthed133811042mouthed
nettled8339942nettled
outled74020342_outled
pettled103611512pettled
potted94624012pott_ed
pottle84416102pottle_
pottles93816982pottles
rattled84012952rattled
rootled83410532rootled
rotted74524432rott_ed
settled83210872settled
sotted74121402sott_ed
tattled84311482tattled
tootled83511042tootled
totaled839692totaled
totted74319952tott_ed
vittled11347342vittled
wattled113610502wattled
wotted104115712wott_ed
batted95623653batt_ed
battle85217863battle_
battler94113383battler
battles94517683battles
beetled1038213beetled
betted94721163bett_ed
bitted94418483bitt_ed
blotted103911833blott_ed
boated94221973boat_ed
bobbled113811833bobbled
bobsled12297153bobsled
boggled12409003boggled
boiled95020953bo_iled
bolled94722653bo_lled
bolted94617803bolt_ed
boodled113410933boodled
booted94822733boot_ed
bootleg10276633bootleg
botched153611903botched
bottlers103810013bottlers
bottomed1344673bottomed
boweled132810693boweled
bowled125018143bo_wled
brattled11196723brattled
brittled11186093brittled
bustled104011513bustled
butled94818603_butled
butted94722063butt_ed
castled104311513castled
catted95422473catt_ed
cattle85118903cattle_
chortled14326613chortled
clotted104011823clott_ed
coaled95022713co_aled
coated94927043coat_ed
cobbled143411633cobbled
cockled163710823cockled
coddled123410573coddled
coffled16297363coffled
coiled95123943co_iled
coled85540763co__led
cooled95224593co_oled
costed95623113cost_ed
coted85033853co_t_ed
cottae84615703cottae_
cotter84926673cott_er
cottered112511733cottered
cottier93814173cottier
cottoned1138033cottoned
coupled124312673coupled
cowled125218393co_wled
cuittled1133993cuittled
cuttle84113893cuttle_
cuttles93613923cuttles
dartled9409853dartled
dittoed936733dittoed
doated84118183doat_ed
dogsled1035193dogsled
doiled84817293do_iled
doited85016633doit_ed
doled75430913do__led
dolled83518073do_lled
doodled10369463doodled
doted75227073do_t_ed
dottel73610893dott_el
dottels8327783dottels
dotter74419343dott_er
dottier83910923dottier
dottrel834463dottrel
doubled11289953doubled
doweled12269773doweled
embattled1442563embattled
emitted103010853emitt_ed
emoted94614923emo_t_ed
entitled967503entitled
fatted105419843fatt_ed
fetted104817893fett_ed
fettle93713123fettle_
fettles103912733fettles
fitted104716663fitt_ed
foaled104515963fo_aled
foiled104618403fo_iled
fondled12399423fondled
fooled104317823fo_oled
footed104418623foot_ed
footle93914383footle_
footler104011873footler
footles103715713footles
foozled20346893foozled
fouled104315973fo_uled
fowled133914103fo_wled
gentled9389093gentled
gitted84015053gitt_ed
goaled85014363go_aled
goateed9307063goateed
gobbled134010253gobbled
goggled11348953goggled
gotten73410113gott_en
grottoed10234503grottoed
gutted84716363gutt_ed
guttle74111973guttle_
guttler8369163guttler
guttles83011933guttles
hatted104921513hatt_ed
hobbled153310783hobbled
hogtied12226653hogtied
holed95634133ho__led
hondled123510653hondled
hooted104422663hoot_ed
hoppled15338083hoppled
hosted105020343host_ed
hosteled1237283hosteled
hostler103411023hostler
hotbed123310683ho_tbed
hotched163610923hotched
hotter94720083hott_er
hottie92514383hottie_
hotties103016963hotties
hoveled14209293hoveled
howled134014973ho_wled
hurtled11339593hurtled
hustled113210133hustled
hutted104616333hutt_ed
intitled967343intitled
jetted143915083jett_ed
jettied15366973jettied
joggled17398433joggled
jolted143510633jolt_ed
jostle13319863jostle_
jostler14288223jostler
jostles143411143jostles
jotter134315633jott_er
jowled174210803jo_wled
justled15338093justled
jutted144315023jutt_ed
juttied15417863juttied
kettle104311613kettle_
kettles113411613kettles
kirtled12287033kirtled
kitted115114833kitt_ed
kittle104012173kittle_
kittler11338163kittler
kittles113012493kittles
knotted12357233knott_ed
kotowed1533773kotowed
letted74118543lett_ed
little63312163little_
littler7348553littler
littles73212783littles
loathed11419443loathed
loculed10317653loculed
lofted103811893loft_ed
lolled74315823lo_lled
looted74421113loot_ed
lotte54923853lott_e_
lotter64025603lott_er
lottes65322753lott_es
louted74920693lout_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
matured10310033matured
mauled94817823m_auled
measled10339303measled
meated94222403meat_ed
medaled113411613medaled
meddled123210033meddled
melled95023023m_elled
melted94219063melt_ed
metalled1148983metalled
meted85424433m_et_ed
metered103514013metered
metred95315143m_etred
mewled123710053m_ewled
miauled1036663miauled
middled123311903middled
milled94326173m_illed
milted93919943milt_ed
mingled113612733mingled
minted94220583mint_ed
misled94719313m_isled
mispled12310463mispled
misted93625823mist_ed
mistitled1246283mistitled
mitered103213233mitered
mitred94414343m_itred
mitten83914093mitt_en
mittened1136363mittened
mizzled18327633mizzled
moaned94514173mo_aned
mobbed137112243mo_bbed
mobile103613543mobile_
mobiles112813123mobiles
mocked154716613mo_cked
modeler1039293modeler
modelled1236433modelled
modemed1336723modemed
module93011033module_
modules102511003modules
mogged115215393mo_gged
moiler84017263mo_iler
mold76034333mo__l_d
molded104414083mo_lded
mole66251833mo__le_
moles74747923mo__les
molten83311813molt_en
molter84119423molt_er
moneyed1337493moneyed
monied94319463mo_nied
monocled1337113monocled
montaged12107763montaged
monte75829773mont_e_
montes84226933mont_es
mooched153910533mooched
mooed85123983mo__oed
mooley11311633mo_oley
mooned94216643mo_oned
moonlet92413273moonlet
moored93814173mo_ored
mooter83921093moot_er
moped105424733mo__ped
mopped134114323mo_pped
morale85220553morale_
morales93619403morales
morphed1537133morphed
morseled1147193morseled
mortared1137213mortared
morticed1377163morticed
mortised1178743mortised
moseyed1336133moseyed
moshed124517493mo_shed
mossed94818893mo_ssed
moste75925083most_e_
mostly113110943mostl_y
mote67048083mo_t_e_
motel76623243mo_t_el
motels83616893motel_s
motes75944003mo_t_es
motet75641193mo_t_et
motey105922953mo_t_ey
mother113718643mo_ther
mothered142310103mothered
mothier121910213mothier
motioned1137453motioned
motive113112143motive_
motives123611893motives
motleys1235683mo_tleys
motlier92010583motlier
mott66648443mott___
mottling11197753mottling
motto76119513mott__o
mottos84615243mott_os
motts76527003mott__s
mouched153612593mouched
mould86015753mo_ul_d
moulded11348063moulded
moulter93812423moulter
mounded113711983mounded
mounted103611533mounted
mourned1037763mourned
moused94423303mo_used
moussed10338913moussed
mouther123812813mouther
moved114218153mo__ved
mowed113629013mo__wed
muddled124111593muddled
muffled16377783muffled
muled85824433m__uled
mulled94721553m_ulled
mumbled143010763mumbled
muraled10410833muraled
muscled1237783muscled
musted93321073must_ed
mutated102712253mutated
muted85023383m_ut_ed
mutined103311353mutined
mutter84418883mutt_er
muttered112610793muttered
mutule8311423mutule_
mutules9311843mutules
muzzled18267753muzzled
myrtle1135733myrtle_
myrtles1235733myrtles
nestled8349903nestled
netted74118713nett_ed
nettle64514583nettle_
nettler7349503nettler
nettles73214083nettles
nobbled123511283nobbled
noddled10358563noddled
noodled9339923noodled
notated82713663notated
notched134210303notched
noted65123843no_t_ed
noticed1037863noticed
nutted74316973nutt_ed
ogled75915963_o_gled
oiled64429473_o_iled
omitted10347893omitted
opted84914273_opt_ed
ostler63312193_ostler
otter54423973_ott_er
outed65429063_out_ed
outlead83311103_outlead
outlet63728683_outlet
patted94724683patt_ed
pestled102711443pestled
petaled103614153petaled
petted94121523pett_ed
pettle84116053pettle_
pettles93916483pettles
pitted94319593pitt_ed
plotted104612373plott_ed
poled84934843po__led
polled94022003po_lled
pooled94619813po_oled
poppled11339243poppled
portaled11239203portaled
ported94223243port_ed
posted93722493post_ed
potholed1448393potholed
potteen9319673potteen
potter83926983pott_er
pottered112311663pottered
pottier93516493pottier
potties93723543potties
pouted94021393pout_ed
prattled11246533prattled
putted94220253putt_ed
puttied103811163puttied
ratted74923343ratt_ed
rattle64717613rattle_
rattler74012743rattler
rattles73217303rattles
rebottled1243433rebottled
retiled84420513retiled
retitled9339553retitled
retted74826313rett_ed
roiled74320053ro_iled
rolled74220243ro_lled
rooted75424003root_ed
rootle63214453rootle_
rootles73215633rootles
rootlet73015733rootlet
rotated82715293rotated
rotte54625933rott_e_
rotten64115433rott_en
rotter64325463rott_er
rottes64524833rott_es
routed75624333rout_ed
roweled11269863roweled
rustled83311323rustled
rutted74518403rutt_ed
scuttled1134533scuttled
settle63915663settle_
settler73410653settler
settles73916003settles
shotted113912403shott_ed
shuttled1234673shuttled
slotted84613883slott_ed
smoothed14236473smoothed
smutted1037463smutt_ed
soiled73822473so_iled
soled65835173so__led
sooted73922593soot_ed
soothed113712743soothed
sorted74523713sort_ed
sortied83314103sortied
souled75419823so_uled
southed114313993southed
sozzled16265183sozzled
spotted103713143spott_ed
staled74728103_staled
stoled74521593_stoled
stooled84313893stooled
stotted83511423stotted
styled105613103_styled
swotted11398713swott_ed
tatted74920533tatt_ed
tattle64115653tattle_
tattler73112213tattler
tattles73616283tattles
throttled1352963throttled
tiled64832943__tiled
titled73815003_titled
tittle63613323tittle_
tittles73413253tittles
toddled10328823toddled
toggled10428653toggled
toiled74420323to_iled
toited74016753toit_ed
toled65934923__toled
tolled73819033to_lled
tooled74918903to_oled
tooted74620123toot_ed
toothed113310243toothed
tootle62613813tootle_
tootler73511123tootler
tootles72915603tootles
toppled12348843toppled
totalled935843totalled
toted64929483to_t_ed
totter65021463tott_er
tottered9208703tottered
tousled84710363tousled
touted74419743tout_ed
touzled17367153touzled
toweled112410223toweled
trotted83711283trott_ed
turtled8309683turtled
tutted75117443tutt_ed
twattled1273463twattled
unbottled1244153unbottled
untitled978763untitled
vatted104214733vatt_ed
vetted104316323vett_ed
vittle94711753vittle_
vittles103211113vittles
voled95323723vo__led
voted93919143vo_t_ed
wattle94314213wattle_
wattles103814073wattles
wetted103717023wett_ed
whittled1594913whittled
wintled11339843wintled
witted104216813witt_ed
wobbled15349593wobbled
wonted103213283wont_ed
wooled103715503wo_oled
woolled1136643woolled
worthed1437873worthed
yodeled1236863yodeled
yodled11389653yo_dled
yowled133811093yo_wled

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.390458182.1
2DLD Change Limit1340275166.90619407.3
3Display Results5165160.1732982.7
 (SQL Overall)1786915167.46923924.4
 
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.