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

366 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
marchers15371081(None) 
archers124414571_archers
marcher143912971marcher_
marches143921171marche_s
matchers153012431matchers
archer115016242_archer_
archery15478062_archery
arches114822042_arche_s
batchers153613272batchers
catchers153114062catchers
farcers124713442farc_ers
hatchers163113172hatchers
larches124416442larche_s
lurchers13307152lurchers
macers105321272ma_c_ers
maches134827232ma_che_s
manches143818622manche_s
manchets15269572manchets
marblers12319232marblers
marcels113212372marc_els
marched153813402marche_d
marchen143312072marche_n
marchesa15346882marchesa
marchese15358912marchese
marchesi15337322marchesi
mariners103113862mariners
markers133516102mar_kers
markhors1745392markhors
marrers93414312mar_rers
marriers103312472marriers
marshes123615372marshe_s
mashers124621052ma_shers
matcher143214282matcher_
matches143219782matche_s
mercers114412772merc_ers
merches144013762merche_s
moochers15369122moochers
munchers15318772munchers
murthers1336542murthers
parches143720002parche_s
patchers153413302patchers
perchers153611522perchers
ranchers133311792ranchers
searchers14197352searchers
watchers163511792watchers
aches106132293_a_che_s
aethers103614943_aethers
amercers1256133amerc_ers
anchors123912953_anchors
anthers103715203_anthers
archean1269123_archean
arched125717323_arche_d
archeries14411223_archeries
archils12510533_archils
archness1337513_archness
archons12311583_archons
arguers8489033_arguers
armers85520273_ar_mers
baches135426943ba_che_s
backers153821883ba_ckers
barbers114317503bar_bers
barchans1588683barchans
barkers134318513bar_kers
barriers104311883barriers
barters94223033bar_ters
bashers124820833ba_shers
batcher144414853batcher_
batches144019613batche_s
bathers124720363ba_thers
belchers153510023belchers
benchers153611013benchers
birches143412323birche_s
blanchers16307433blanchers
bluchers15359033bluchers
botchers153511543botchers
bracers114616703brac_ers
braches144621223brache_s
brachets154311983brachets
burghers1435633burghers
butchers153710183butchers
caches137926913ca_che_s
cachets145014263ca_chets
cancers114018583canc_ers
carcels114516063carc_els
carders104820353car_ders
careers95218783car_eers
carers85133963car__ers
caroches15710693caroche_s
carolers103314173carolers
carpers114521253car_pers
carriers103614203carriers
carters95327253car_ters
carvers124817543car_vers
catcher143115823catcher_
catches144320773catche_s
circlers1235353circlers
coachers154312303coachers
couchers153513863couchers
crackers164111723crackers
crashers134013233crashers
curches143512743curche_s
dackers143417043da_ckers
dancers103413093danc_ers
darers75921873dar__ers
darners83815773dar_ners
darters84017603dar_ters
dashers115016863da_shers
demarches1745913demarche_s
ditchers143610363ditchers
earaches13411303earache_s
earners74016453ear_ners
enrichers1444133enrichers
etchers123411293_etchers
facers115519443fa_c_ers
fanciers13358083fanciers
farcer115016083farc_er_
farces115223323farc_e_s
farceurs13464723farceurs
farcies125317883farcie_s
farers95924053far__ers
farmers124315263far_mers
farriers113610743farriers
farther1348343farther_
fathers133916503fa_thers
fetchers16328863fetchers
filchers16286863filchers
forcers124215713forc_ers
furthers1436493furthers
garblers113810283garblers
garglers10418263garglers
garners83815983gar_ners
garters84218233gar_ters
gathers114315073ga_thers
gaucher1337233gaucher_
hackers164619043ha_ckers
harmers124116593har_mers
harpers124916203har_pers
harriers113712433harriers
harshens1437603harshens
harsher13310363harsher_
hatchels16368673hatchels
hatcher153314723hatcher_
hatchery19326383hatchery
hatches153420273hatche_s
hatchets163310383hatchets
hitchers16379993hitchers
inarches1358043inarche_s
inchers123912523_inchers
jackers204214453ja_ckers
kashers143914023ka_shers
lacers85225253la_c_ers
laches116528343la_che_s
lackers134120543la_ckers
lancers93616643lanc_ers
lanciers10308543lanciers
larceners1135993larceners
larchen12479623larche_n
larders83516943lar_ders
larkers113014513lar_kers
lashers104121833la_shers
latches123320123latche_s
latchets133410013latchets
lathers104321883la_thers
laughers1235923laughers
launchers1454333launchers
leachers133712813leachers
lechers123313963_lechers
lunchers13349563lunchers
lurcher12338133lurcher_
lurches123311663lurche_s
lynchers16285453lynchers
macer912126943ma_c_er_
maces97139963ma_c_e_s
mache125925303ma_che__
machete14310883ma_chete
machetes1539633ma_chetes
machos135217493ma_ch_os
machree1438513ma_chree
machrees1545503ma_chrees
machs125722563ma_ch__s
machzors2444113ma_chzors
macles107023223ma_cle_s
madders113513213ma_dders
maihems1444303ma_ihems
mailers94420333ma_ilers
maimers113813043ma_imers
makers123921733ma__kers
mammers104615693ma_mmers
mamzers20409163ma_mzers
managers112911003managers
manche133515103manche__
manchet143317783manche_t
mangers103521263ma_ngers
manglers113311903manglers
manners93417833ma_nners
manurers1037593manurers
mappers133313783ma_ppers
marauders1244263marauders
marbler113511673marbler_
marbles114516653marble_s
marcatos1249163marcatos
marcel103714853marc_e_l
marcellers1443833marcellers
march125622893march___
marching164312193marching
marcs95726623marc___s
mares76457633mar__e_s
marges94525713mar_ge_s
mariner93315993mariner_
marines93928013marine_s
marishes13512553marishe_s
marker124420393mar_ker_
marketers1545983marketers
markets133314033mar_kets
markhoors1842703markhoors
markhor1635463markhor_
marlier92614773marlier_
marquees19206243marquees
marques182610863marque_s
marquess19204953marquess
marrer83716673mar_rer_
marrieds11288073marrieds
marrier93817523marrier_
marries93825283marrie_s
marses84827113mar_se_s
marshals1337783marshals
marshier1337593marshier_
martens93714953mar_tens
martlets103310483martlets
martyrs1234893mar_tyrs
marvels123810093mar_vels
masers84623453ma__sers
masher114123203ma_sher_
mashes115030003ma_she_s
maskers133913843ma_skers
masquers19195703masquers
masters94628923ma_sters
matched153513963matche_d
matchless1644683matchless
matchups1743073matchups
maters85032393ma__ters
matters94421753ma_tters
maturers1037373maturers
maulers94213303ma_ulers
maunders11348343maunders
mayhems1763413ma_yhems
mazers173917093ma__zers
menarches1646683menarche_s
mercer105214203merc_er_
mercery14397623merc_ery
merces105720743merc_e_s
mercies113817563mercie_s
mergers103813423mer_gers
miches134320733m_iche_s
mincers113714853minc_ers
mithers123516733m_ithers
mockers153812943m_ockers
moocher143610673moocher_
mooches143714453mooche_s
moshers124017843m_oshers
mothers123717623m_others
mouches143815963mouche_s
mouthers133811303mouthers
muches134718993m_uche_s
muckers153612803m_uckers
mulches143210673mulche_s
muncher143610373muncher_
munches144215793munche_s
murders103311363mur_ders
murther1237953murther_
mushers124016443m_ushers
mutches143314283mutche_s
naches114622413na_che_s
northers1139333northers
notchers13279423notchers
ochers113915303__ochers
oraches124216473orache_s
pacers105124543pa_c_ers
packers153818893pa_ckers
panthers13510783panthers
parachors1647403parachors
paraders113113113paraders
parcels113712663parc_els
parceners1337453parceners
parched154013693parche_d
parcheesi16233763parcheesi
parchesi15358213parchesi
parchesis16318213parchesis
pardners11269193pardners
parers85530743par__ers
parkers133816873par_kers
parriers103612903parriers
parsers94118153par_sers
partiers103514243partiers
partners102711133partners
partyers13277763partyers
patcher143515143patcher_
patches143320383patche_s
peachers153213843peachers
percher143313423percher_
perches143717953perche_s
pinchers153510613pinchers
pitchers153211483pitchers
poachers152910763poachers
porches143815673porche_s
punchers152610073punchers
racers84725433ra_c_ers
rachets124516833ra_chets
rackers134320453ra_ckers
rancher123013633rancher_
ranchero13277423ranchero
rancheros14255793rancheros
ranches123620113ranche_s
rashers104020913ra_shers
ratches123620463ratche_s
ratchets133110263ratchets
reachers133515723reachers
sachems14348903sa_chems
sachets123914103sa_chets
sackers133820223sa_ckers
satchels13328163satchels
saucers93712133sauc_ers
sauciers1076733sauciers
scorchers16145513scorchers
searcher13209103searcher_
searches132112903searche_s
smackers16318713sma_ckers
smashers13339593sma_shers
smirches1535993smirche_s
smoochers16184833smoochers
snatchers14146313snatchers
stanchers14206813stanchers
starches131912913starche_s
taches114224173ta_che_s
tackers134319623ta_ckers
tarriers83411713tarriers
tarsiers8298533tarsiers
teachers133212393teachers
thatchers1744583thatchers
tochers123413093_tochers
torchere1347683torchere
torcheres1446863torcheres
torches123715433torche_s
torchiers1445073torchiers
touchers133611213touchers
tracers94917843trac_ers
tracheas13410273tracheas
trackers143512853trackers
trashers113013643trashers
variers103712663var_iers
vouchers16418623vouchers
warblers13319103warblers
warders113416813war_ders
warmers124514293war_mers
warners103315563war_ners
warpers123413583war_pers
warslers11328073warslers
washers134517523wa_shers
watcher153113403watcher_
watches153017373watche_s
welchers16338053welchers
wenchers16319213wenchers
winchers16319223winchers
yachters1633883ya_chters
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.440406115.9
2DLD Change Limit1461623667.29620033.2
3Display Results3663660.1402614.3
 (SQL Overall)1786913667.87622688.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.