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

486 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
notches12351365(None) 
botches143716021botches
hotches153814361hotches
notched134210301notched
notcher123610931notcher
notchers13279421notchers
rotches123515701rotches
aitches123014362aitches
batches144019612batches
bitches144117062bitches
blotches1537432blotches
boches134618522bo_ches
botched153611902botched
botcher143613222botcher
botchers153511542botchers
butches144315362butches
catches144320772catches
coaches144018692coaches
conches144019812conches
cooches143515832cooches
couches144020472couches
crotches153411302crotches
cutches143216462cutches
ditches133215712ditches
douches134315232douches
etches114217762_etches
fetches153413892fetches
fitches153516192fitches
gotchas1334612gotchas
hatches153420272hatches
hitches153616272hitches
hooches153812522hooches
hootches1656972hootches
hotched163610922hotched
hutches153613522hutches
itches114916212_itches
ketches164012192ketches
latches123320122latches
letches124015482letches
loaches123613982loaches
matches143219782matches
mooches143714452mooches
mouches143815962mouches
mutches143314282mutches
naches114622412n_aches
nautches1336082nautches
niches114419142n_iches
nitchies1339072nitchies
nonces84418832nonc_es
noshes96618232no_shes
notates72817482notates
notch105613322notch__
notes55034582not__es
nother93815962not_her
notices9312282notices
ouches114322182_ouches
patches143320382patches
pitches143617752pitches
poaches144416942poaches
pooches143214162pooches
porches143815672porches
potiches1539202potiches
pouches144116742pouches
ratches123620462ratches
retches123318512retches
roaches123616212roaches
rotche114311982rotche_
rouches124217892rouches
scotches15179472scotches
snatches131410712snatches
snitches13148982snitches
torches123715432torches
touches125118342touches
vetches153411262vetches
vouches153914112vouches
watches153017372watches
witches152715792witches
aches106132293__aches
another10289153anot_her
apaches143411833apaches
arches114822043_arches
attaches13137723attaches
avouches1634823avouches
baches135426943_baches
batched154114243batched
batcher144414853batcher
batchers153613273batchers
bathes116524833bat_hes
beaches144120653beaches
beeches143413883beeches
belches143514343belches
benches143918603benches
birches143412323birches
bitched153212923bitched
bitchen14349733bitchen
blotched1635653blotched
bobeches1744483bobeches
bocces123912023bo_cces
boccies133311513boccies
boche124216953bo_che_
borsches1536003borsches
boshes114721883bo_shes
botch126717453botch__
botchery18366763botchery
botchier15287143botchier
botchiest1636153botchiest
botchy16537823botch_y
bother115218063bot_her
bothers124317753bot_hers
bothies12414783bothies
bottles94216273bottles
bouchee143313543bouchee
bouchees15339533bouchees
boucles113113003boucles
braches144621223braches
britches15278683britches
broaches153211623broaches
brooches15288193brooches
bunches144116033bunches
butcher143411163butcher
butchers153710183butchers
caches137926913_caches
catcher143115823catcher
catchers153114063catchers
cinches144215773cinches
cliches144213743cliches
cloches144113713cloches
clothes124513813clot_hes
clutches15307923clutches
coached153313843coached
coacher143714123coacher
coachers154312303coachers
conchas144013313conchas
conchies153214853conchies
conchos144313963conchos
conchs134714903conch_s
coshes115022783co_shes
cotes76347843cot__es
cotypes1437943cotypes
couched154115793couched
coucher144515853coucher
couchers153513863couchers
cratches153012543cratches
creches14313093creches
crotched16428593crotched
crotchet152711993crotchet
crotchets16396303crotchets
crouches153711293crouches
crutches15359593crutches
culches143710743culches
cultches15316533cultches
curches143512743curches
datchas1347423datchas
detaches1439653detaches
ditched143711903ditched
ditcher134012003ditcher
ditchers143610363ditchers
dotages92311793dotages
dotes65836693dot__es
dottles83912283dottles
douche124613223douche_
douched144012113douched
dunches133312583dunches
eches106322163__eches
enriches1337263enriches
etched123613703_etched
etcher113912943_etcher
etchers123411293_etchers
fetched163710473fetched
fetcher153510393fetcher
fetchers16328863fetchers
fetiches1636953fetiches
fiches145219533_fiches
filches153410723filches
finches153914193finches
fitchee152710783fitchee
fitchet153113563fitchet
fitchets16307413fitchets
fitchew18276803fitchew
fitchews19274773fitchews
fleches153411443fleches
fletches16308853fletches
flitches16388463flitches
forces114422133forc_es
glitches14296653glitches
gotcha1234633gotch_a
goths96513003got_h_s
gouaches1436193gouaches
grouches14328213grouches
grutches14285853grutches
gulches13398103gulches
hatched163414463hatched
hatchel153510753hatchel
hatchels16368673hatchels
hatcher153314723hatcher
hatchers163113173hatchers
hatchet153317563hatchet
hatchets163310383hatchets
hitched163312253hitched
hitcher153712003hitcher
hitchers16379993hitchers
honchos15369573honchos
hoochies1639603hoochies
hotcakes1744703hotcakes
hotch136214723hotch__
hotties103016953hotties
hunches153913463hunches
hutched16359883hutched
inarches1358043inarches
inches114419673_inches
itched123812023_itched
joshes165114853jo_shes
kenches163912273kenches
kitchen16287683kitchen
kitchens17195783kitchens
kithes135016653kit_hes
kitsches1734073kitsches
klatches17157133klatches
kvetches2053583kvetches
kythes16499133kyt_hes
laches116528343_laches
larches124416443larches
latched133914063latched
latchet123117903latchet
latchets133410013latchets
lathes95127493lat_hes
leaches123319343leaches
leches115421313_leches
leeches123911933leeches
letched133912053letched
lethes94818083let_hes
liches114724293_liches
litchis1238373litchis
loathes103513243loathes
lochs106715513lo_ch_s
locoes85516583lo_coes
lotahs9479873lotah_s
lotoses73713643lotoses
lottes65322753lot_tes
lotuses74011253lotuses
louche115212663louche_
lunches124115443lunches
lurches123311663lurches
lyches144213613_lyches
lynches15378873lynches
maches134827233_maches
manches143818623manches
marches143921173marches
matched153513963matched
matcher143214283matcher
matchers153012433matchers
merches144013763merches
miches134320733_miches
mochas13310663mo_chas
mooched153910533mooched
moocher143610673moocher
moochers15369123moochers
moshes115222873mo_shes
motes75944003mot__es
mother113718643mot_her
mothers123717623mot_hers
moths106021553mot_h_s
motiles93317433motiles
motives123611893motives
mottes85523693mot_tes
mottles93415803mottles
mottoes93412193mottoes
mouched153612593mouched
muches134718993_muches
mulches143210673mulches
munches144215793munches
nachas114914193n_achas
nachos115014183n_achos
nacres85614453n_acres
nances83618643nanc_es
nancies93516843nancies
natch105018223natch__
nates55238333nat__es
natives10310823natives
natures7311963natures
neotypes1344523neotypes
nether94014163net_her
nettles73214083nettles
niche105016793n_iche_
niched125514063n_iched
nieces84112713niec_es
nitchie1247233nitchie
nites55736343nit__es
nitres65519333nit_res
nobbles114014523nobbles
nobles83319723no_bles
nocked134617383no_cked
nocks115121013no_c_ks
noctules1036583noctules
noddies93512043noddies
noddles92911293noddles
nodes64633493no__des
nodules8269703nodules
noes45845393no___es
noises65021853no_ises
nombles113212343nombles
nomes74933123no__mes
nonages8313843nonages
nonce75719823nonc_e_
noncoms1139203noncoms
nones55639133no__nes
nonsuches1444493nonsuches
nontaxes1537853nontaxes
nonuses73313863nonuses
noodges9317703noodges
noodles83513193noodles
noogies82814583noogies
nookies113414963nookies
nooses65623643no_oses
nopales93812523nopales
norites74018803norites
norther1039733norther
northers1139333northers
norths96812323north_s
noses55435643no__ses
noshed104413503no_shed
nosher94616363no_sher
noshers103614333no_shers
notables10178243notables
notaries8314933notaries
notate63217863notate_
notated82713663notated
notching14288583notching
note46239963not__e_
notecase1044823notecase
notecases1145173notecases
noted65123843not__ed
noteless839403noteless
noter55025643not__er
noters64021003not_ers
notice8313443notice_
noticed1037863noticed
noticer937273noticer
noticers1035693noticers
notifies11310423notifies
notions74014483notions
noughts11478083noughts
nouses64627163no_uses
novices1238223novices
noyades1136563noyades
nozzles15276303nozzles
nudzhes2032523nudzhes
nuncles939843nuncles
nutates73214973nutates
nutcase975763nutcase
nutcases1085793nutcases
ocher104516103_o_cher
ochers113915303_o_chers
ochres113510833_o_chres
oraches124216473oraches
orchis11710773_orchis
other84219103_ot_her
others93918003_ot_hers
ouched124316933_ouched
ouphes113614633_ouphes
panoches1548123pano_ches
parches143720003parches
patched153514623patched
patcher143515143patcher
patchers153413303patchers
peaches144120053peaches
penoches1538933peno_ches
perches143717953perches
pinches144117933pinches
pitched153512923pitched
pitcher143813713pitcher
pitchers153211483pitchers
poached154212403poached
poacher143912323poacher
poachers152910763poachers
ponces104720843ponc_es
ponchos143410703ponchos
pooched152810083pooched
postiches1648223postiches
potages102416423potages
potashes1337833potashes
pother113818853pot_her
pothers123818623pot_hers
pothos114214693pot_hos
potiche1438043potiche_
potlaches16115263potlaches
potpies113116173potpies
potsies93019483potsies
potties93723543potties
pottles93816983pottles
pouched153612773pouched
psyches1755803psyches
punches144816133punches
putsches1535313putsches
quiches2139333quiches
quitches2236193quitches
ranches123620113ranches
ratchet124218333ratchet
ratchets133110263ratchets
reaches123423203reaches
retched133814273retched
riches115022083_riches
roached133211833roached
rochet115423003ro_chet
rochets124213473ro_chets
roscoes9310923roscoes
rotates72819773rotates
rotch105815933rotch__
rotes56143903rot__es
rottes64524833rot_tes
rouche114714313rouche_
ruches114819583_ruches
satchel123310303satchel
satchels13328163satchels
scooches15188413scooches
scootches1635003scootches
scorches15189143scorches
scotched16187933scotched
scutches15168883scutches
seiches12513813seiches
sketches1746823sketches
slatches131511523slatches
slouches13208073slouches
smooches15217263smooches
smutches15177273smutches
snatched14157633snatched
snatcher13167763snatcher
snatchers14146313snatchers
snathes104816493snat_hes
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
socles8418453so_cles
soothes103917103soothes
soroches1338803soroches
soths86218623sot_h_s
soutaches1446443soutaches
splotches1643913splotches
stitches131410593stitches
swatches16169963swatches
switches16159133switches
taches114224173_taches
teaches122718353teaches
tenches123515523tenches
tetched133010773tetched
thatches1637513thatches
tithes94720213tit_hes
tocher114014913to_cher
tochers123413093to_chers
tophes115218423to_phes
torched133511353torched
toshes94520103to_shes
totes55139683tot__es
tother94117143tot_her
touche114916173touche_
touched134914963touched
toucher124814353toucher
touchers133611213touchers
troches123715343troches
tusches1237903tusches
twitches16156373twitches
tythes12419703tyt_hes
unhitches1743073unhitches
unlatches1444293unlatches
voces105918053vo_c_es
voices114414013voic_es
votes84627083vot__es
votives13337953votives
vouched163910563vouched
vouchee153411263vouchee
vouchees16337483vouchees
voucher154110263voucher
vouchers16418623vouchers
watched163012823watched
watcher153113403watcher
watchers163511793watchers
welches153710313welches
wenches152914133wenches
wiches144418753_wiches
winches154714373winches
witched163012193witched
withes124620843wit_hes
wooshes13169883wooshes
wretches16257283wretches
wyches17387913_wyches
zilches21326303zilches

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.1401276364.3
2DLD Change Limit1340274867.03319056.9
3Display Results4864860.1702858.8
 (SQL Overall)1786914867.34324334.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.