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

382 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
marching16431219(None) 
arching136216691_arching
matching163512391matching
parching164313051parching
aching126521972_a_ching
archine125817052_archine
archings14499862_archings
arcing95819642_arc_ing
arcking145811962_arcking
baching156017752ba_ching
batching163712092batching
birching16328462birching
caching156317502ca_ching
catching163712772catching
earthing12310322earthing
farcing133514002farc_ing
farthing1538072farthing
hatching173312212hatching
inarching1546342inarching
latching143712022latching
lurching14277332lurching
machine14313492ma_chine
macing114221552ma_c_ing
marbling13179882marbling
marchen143312072marchen_
marking144020132mar_king
marling103322762mar_ling
marring103319552mar_ring
marrying14157222marrying
marting103325012mar_ting
mashing134422242ma_shing
miching152911802m_iching
mooching16259062mooching
morphing1637552morphing
mouching163110582mouching
mulching16287102mulching
munching16299972munching
patching163212752patching
perching163711632perching
ranching141712042ranching
searching1538342searching
smirching1744392smirching
starching1538592starching
torching142510082torching
watching173011172watching
aahing1019015763_a_ahing
acing87429153_a_c_ing
acting95920983_a_cting
ahing98928353_a__hing
airthing12297953airthing
amercing1337193amerc_ing
arcading1239763_arcading
archil11611573_archi_l
archils12510533_archils
archines133815253_archines
archive154610483_archive
archiving1844763_archiving
archon11311753_archon_
archons12311583_archons
arcsine94512393_arcsine
argling92812733_argling
arguing9248733_arguing
arising83619973_arising
arming94719803_ar_ming
arshin9312173_arshin_
arshins10312573_arshins
ashing107824093_a_shing
backing165523443ba_cking
barbing123716993bar_bing
barchan1469133barchan_
barchans1588683barchans
barding113822893bar_ding
barfing134615093bar_fing
barging114018483bar_ging
baring95135853bar__ing
barking144724183bar_king
barning104320353bar_ning
barring104021593bar_ring
bashing135422583ba_shing
bathing134816243ba_thing
beaching164114143beaching
belching16349153belching
benching163411343benching
berthing14209593berthing
birthing14338433birthing
bitching163610623bitching
blanching17297093blanching
botching16359703botching
bracing123817613brac_ing
branching17289263branching
bunching163410703bunching
carding113922433car_ding
caring95137993car__ing
carking144322853car_king
carling103727063car_ling
caroling113317003caroling
caroming133312963caroming
carping123521083car_ping
carrying14148373carrying
carting104228283car_ting
carving133916773car_ving
cashing135022553ca_shing
churching2055083churching
cinching163310223cinching
circling1338423circling
coaching164011963coaching
couching163213263couching
cracking174013903cracking
cranching17278733cranching
crashing143512633crashing
dancing113611563danc_ing
daring84928683dar__ing
darking134217343dar_king
darkling1437483darkling
darling93418363dar_ling
darning93817333dar_ning
darting94020663dar_ting
dartling1039563dartling
dashing125917893da_shing
ditching15349943ditching
douching15349843douching
earing75235483ear__ing
earning83418213ear_ning
earring83519013ear_ring
earthling1346193earthling
eching126315563__eching
enriching1546153enriching
etching134511843_etching
facing125321573fa_c_ing
faithing1537153faithing
fancying1735353fancying
farding123716743far_ding
faring105231283far__ing
farming133515083far_ming
farthings1635233farthings
farting114120753far_ting
fashing144918793fa_shing
fetching17298413fetching
filching1736113filching
forcing134013753forc_ing
garaging1139043garaging
garbing113613273gar_bing
garbling12249453garbling
gargling11239203gargling
garoting10510703garoting
garring93116713gar_ring
gashing125119233ga_shing
girthing13256083girthing
gracing113216443grac_ing
graphing1538533graphing
hacking173720613ha_cking
haring104233003har__ing
harking154120943har_king
harming133717933har_ming
harping134118383har_ping
harrying15157643harrying
hashing145020163ha_shing
hatchings18225673hatchings
hatchling1844953hatchling
hitching173310523hitching
hotching17309313hotching
hunching17309113hunching
hutching17318643hutching
inching134414323_inching
itching134011683_itching
jacking214515263ja_cking
jarring153613193jar_ring
kachina1637663ka_china
karting123716063kar_ting
katchina1745333katchina
lacing94626233la_c_ing
lacking143821543la_cking
lancing103314123lanc_ing
larchen12479623larchen_
larding92917873lar_ding
larking123718253lar_king
lashing114422893la_shing
lathing114315693la_thing
laughing1335933laughing
launching1544783launching
leaching143012833leaching
leching134613653_leching
leeching14318373leeching
letching143810263letching
lunching143110003lunching
lynching17336083lynching
macchia1645893macchi_a
macchie1647193macchi_e
machined1637303ma_chined
machines15312893ma_chines
machining1746933ma_chining
mackling172710063mackling
maculing13219583maculing
madding123711993ma_dding
magicking19113543magicking
mailing102923343ma_iling
maiming122912723ma_iming
majoring1836363majoring
making134823853ma__king
malihini1344823malihini
malling103623663ma_lling
malting103219083ma_lting
mamboing1535973mamboing
manacling1446283manacling
managing1239093managing
mangling122312623mangling
manning103616383ma_nning
mantling112012613mantling
manuring1139223manuring
mapping143413993ma_pping
maraschino1752323maraschino
marauding1344983marauding
marblings14225543marblings
marcelling1545593marcelling
march125622893march___
marched153813403march_ed
marcher143912973march_er
marchers153710813marchers
marches143921173march_es
marchesa15346883marchesa
marchese15358913marchese
marchesi15337323marchesi
marchland1743833marchland
marchlike2044793marchlike
marchpane1843693marchpane
margin94016843mar_gin_
margining1337603margining
margins103815193mar_gins
marina84623413mar__ina
marine84230403mar__ine
marketing1636513marketing
markings153410243mar_kings
marlin84220903mar_lin_
marline93320953mar_line
marlings113713493mar_lings
marlins93420473mar_lins
marocain1247063marocain_
marocains1346353marocains
marooning1238593marooning
marrowing1546663marrowing
marshaling1645083marshaling
marshier1337593marshier
martin84122523mar_tin_
martini93613873mar_tini
martins93322063mar_tins
martyring1535783martyring
marveling1537103marveling
masking145116613ma_sking
masoning1139763masoning
massing104318023ma_ssing
masting104325823ma_sting
mating94832913ma__ting
matting103620143ma_tting
maturing1139953maturing
mauling103315683ma_uling
mawing124020803ma__wing
maxing164817073ma__xing
maying124421153ma__ying
mazing184418973ma__zing
merchant1548803merchant
merging112711763mer_ging
meriting11314683meriting
meshing134513813m_eshing
milchig1543653milchi_g
mincing123314333minc_ing
miring93723803mir__ing
miscuing1338733miscuing
mocking163614453m_ocking
morning103215043mor_ning
morphin1439003morphin_
morphine1548703morphine
morphings1744683morphings
morphins1538653morphins
moshing134214883m_oshing
mouthing142810243mouthing
mucking163213823m_ucking
mulcting13246983mulcting
muring95120373mur__ing
murrhine1344313murrhine
muscling1337853muscling
mushing134217633m_ushing
naething1236073naething
narcein936293narcein_
narceine1046753narceine
narceins1036413narceins
narking124015383nar_king
niching133612433_niching
northing12199063northing
notching14288583notching
oaring74225303oar__ing
ouching134314903_ouching
outmarching1943603outmarching
pacing114522753pa_c_ing
packing164420723pa_cking
parading12313863parading
parawing14310583parawing
parceling1438443parceling
parchisi15368933parchisi
parging113318603par_ging
paring94236493par__ing
parking143423043par_king
parling103823763par_ling
paroling113316213paroling
parring103222063par_ring
parrying14168133parrying
parsing103819553par_sing
parting103527383par_ting
partying14168893partying
pashing135120513pa_shing
peaching163613643peaching
peching154513903_peching
pinching163711053pinching
pitching163411113pitching
poaching163510833poaching
pooching16328983pooching
pouching163210413pouching
psyching1934483psyching
punching163310123punching
racing95030533ra_c_ing
racking144323663ra_cking
ralphing1435413ralphing
raring74332873rar__ing
reaching143317203reaching
rematching1844913rematching
retching143412173retching
roaching143210433roaching
ruching133612933_ruching
sacking144122703sa_cking
sacring103115983sa_cring
sarcina9310733sarc_ina
sashing114621473sa_shing
saucing10311003sauc_ing
scarphing1735243scarphing
scorching1735633scorching
smacking173510763sma_cking
smarting113212453smar_ting
smashing143310243sma_shing
smooching1734883smooching
smutching1734853smutching
snatching1536363snatching
stanching1538083stanching
synching17227713synching
tacking144421483ta_cking
talcing103111633talc_ing
talcking1567083talcking
taring73932283tar__ing
tarring83318303tar_ring
tarrying12146723tarrying
tarting84222653tar_ting
teaching143612603teaching
thatching1835143thatching
touching143211343touching
trachling1537823trachling
tracing103720153trac_ing
tracking153715463tracking
trashing122613223trashing
urchin1138743_urchin_
urchins1238863_urchins
varying1429723var_ying
vouching17308233vouching
warbling14198943warbling
warding123918143war_ding
waring105029443war__ing
warking153519573war_king
warming133515083war_ming
warning113717093war_ning
warping133715183war_ping
warring113717973war_ring
warsling12198593warsling
washing145119283wa_shing
wauchting1843473wauchting
welching17287363welching
wenching17328863wenching
winching17359903winching
witching173410633witching
worthing15178053worthing
wracking18349963wracking
wrathing15248923wrathing
yachting1734933ya_chting
yacking174315683ya_cking
yarding123413143yar_ding
yarning113512953yar_ning

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.1531167915.0
2DLD Change Limit1461623827.65619091.2
3Display Results3823820.1562448.7
 (SQL Overall)1786913827.96522434.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.