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

193 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
scorched1618719(None) 
scooched16206681scooched
scorcher15196781scorcher
scorches15189141scorches
scotched16187931scotched
bescorched2042312bescorched
coached153313842_coached
couched154115792_couched
scarphed1635442scarphed
sconced12359172sconc_ed
scooches15188412scooches
scootched1763962scootched
scorch13198092scorch__
scorchers16145512scorchers
scored94621132scor__ed
scorned10229952scor_ned
scotches15179472scotches
scrooched1763842scrooched
scutched16186892scutched
searched14209252searched
slouched14206742slouched
smirched1634672smirched
smooched16185982smooched
starched14199312starched
torched133511352_torched
acorned10238273acor_ned
arched125717323__arched
avouched1743583avouched
bescorches1942743bescorches
birched15349913_birched
blotched1635653blotched
botched153611903_botched
broached16309123broached
cached145419203_c_ached
churched1934653churched
cinched153910863_cinched
circled1237583_circled
cliched153711023_cliched
coacher143714123_coacher
coaches144018693_coaches
coacted123611613_coacted
cocked155022563_co_cked
coerced1238583_coerc_ed
conches144019813_conches
cooches143515833_cooches
corded105923353_cor_ded
cored85044223_cor__ed
corked135020783_cor_ked
corned95224523_cor_ned
cornfed1337383_cornfed
coshed124217543_co_shed
coucher144515853_coucher
couches144020473_couches
coughed143310903_coughed
cowshed1637773_cowshed
crochet143616663_crochet
crocked164014433_crocked
crotched16428593crotched
crouched16359143crouched
curches143512743_curches
douched144012113_douched
escorted1136703escor_ted
forced126316523_forc_ed
grouched15356663grouched
hoorahed1545093hoorahed
hotched163610923_hotched
inarched1486113inarched
lurched13358033_lurched
marched153813403_marched
mooched153910533_mooched
morphed1537133_morphed
mouched153612593_mouched
notched134210303_notched
orchid1289573__orchid
ouched124316933__ouched
parched154013693_parched
perched154713243_perched
poached154212403_poached
pooched152810083_pooched
porches143815673_porches
pouched153612773_pouched
roached133211833_roached
scarce104013633scarc_e_
scarcer113911373scarc_er
scared95227293scar__ed
scarehead1543803scarehead
scarfed134711183scar_fed
scarped124314403scar_ped
scarred104512633scar_red
scarted104816123scar_ted
scathed134012643sc_athed
scoffed16266183sco_ffed
scolded11358863sco_lded
sconce104711723sconc_e_
sconces113811453sconc_es
sconcheon1642373sconcheon
scooch13228123scooch__
scooped124611743sco_oped
scootches1635003scootches
scooted103612283sco_oted
scoped115116653sco__ped
scorching1735633scorching
score75526743scor__e_
scorecard1442953scorecard
scorepad1363383scorepad
scorer84818263scor__er
scores84725923scor__es
scoriae9310903scoriae_
scorified1546193scorified
scorner9259763scor_ner
scotch13207523scotch__
scoured103811153sco_ured
scourged1234573scourged
scouted104112033sco_uted
scouther1356943scouther
scowed124413833sco__wed
scowled13398193sco_wled
scraiched1744203scraiched
scraped124313133sc_raped
scratched1735393scratched
screeched17114343screeched
screed95718933sc_r_eed
screwed135710663sc_rewed
scribed124510643sc_ribed
scried95817303sc_r_ied
scrived134511113sc_rived
scrolled1137053scrolled
scrooches1645703scrooches
scrooped1356403scrooped
scrootched1842333scrootched
scrouged1235383scrouged
scrunched1744033scrunched
sculches15176273sculches
scurried11267053scurried
scutcher15176963scutcher
scutches15168883scutches
scythed16385303sc_ythed
searcher13209103searcher
searches132112903searches
shocked174611813sho_cked
shored105723653shor__ed
shorted113614403shor_ted
shorthead1644473shorthead
sketched1835393sketched
sloshed11329823slo_shed
sloucher13206813sloucher
slouches13208073slouches
sloughed13305583sloughed
smirches1535993smirches
smocked16398223smo_cked
smoocher15205503smoocher
smooches15217263smooches
smooshed14185993smooshed
smoothed14236473smoothed
smutched16165923smutched
snatched14157633snatched
snitched14166863snitched
snored74819543snor__ed
snorted83813493snor_ted
snowshed1534423snowshed
socked134721503s_o_cked
soothed113712743s_oothed
sorbed94916523s_or_bed
sored66141783s_or__ed
sorehead1246973s_orehead
sorned74820043s_or_ned
soroche1237183s_oroche_
soroches1338803s_oroches
sorted74523713s_or_ted
sortied83314103s_ortied
soughed123811623s_oughed
sourced1038453sourc_ed
southed114313993s_outhed
splotched1742823splotched
spored94821793spor__ed
sported104015433spor_ted
stanched14208903stanched
starches131912913starches
stitched14148203stitched
stocked144312873sto_cked
stomached1794013stomached
stored75524213stor__ed
storeyed1234643storeyed
storied8515163stor_ied
stormed1039043stor_med
switched17157133switched
swooshed15174273swooshed
synched16277213s_ynched
torches123715433_torches
touched134914963_touched
unarched14128553unarched
vouched163910563_vouched
worthed1437873_worthed

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.423422437.4
2DLD Change Limit1461621936.70321805.5
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.20224811.3
 
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.