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

210 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
scotched1618793(None) 
scooched16206681scooched
scootched1763961scootched
scorched16187201scorched
scotches15179471scotches
scutched16186891scutched
blotched1635652blotched
botched153611902_botched
coached153313842_coached
couched154115792_couched
crotched16428592crotched
hotched163610922_hotched
notched134210302_notched
scathed134012642scat_hed
sconced12359172sconc_ed
scooches15188412scooches
scootches1635002scootches
scorcher15196792scorcher
scorches15189152scorches
scotch13207522scotch__
scratched1735392scratched
scrooched1763842scrooched
scrootched1842332scrootched
scutcher15176962scutcher
scutches15168882scutches
scythed16385302scyt_hed
sketched1835392sketched
slouched14206742slouched
smooched16185982smooched
smutched16165922smutched
snatched14157632snatched
snitched14166862snitched
soothed113712742soot_hed
splotched1742822splotched
stitched14148202stitched
switched17157132switched
avouched1743583avouched
batched154114243_batched
bescorched2042323bescorched
bitched153212923_bitched
blotches1537433blotches
botcher143613223_botcher
botches143716023_botches
broached16309123broached
cached145419203_c_ached
catcher143115823_catcher
catches144320773_catches
cinched153910863_cinched
cliched153711023_cliched
clothed134010283clot_hed
clutched16356033clutched
coacher143714123_coacher
coaches144018693_coaches
coacted123611613_coacted
cocked155022563_co_cked
conches144019813_conches
cooches143515833_cooches
coshed124217543_co_shed
coted85033853_cot__ed
coucher144515853_coucher
couches144020473_couches
coughed143310903_coughed
cowshed1637773_cowshed
crotches153411303crotches
crotchet152711993crotchet
crouched16359143crouched
crutched16307463crutched
cutches143216463_cutches
ditched143711903_ditched
douched144012113_douched
escoted1038183escot__ed
etched123613703__etched
fetched163710473_fetched
fletched17306693fletched
flitched17256293flitched
frothed14288783frot_hed
grouched15356663grouched
grutched15284673grutched
hatched163414463_hatched
hitched163312253_hitched
hootches1656973hootches
hopscotched2451283hopscotched
hotches153814363_hotches
hutched16359883_hutched
itched123812023__itched
kvetched2142783kvetched
latched133914073_latched
letched133912053_letched
matched153513963_matched
mooched153910533_mooched
mouched153612593_mouched
notcher123610933_notcher
notches123513653_notches
ouched124316933__ouched
patched153514623_patched
pitched153512923_pitched
poached154212403_poached
pooched152810083_pooched
pouched153612773_pouched
retched133814273_retched
roached133211833_roached
rotche114311983_rotche_
rotches123515703_rotches
satchel123310303s_atchel
scarphed1635443scarphed
scathe114414993scat_he_
scathes124515713scat_hes
scatted103512773scat_ted
schatchen1943853schatchen
scoffed16266183sco_ffed
scolded11358863sco_lded
sconce104711723sconc_e_
sconces113811453sconc_es
sconcheon1642373sconcheon
scooch13228123scooch__
scooped124611743sco_oped
scootch1434463scootch__
scooted103612283sco_oted
scoped115116653sco__ped
scorch13198093scorch__
scorchers16145513scorchers
scored94621133sco__red
scorned10229953sco_rned
scotching1735653scotching
scoter83815483scot__er
scottie937463scottie_
scotties1039753scotties
scoured103811153sco_ured
scourged1234573scourged
scouted104112033sco_uted
scouther1356943scouther
scowed124413833sco__wed
scowled13398193sco_wled
scraiched1744203scraiched
scratcher1635443scratcher
scratches1647323scratches
screeched17114343screeched
scrooches1645703scrooches
scrootches1743323scrootches
scrunched1744033scrunched
sculches15176273sculches
scultches1664293scultches
scutch13247083scutch__
scutcheon1642273scutcheon
scutchers16175643scutchers
scuttled1134533scuttled
scythe14466013scyt_he_
scythes15356523scyt_hes
searched14209253searched
seethed113410193seet_hed
shocked174611813sho_cked
shotted113912403shot_ted
sketcher1735433sketcher
sketches1746823sketches
slatches131511533slatches
sloshed11329823slo_shed
slotted84613883slot_ted
sloucher13206813sloucher
slouches13208073slouches
sloughed13305583sloughed
smirched1634673smirched
smocked16398223smo_cked
smoocher15205503smoocher
smooches15217263smooches
smooshed14185993smooshed
smoothed14236473smoothed
smother123510213smot_her
smutches15177273smutches
snatcher13167763snatcher
snatches131410713snatches
snitcher13157373snitcher
snitches13148983snitches
snowshed1534423snowshed
socked134721503s_o_cked
sooted73922593soot__ed
soothe94214853soot_he_
soother104215043soot_her
soothes103917113soot_hes
sotted74121403s_ot_ted
soughed123811623s_oughed
southed114313993s_outhed
spathed134013183spat_hed
splotches1643913splotches
spotted103713143spot_ted
stanched14208903stanched
starched14199313starched
stitcher13168393stitcher
stitches131410593stitches
stocked144312873sto_cked
stomached1794013stomached
stotted83511423stot_ted
stretched1546213stretched
swatches16169963swatches
swathed144611933swat_hed
switcher16177683switcher
switches16159133switches
swooshed15174273swooshed
swotted11398713swot_ted
synched16277213s_ynched
tetched133010773_tetched
thatched1735433thatched
toothed113310243toot_hed
torched133511363_torched
touched134914963_touched
trothed114010973trot_hed
twitched17155033twitched
vouched163910563_vouched
watched163012823_watched
witched163012193_witched
wretched17276533wretched

Search took 9 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.423422437.4
2DLD Change Limit1461622107.72018932.9
3Display Results2102100.0762763.2
 (SQL Overall)1786912108.21921741.2
 
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.