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

380 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
watchers16351179(None) 
batchers153613271batchers
catchers153114061catchers
hatchers163113171hatchers
matchers153012431matchers
patchers153413301patchers
watcher153113401watcher_
watches153017371watche_s
archers124414572_archers
batcher144414852batcher_
batches144019612batche_s
bathers124720362bat_hers
botchers153511542botchers
butchers153710182butchers
catcher143115822catcher_
catches144320772catche_s
ditchers143610362ditchers
etchers123411292_etchers
fathers133916502fat_hers
fetchers16328862fetchers
gathers114315072gat_hers
hatchels16368672hatchels
hatcher153314722hatcher_
hatchery19326382hatchery
hatches153420272hatche_s
hatchets163310382hatchets
hitchers16379992hitchers
latches123320122latche_s
latchets133410012latchets
lathers104321882lat_hers
marchers153710812marchers
matcher143214282matcher_
matches143219782matche_s
notchers13279422notchers
patcher143515142patcher_
patches143320382patche_s
pitchers153211482pitchers
ranchers133311792ranchers
ratches123620462ratche_s
ratchets133110262ratchets
satchels13328162satchels
snatchers14146312snatchers
swatches16169962swatche_s
swathers144512082swat_hers
switchers17146632switchers
thatchers1744582thatchers
twitchers17134532twitchers
washers134517522wa_shers
watchcry2142362watchcry
watched163012822watche_d
watcheye19104272watcheye
watcheyes20103742watcheyes
waterers112312782waterers
waters95030632wat__ers
weathers143412832weat_hers
welchers16338052welchers
wenchers16319212wenchers
wethers135214692wet_hers
winchers16319222winchers
witchery19236092witchery
witches152715792witche_s
withers134417752wit_hers
wuthers133711522wut_hers
aches106132293_a_che_s
aethers103614943_aethers
aitches123014363aitche_s
anchors123912953_anchors
anthers103715203_anthers
archer115016243_archer_
archery15478063_archery
arches114822043_arche_s
atoners75013953_atoners
attachers14134883attachers
baches135426943ba_che_s
backers153821883ba_ckers
bashers124820833ba_shers
batched154114243batche_d
bather115322513bat_her_
bathes116524833bat_he_s
batters94626013bat_ters
battlers104110973battlers
belchers153510023belchers
benchers153611013benchers
bewitchers2042563bewitchers
bitchery18236563bitchery
bitches144117063bitche_s
blanchers16307433blanchers
blathers134713793blat_hers
bluchers15359033bluchers
botcher143613223botcher_
botchery18366763botchery
botches143716023botche_s
bothers124317753bot_hers
butcher143411163butcher_
butchery18326253butchery
butches144315363butche_s
caches137926913ca_che_s
cachets145014263ca_chets
cancers114018583canc_ers
catchier15329863catchier_
catchups1744383catchups
caterers102814403caterers
caters85336503cat__ers
cithers124315773cit_hers
coachers154312303coachers
couchers153513863couchers
cowcatchers2051563cowcatchers
cratches153012543cratche_s
cutchery18265173cutchery
cutches143216463cutche_s
dackers143417043da_ckers
dancers103413093danc_ers
dashers115016863da_shers
datchas1347423datch_as
daters74827373dat__ers
detachers1536483detachers
ditcher134012003ditcher_
ditches133215713ditche_s
dithers114016153dit_hers
dowitchers1942133dowitchers
eaters65535953eat__ers
etcher113912943_etcher_
etches114217763_etche_s
ethers94518413_et_hers
facers115519443fa_c_ers
fanciers13358083fanciers
farcers124713443farc_ers
father125116713fat_her_
feathers143513243feat_hers
fetcher153510393fetcher_
fetches153413893fetche_s
filchers16286863filchers
fitches153516193fitche_s
fitchets16307413fitchets
fitchews19274773fitchews
fletchers17335533fletchers
gaters74728643gat__ers
gather104115853gat_her_
gaucher1337233gaucher_
hackers164619043ha_ckers
hatcheck2244013hatcheck
hatchecks2343593hatchecks
hatched163414463hatche_d
hatchel153510753hatche_l
hatcheries1846523hatcheries
hatchet153317563hatche_t
haters94930403hat__ers
hatters104221523hat_ters
heathers143914733heat_hers
hitcher153712003hitcher_
hitches153616273hitche_s
hotches153814363hotche_s
hutches153613523hutche_s
inchers123912523_inchers
itches114916213_itche_s
jackers204214453ja_ckers
kashers143914023ka_shers
ketches164012193ketche_s
kitchens17195783kitchens
klatches17157133klatche_s
kvetchers2142373kvetchers
lacers85225253la_c_ers
laches116528343la_che_s
lackers134120543la_ckers
lancers93616643lanc_ers
lanciers10308543lanciers
larches124416443larche_s
lashers104121833la_shers
latched133914063latche_d
latchet123117903latche_t
latchkeys2141873latchkeys
lather95124353lat_her_
lathery133911123lat_hery
lathes95127493lat_he_s
laughers1235923laughers
launchers1454333launchers
leachers133712813leachers
leathers114215083leat_hers
lechers123313963_lechers
letches124015483letche_s
loathers113310443loat_hers
lunchers13349563lunchers
lurchers13307153lurchers
lynchers16285453lynchers
macers105321273ma_c_ers
maches134827233ma_che_s
manches143818623manche_s
manchets15269573manchets
marcher143912973marcher_
marches143921173marche_s
mashers124621053ma_shers
matched153513963matche_d
matchless1644683matchless
matchups1743073matchups
maters85032393mat__ers
matters94421753mat_ters
maturers1037373maturers
mithers123516733mit_hers
moochers15369123moochers
mothers123717623mot_hers
munchers15318773munchers
mutches143314283mutche_s
naches114622413na_che_s
natters73718063nat_ters
nautches1336083nautche_s
notcher123610933notcher_
notches123513653notche_s
oaters65029793oat__ers
ochers113915303__ochers
others93918003_ot_hers
pacers105124543pa_c_ers
packers153818893pa_ckers
panthers13510783panthers
parches143720003parche_s
patched153514623patche_d
patchier15319663patchier_
paters84935833pat__ers
patters94825193pat_ters
patzers184210573pat_zers
peachers153213843peachers
perchers153611523perchers
pinchers153510613pinchers
pitcher143813713pitcher_
pitches143617753pitche_s
poachers152910763poachers
pothers123818623pot_hers
punchers152610073punchers
racers84725433ra_c_ers
rachets124516833ra_chets
rackers134320453ra_ckers
rancher123013633rancher_
ranchero13277423ranchero
rancheros14255793rancheros
ranches123620113ranche_s
rashers104020913ra_shers
ratchet124218333ratche_t
raters63936583rat__ers
rather94319743rat_her_
ratters74422473rat_ters
rattlers83510293rattlers
reachers133515723reachers
retches123318513retche_s
rotches123515703rotche_s
sachems14348903sa_chems
sachets123914103sa_chets
sackers133820223sa_ckers
satchel123310303satche_l
saucers93712133sauc_ers
sauciers1076733sauciers
scratchers1744293scratchers
scutchers16175643scutchers
searchers14197353searchers
sketchers1834513sketchers
slatches131511523slatche_s
slathers113914783slat_hers
snatcher13167763snatcher_
snatches131410713snatche_s
snitchers14166043snitchers
stackers143413563stackers
stanchers14206813stanchers
stitchers14147013stitchers
swashers14389533swa_shers
swather134213603swat_her_
swathes134115513swat_he_s
swatters113911793swat_ters
switcher16177683switcher_
switches16159133switche_s
swithers144310533swit_hers
taches114224173ta_che_s
tackers134319623ta_ckers
taters64932203tat__ers
tatters74520483tat_ters
tattlers8369693tattlers
teachers133212393teachers
tethers103815313tet_hers
thatcher1635663thatcher_
thatches1637513thatche_s
tithers104216733tit_hers
tochers123413093_tochers
touchers133611213touchers
twitcher16135343twitcher_
twitches16156373twitche_s
vetches153411263vetche_s
vouchers16418623vouchers
wabblers15398993wabblers
wacker154920123wa_cker_
wackes154717713wa_cke_s
wadders123812443wa_dders
waddlers13298333waddlers
waders109120643wa__ders
wafers124316143wa__fers
wafflers17306323wafflers
wafters134112813wa_fters
wagerers12247613wagerers
wagers105122203wa__gers
waggers124613083wa_ggers
wagoners1235473wagoners
wailers103916803wa_ilers
waisters113811523waisters
waiters104218623wa_iters
waivers133410053wa_ivers
wakeners1535843wakeners
wakers134822493wa__kers
walers94824463wa__lers
walkers143411473wa_lkers
waltzers2034003waltzers
wanders114221333wa_nders
wanglers123310033wanglers
wankers144514713wa_nkers
wanters104420093wa_nters
wantoners12116673wantoners
warblers13319103warblers
warders113416813wa_rders
warmers124514293wa_rmers
warners103315563wa_rners
warpers123413583wa_rpers
warslers11328073warslers
washer124720393wa_sher_
washes124425493wa_she_s
wasters104026593wa_sters
watapes12228383watape_s
watch135617063watch___
watchcase1942773watchcase
watchcries2042743watchcries
watchdog1842243watchdog
watchdogs1942183watchdogs
watchful1943753watchful
watching173011173watching
watchmakers2552233watchmakers
watchman1844623watchman
watchmen1844753watchmen
watchout1647013watchout
watchouts1744043watchouts
watchtowers2271473watchtowers
watchword2143553watchword
watchwords2253293watchwords
water84733313wat__er_
waterer103314073waterer_
waterhens1574963waterhens
watery123914493wat__ery
watter93221983wat_ter_
watthours1542813watthours
wattles103814073wattle_s
wattless11268723wattless
wauchts15285283wauch_ts
waverers14318613waverers
wavers125022473wa__vers
waxers164014303wa__xers
weather133513223weat_her_
weighers15135673weighers
welcher15319393welcher_
welches153710313welche_s
welshers14246813welshers
wencher153811133wencher_
wenches152914133wenche_s
wether123315393wet_her_
wetters103817753wet_ters
whackers20326543whackers
whickers20297983whickers
wiches144418753w_iche_s
wickers164114703w_ickers
wincers123415363winc_ers
wincher153410653wincher_
winches154714373winche_s
wishers133215213w_ishers
witched163012193witche_d
witcheries1845463witcheries
witchier16307883witchier_
wither124321353wit_her_
withes124620843wit_he_s
wreathers15257493wreat_hers
wreckers17315973wreckers
wrenchers17256333wrenchers
wretches16257283wretche_s
writhers14398983writhers
wuther124511613wut_her_
wyches17387913w_yche_s
yachters1633883ya_chters
yatters103914623yat_ters
zithers193911973zit_hers

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.406440125.6
2DLD Change Limit1461623806.50022486.5
3Display Results3803800.1862043.0
 (SQL Overall)1786913807.09225196.1
 
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.