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

401 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
marblers1231923(None) 
garblers113810281garblers
marbler113511671marbler_
marbles114516651marble_s
warblers13319101warblers
amblers115213562_amblers
babblers113510352babblers
barbers114317502barb_ers
barbless12318712barbless
burblers12399262burblers
cablers114416712ca_blers
carolers103314172carolers
dabblers13379362dabblers
fablers124812612fa_blers
gabblers134110082gabblers
gamblers13369732gamblers
garbler104012562garbler_
garbles104016922garble_s
garbless11388252garbless
garglers10418262garglers
mailers94420332ma_ilers
manglers113311902manglers
marble104219102marble__
marbled123212112marble_d
marbleise1343482marbleise
marblier1256342marblier_
marchers153710812marchers
mariners103113862mariners
markers133516102mar_kers
marrers93414312mar_rers
marriers103312472marriers
martlets103310482martlets
maulers94213302ma_ulers
mumblers14328762mumblers
rabblers123810852rabblers
ramblers124010372ramblers
wabblers15398992wabblers
warbler123211462warbler_
warbles123215562warble_s
warslers11328072warslers
abler75624313_a_bler_
ables75935543_a_ble_s
ambeers11428923_ambeers
ambers104519583_amb_ers
ambler104916453_ambler_
ambles105121863_amble_s
anglers84014823_anglers
antlers74014743_antlers
arables91814973_arable_s
arbiters1038853_arbiters
arbores94016033_arbores
arbors84717883_arb_ors
arbours93910043_arbours
archers124414573_archers
argles75218483_argle_s
arguers8489033_arguers
arles56735743_ar_le_s
armers85520273_ar_mers
armless9369943_armless
armlets94610063_armlets
artless73712513_artless
ashlers10319583_ashlers
babbler104012823babbler_
babbles104416323babble_s
bafflers16356593bafflers
bailers94221353ba_ilers
balers85626933ba__lers
ballers94421013ba_llers
barbells12368823barbells
barbels114514433barb_els
barber104419323barb_er_
barbes104526233barb_e_s
barbets114915843barb_ets
barbies114519593barbie_s
barbules1238043barbule_s
barkers134318513bar_kers
barkless14318023barkless
barless94317003bar_less
barleys125011843bar_leys
barriers104311883barriers
barters94223033bar_ters
battlers104110973battlers
baubles113611863bauble_s
bawlers124412733ba_wlers
birlers93813003bir_lers
brabblers12335563brabblers
brawlers13408643brawlers
bubblers11448943bubblers
bumblers143710733bumblers
burbler114412423burbler_
burbles114916803burble_s
burlers94120273bur_lers
cabers105023923ca_b_ers
cabler104519173ca_bler_
cables104527553ca_ble_s
cablets114216343ca_blets
cacklers163710703cacklers
cajolers17267133cajolers
callers94221963ca_llers
cambers134017443camb_ers
candlers114214103candlers
carders104820353car_ders
careers95218783car_eers
careless102813633careless
carers85133963car__ers
carles85435083car_le_s
carless95118493car_less
caroler93816753caroler_
carollers1137703carollers
carpers114521253car_pers
carriers103614203carriers
carters95327253car_ters
carvers124817543car_vers
cavilers1348113cavilers
circlers1235353circlers
cobblers14359593cobblers
corulers1039773corulers
crabbers14358753crabbers
cradlers11309203cradlers
crawlers13309013crawlers
curbers115514383curb_ers
curdlers11368493curdlers
curlers94218073cur_lers
dabbers123813213da_bbers
dabbler124012153dabbler_
dabbles124514773dabble_s
dandlers103912053dandlers
danglers103610593danglers
darbars10510093darb_ars
darbies104216983darbie_s
darers75921873dar__ers
darkles124011933darkle_s
darners83815773dar_ners
darters84017603dar_ters
dartles84014133dartle_s
daubers104610423daub_ers
dawdlers13375673dawdlers
dazzlers1733233dazzlers
dibblers13377583dibblers
doublers11288503doublers
drawlers12307313drawlers
earless74316073ear_less
earners74016453ear_ners
enablers10196913enablers
fabler116115813fa_bler_
fables114921673fa_ble_s
fallers103917993fa_llers
farcers124713443far_cers
farers95924053far__ers
farles96025783far_le_s
farmers124315263far_mers
farriers113610743farriers
fartleks1533963fartleks
fumblers15318713fumblers
furlers104214223fur_lers
gabbers124612833ga_bbers
gabbler124013303gabbler_
gabbles124415413gabble_s
gables94222333ga_ble_s
gambiers13337073gambiers
gambler123612683gambler_
gambles124016203gamble_s
gaolers83511563ga_olers
garble94118453garble__
garbled114512803garble_d
gargler93710263gargler_
gargles94214893gargle_s
garners83815983gar_ners
garters84218233gar_ters
girdlers10195403girdlers
gobblers13308343gobblers
grabbers13337883grabbers
grabblers14345513grabblers
hacklers173710303hacklers
hagglers13326623hagglers
hailers104017263ha_ilers
halers94926913ha__lers
handlers124014143handlers
harborers1446913harborers
harbors12412413harb_ors
harbours1346923harbours
harmers124116593har_mers
harmless1337403harmless
harpers124916203har_pers
harriers113712433harriers
harslets1137833harslets
haulers104012443ha_ulers
herbless1336663herbless
hobblers15308513hobblers
humblers15379803humblers
hurdlers12337493hurdlers
hurlers103714323hur_lers
jabbers183610583ja_bbers
jailers144114043ja_ilers
janglers16319373janglers
jumblers19358323jumblers
labelers10249413labelers
ladlers84613573la_dlers
lambers113817113lamb_ers
landlers94312833landlers
larders83516943lar_ders
larkers113014513lar_kers
mabes96331533ma_b_e_s
macers105321273ma__cers
mackles154415753mackle_s
macles107023223ma_cle_s
macules114015133macule_s
madders113513213ma_dders
maglevs1334693ma_glevs
mailer84724183ma_iler_
mailes84329113ma_ile_s
mailless10248583mailless
maimers113813043ma_imers
makers123921733ma__kers
malars85020683ma__lars
males75049793ma__le_s
mallees93315973ma_llees
mallets93318493ma_llets
malleus92911313ma_lleus
mamboes135011823mamboe_s
mammers104615693ma_mmers
mamzers20409163ma_mzers
managers112911003managers
maneless102812343maneless
mangers103521263ma_ngers
mangler103215643mangler_
mangles104021463mangle_s
manless93012933ma_nless
manners93417833ma_nners
mantles94820703mantle_s
mantlets104611203mantlets
manurers1037593manurers
maples104819423ma_ple_s
mappers133313783ma_ppers
marauders1244263marauders
marbleised1542603marbleised
marbleises1443523marbleises
marbleize2243073marbleize
marbleizes2342943marbleizes
marbliest1336763marbliest
marbling13179883marbling
marblings14225543marblings
marbly134111933marbl__y
marcellers1443833marcellers
marcels113212373mar_cels
marcher143912973marcher_
marches143921173marche_s
mares76457633mar__e_s
marges94525713mar_ge_s
mariner93315993mariner_
marines93928013marine_s
marker124420393mar_ker_
marketers1545983marketers
markets133314033mar_kets
markhors1745393markhors
marled95523163mar_le_d
marlier92614773marlier_
marlins93420473mar_lins
marls75535163mar_l__s
marplots1245633marplots
marquees19206243marquees
marques182610863marque_s
marquess19204953marquess
marrer83716673mar_rer_
marrieds11288073marrieds
marrier93817523marrier_
marries93825283marrie_s
marses84827113mar_se_s
marshes123615373marshe_s
martens93714953mar_tens
martlet93419153martle_t
martyrs1234893mar_tyrs
marvels123810093mar_vels
masers84623453ma__sers
mashers124621053ma_shers
maskers133913843ma_skers
masquers19195703masquers
massless10277113massless
masters94628923ma_sters
mastless102610023mastless
matchers153012433matchers
mateless102711293mateless
maters85032393ma__ters
matless93014043ma_tless
matters94421753ma_tters
maturers1037373maturers
mauler84416713ma_uler_
maunders11348343maunders
maybes1339243mayb_e_s
mazers173917093ma__zers
meddlers12318203meddlers
members13258603memb_ers
mercers114412773mer_cers
mergers103813423mer_gers
merles85322763mer_le_s
mewlers12288983m_ewlers
middlers123410193middlers
milers84625163m__ilers
millers93621343m_illers
minglers113011293minglers
mobbers133610923m_obbers
modelers1138463modelers
moilers93615203m_oilers
morales93619403morale_s
mottlers10388183mottlers
muddlers12428813muddlers
mufflers16316003mufflers
mullers93217303m_ullers
mumbler133510913mumbler_
mumbles133014433mumble_s
murders103311363mur_ders
murthers1336543murthers
muzzlers18245203muzzlers
myrtles1235733myrtle_s
nabbers113710463na_bbers
nailers73215893na_ilers
nibblers12306543nibblers
nobblers12318563nobblers
oarless73913373oar_less
orbless937493_orbless
paddlers12329153paddlers
parables121613563parable_s
paraders113113113paraders
pardners11269193pardners
parers85530743par__ers
parkers133816873par_kers
parles86334403par_le_s
parleys125212373par_leys
parlors9312913par_lors
parolees104313983parolees
paroles95025883parole_s
parriers103612903parriers
parsers94118153par_sers
parsleys1335083parsleys
partiers103514243partiers
partlets102811513partlets
partners102711133partners
partyers13277763partyers
pearlers1039033pear_lers
purflers13216963purflers
rabbler113514093rabbler_
rabbles113517973rabble_s
rafflers14317363rafflers
railers74420663ra_ilers
rambler113313263rambler_
rambles113118313ramble_s
rattlers83510293rattlers
ravelers113310863ravelers
rulers64317093__rulers
rumblers123610743rumblers
sabers85224733sa_b_ers
sables85026693sa_ble_s
saddlers10289753saddlers
sailers73822323sa_ilers
samplers12299403samplers
snarlers8298753snar_lers
sparklers15315643sparklers
stablers103611153stablers
startlers9236743startlers
tabers84621573ta_b_ers
tables84524893ta_ble_s
tablets94714383ta_blets
tacklers143010773tacklers
tailers73720183ta_ilers
talers64628143ta__lers
tanglers92911973tanglers
tarriers83411713tarriers
tarsiers8298533tarsiers
tartlets8289663tartlets
tattlers8369693tattlers
trailers82912923trailers
trawlers113310203trawlers
tumblers123110623tumblers
turtlers8258203turtlers
variers103712663var_iers
varlets10411573var_lets
verbless1336033verbless
wabbler143511923wabbler_
wabbles144013993wabble_s
waddlers13298333waddlers
wafflers17306323wafflers
wailers103916803wa_ilers
walers94824463wa__lers
wambles143714023wamble_s
wanglers123310033wanglers
warble113516603warble__
warbled133212163warble_d
warders113416813war_ders
wardless12249303wardless
warless104015103war_less
warmers124514293war_mers
warners103315563war_ners
warpers123413583war_pers
warsler10289893warsler_
warsles103413643warsle_s
warstlers12284713warstlers
wartless11279923wartless
wobblers15327883wobblers
yabbers14389353ya_bbers
yarders113211593yar_ders
yarners104312203yar_ners

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 Filter1786911461620.450397091.1
2DLD Change Limit1461624016.51622431.2
3Display Results4014010.1562570.5
 (SQL Overall)1786914017.12225090.0
 
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.