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

517 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
marched15381340(None) 
arched125717321_arched
marchen143312071marchen
marcher143912971marcher
marches143921171marches
matched153513961matched
parched154013691parched
ached119227832_a_ched
arced88224162_arc_ed
archer115016242_archer
arches114822042_arches
arcked136211942_arcked
bached145519892ba_ched
batched154114242batched
birched15349912birched
cached145419202ca_ched
earthed1139922earthed
farced125216532farc_ed
hatched163414462hatched
inarched1486112inarched
larchen12479622larchen
larches124416442larches
latched133914062latched
lurched13358032lurched
maced108528692ma_c_ed
mache125925302ma_che_
maches134827232ma_ches
macled116718112ma_cled
manche133515102manche_
manches143818622manches
manchet143317772manchet
marbled123212112marbled
marcel103714852marc_el
march125622892march__
marchers153710812marchers
marchesa15346882marchesa
marchese15358912marchese
marchesi15337322marchesi
marked133921622mar_ked
marled95523162mar_led
marred95421042mar_red
married104715302married
marshes123615372marshes
marted94425212mar_ted
mashed125325042ma_shed
matcher143214282matcher
matches143219782matches
merches144013762merches
miched143913392m_iched
mooched153910532mooched
morphed1537132morphed
mouched153612592mouched
mulched15307762mulched
munched153411072munched
parches143720002parches
patched153514622patched
perched154713242perched
ranched133113602ranched
searched14209252searched
smirched1634672smirched
starched14199312starched
torched133511352torched
unarched14128552unarched
watched163012822watched
aahed917816443_a_ahed
aced79540883_a_c_ed
ache96829823_a_che_
aches106132293_a_ches
acned87520673_a_cned
acred87126353_a_cred
acted88521733_a_cted
ahed89536253_a__hed
airshed11258533airshed
airthed11328303airthed
amerced1256523amerc_ed
arcade91013643_arcade
arcaded1178973_arcaded
arch98628443_arch__
archaea12137613_archaea
archean1269123_archean
archers124414573_archers
archery15478063_archery
archil11611573_archil
archived17355993_archived
archly1437353_archly
archon11311753_archon
argled85314553_argled
argued84311173_argued
ariled75620323_ariled
armed86324433_ar_med
ashed97829773_a_shed
baches135426943ba_ches
backed155725723ba_cked
barbed115121313bar_bed
barchan1469133barchan
barded105426423bar_ded
bared85144483bar__ed
barehead1446603barehead
barfed125416383bar_fed
barged105822643bar_ged
barked135027313bar_ked
barned95623583bar_ned
barred95725793bar_red
bashed126225703ba_shed
batcher144414853batcher
batches144019613batches
bathed125518743ba_thed
beached154516553beached
belched154011843belched
benched154713943benched
berthed13259123berthed
birchen14347883birchen
birches143412323birches
birthed13228593birthed
bitched153212923bitched
blanched16308603blanched
botched153611903botched
braced115420603brac_ed
braches144621223braches
brachet144020313brachet
bracted12410933bracted
branched163210453branched
bunched154312413bunched
caboched1844043caboched
cache125122483ca_che_
caches137926913ca_ches
cachet134526413ca_chet
capuched1843743capuched
carcel105018673carc_el
carded105424903car_ded
cared86050093car__ed
caried94528693car_ied
carked134024823car_ked
caroche1469243caroche_
caroches15710693caroches
caroled103717693caroled
caromed123713623caromed
carped115923763car_ped
carried103717153carried
carted98631443car_ted
carved124320853car_ved
cashed125124353ca_shed
catcher143115823catcher
catches144320773catches
churched1934653churched
cinched153910863cinched
circled1237583circled
cliched153711023cliched
coached153313843coached
couched154115793couched
cracked163514743cracked
cranched163210413cranched
crashed134214203crashed
curches143512743curches
danced105315253danc_ed
dared75935013dar__ed
darked123919633dar_ked
darkled13378723darkled
darned85018483dar_ned
darted84620923dar_ted
dartled9409853dartled
dashed115920563da_shed
demarche1645533demarche_
demarches1745913demarches
ditched143711903ditched
douched144012113douched
earache1239323earache_
earaches13411303earaches
eared65139503ear__ed
earned74818333ear_ned
earthen1039253earthen
eched116919223__eched
enriched1435863enriched
etched123613703_etched
faced117727653fa_c_ed
faithed1437163faithed
fancied133310603fancied
farce104925323farc_e_
farcer115016083farc_er
farces115223323farc_es
farcie114816473farcie_
farcies125317883farcies
farded114518953far_ded
fared95842343far__ed
farmed125117653far_med
farted105121783far_ted
farther1348343farther
fashed136720253fa_shed
fetched163710473fetched
filched16307423filched
forced126316523forc_ed
fracted1339373fracted
garaged1039253garaged
garbed104815663gar_bed
garbled114512803garbled
gargled104210673gargled
garoted9710133garoted
garred85217403gar_red
gashed116321973ga_shed
gauche1238553gauche_
gaucher1337233gaucher
girthed12266243girthed
graced105217903grac_ed
graphed1498473graphed
hacked164923513ha_cked
hardhead1645883hardhead
hared95742183har__ed
harked145422553har_ked
harmed125218833har_med
harped124418403har_ped
harried113815533harried
harshen1339283harshen
harsher13310363harsher
hashed136021943ha_shed
hatchel153510753hatchel
hatcher153314723hatcher
hatches153420273hatches
hatchet153317563hatchet
haunched1744813haunched
hitched163312253hitched
hotched163610923hotched
hunched163710493hunched
hutched16359883hutched
inarches1358043inarches
inched124514483_inched
itched123812023_itched
jacked204817523ja_cked
jarhead1835173jar_head
jarred144613253jar_red
laced87132643la_c_ed
laches116528343la_ches
lacked135324653la_cked
lanced93717723lanc_ed
larch105919793larch__
larded84319093lar_ded
larked114519473lar_ked
lashed105625213la_shed
latches123320123latches
latchet123117903latchet
lathed104718453la_thed
laughed1235893laughed
launched1475403launched
leached133715043leached
leched123716003_leched
leeched13369503leeched
letched133912053letched
lunched133911823lunched
lurcher12338133lurcher
lurches123311663lurches
lynched16376753lynched
macchia1645893macchia
macchie1647193macchie
mace87345793ma_c_e_
macer912126943ma_c_er
maces97139963ma_c_es
mach116134483ma_ch__
machete14310883ma_chete
machined1637303ma_chined
macho126120153ma_ch_o
machos135217493ma_chos
machree1438513ma_chree
machs125722563ma_ch_s
mackled164111923mackled
macle96127003ma_cle_
macles107023223ma_cles
maculed123510053maculed
madded113513553ma_dded
magicked1842963magicked
maihem1366213ma_ihem
mailed95326753ma_iled
maimed114812663ma_imed
majored1735853majored
malfed12369763ma_lfed
malled94626113ma_lled
malted94819863ma_lted
mamboed14417623mamboed
manacled1336453manacled
managed113212603managed
manchets15269573manchets
maned86634103ma__ned
mangled113615263mangled
manned94418643ma_nned
mantled104113393mantled
manured1039473manured
mapped134015883ma_pped
maraud938943mar_aud
marauded1244333marauded
maravedi1442803maravedi
marble104219103marble_
marbler113511673marbler
marbles114516653marbles
marc87034633marc___
marcato1139743marcato
marcelled1445203marcelled
marcels113212373marcels
marching164312193marching
marchland1743833marchland
marcs95726623marc__s
mare64759333mar__e_
mares76457633mar__es
marge85328333mar_ge_
marges94525713mar_ges
margined1237743margined
marine84230403marine_
mariner93315993mariner
marines93928013marines
marishes13512553marishes
marker124420393mar_ker
market123226043mar_ket
marketed1537323marketed
markhor1635463markhor
marlier92614773marlier
marooned1138563marooned
marque172410503marque_
marquee18218583marquee
marques182610863marques
marrer83716673mar_rer
marrieds11288073marrieds
marrier93817523marrier
marries93825283marries
marrowed1445973marrowed
marse76231153mar_se_
marses84827113mar_ses
marsh105320853marsh__
marshal1238973marshal
marshaled1544643marshaled
marshier1337593marshier
marshy14558333marsh_y
marten84518263mar_ten
martlet93419153martlet
martyred1434283martyred
marvel113712003mar_vel
marveled1436433marveled
masher114123203ma_sher
mashes115030003ma_shes
masked134316523ma_sked
masoned1039803masoned
massed94421323ma_ssed
masted94025803ma_sted
masthead1435883masthead
match125621103match__
matchers153012433matchers
matchup1643513matchup
mated85537783ma__ted
matted94521413ma_tted
matured10310033matured
mauled94817823ma_uled
mawed115824743ma__wed
maxed155821193ma__xed
mayed115522403ma__yed
mayhem1644923ma_yhem
mayweed1634163mayweed
mazed175523873ma__zed
menarche1545813menarche_
menarches1646683menarches
mercer105214203merc_er
merces105720743merc_es
merch125417963merch__
mercies113817563mercies
merged104214953mer_ged
merited10313853merited
meshed124415933m_eshed
miche126219243m_iche_
miches134320733m_iches
minced114114913minc_ed
mired85729223mir__ed
miscued1239293miscued
mocked154716613m_ocked
moocher143610673moocher
mooches143714453mooches
moshed124517493m_oshed
mouches143815963mouches
mouthed133811043mouthed
muches134718993m_uches
mucked153816093m_ucked
mulches143210673mulches
mulcted12296693mulcted
muncher143610373muncher
munches144215793munches
muraled10410833muraled
mured85726703mur__ed
murther1237953murther
muscled1237783muscled
mushed124420843m_ushed
mutches143314283mutches
naches114622413na_ches
nacred95212493na_cred
narked114116743nar_ked
narthex1734263narthex
niched125514063_niched
notched134210303notched
oared65030653oar__ed
orache114013593orache_
oraches124216473oraches
orchid1289573_orchid
ouched124316933_ouched
outmarched1843583outmarched
paced106931683pa_c_ed
packed154822603pa_cked
paraded114014263paraded
parcel103915473parc_el
parceled1338343parceled
parch125123003parch__
parchesi15358213parchesi
pared86946763par__ed
parged104922043par_ged
parked134425143par_ked
parled94626293par_led
paroled104217633paroled
parred95024073par_red
parried103615723parried
parsed96323893par_sed
parted94228683par_ted
partied103516553partied
pashed125923143pa_shed
patcher143515143patcher
patches143320383patches
paunched1645523paunched
peached154315883peached
peched144915343_peched
percher143313423percher
perches143717953perches
pinched153812453pinched
pitched153512923pitched
poached154212403poached
pooched152810083pooched
porches143815673porches
pouched153612773pouched
psyched1843913psyched
punched153512173punched
raced87635313ra_c_ed
rachet115028973ra_chet
racked134526083ra_cked
ralphed1334363ralphed
rancher123013633rancher
ranches123620113ranches
rared65738323rar__ed
ratches123620463ratches
ratchet124218333ratchet
reached134619083reached
rematched1745223rematched
retched133814273retched
roached133211833roached
ruched124314633_ruched
sachem134012223sa_chem
sachet114725773sa_chet
sacked135525213sa_cked
sacred94917103sa_cred
sarcoid10310453sarcoid
sashed105622943sa_shed
satchel123310303satchel
sauced93913303sauc_ed
scarphed1635443scarphed
scorched16187193scorched
searcher13209103searcher
searches132112903searches
smacked163710993sma_cked
smarted105012613smar_ted
smashed133711223sma_shed
smirches1535993smirches
smooched16185983smooched
smutched16165923smutched
snatched14157633snatched
stanched14208903stanched
starches131912913starches
synched16277213synched
tache106222373ta_che_
taches114224173ta_ches
tacked134723943ta_cked
talced93811003talc_ed
talcked1446343talcked
tared69340053tar__ed
tarred74720283tar_red
tarried83914133tarried
tarted74923373tar_ted
tarweed1137343tarweed
teched124014433_teched
tetched133010773tetched
thatched1735433thatched
torches123715433torches
touched134914963touched
traced94821583trac_ed
trachea12311673trachea
tracheid1437583tracheid
trachled1438313trachled
tracked143716133tracked
trashed113514703trashed
unmatched1744203unmatched
varied104817863var_ied
varved134110603var_ved
vouched163910563vouched
warbled133212163warbled
warded115021043war_ded
wared96339873war__ed
warhead1436603war_head
warked144421213war_ked
warmed124516893war_med
warned104018913war_ned
warped124816413war_ped
warred104019843war_red
warsled112910443warsled
warted104223233war_ted
washed135521503wa_shed
watcher153113403watcher
watches153017373watches
wauchted1753373wauchted
welched16298833welched
wenched163910913wenched
winched163110593winched
witched163012193witched
worthed1437873worthed
wracked174110113wracked
wrathed14298523wrathed
yachted1634853ya_chted
yacked164516793ya_cked
yarded114714023yar_ded
yarned105514023yar_ned

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 Limit1340275176.72019944.5
3Display Results5175170.1703041.2
 (SQL Overall)1786915177.28024545.5
 
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.