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

351 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
scorch1319809(None) 
scooch13228121scooch
scotch13207511scotch
bescorch1742582bescorch
coach125919452_coach
conch124620072_conch
cooch124916832_cooch
couch125320112_couch
curch124415412_curch
porch125918622_porch
scarce104013632scarce
scarph13429602scarph
sconce104711722sconce
scootch1434452scootch
scorched16187192scorched
scorcher15196782scorcher
scorches15189142scorches
score75526732scor_e
scored94621132scored
scorer84818252scorer
scores84725922scores
scoria8513492scoria
scorn75817442scor_n
scorns85713022scorns
scouth115011152scouth
scrooch1444952scrooch
sculch13226212sculch
scutch13247082scutch
search113312422search
slouch11438522slouch
smirch1356462smirch
smooch13266802smooch
starch113013202starch
torch107420932_torch
acock132110213aco_ck
acorn75616623acor_n
acorns85013013acorns
anarch11310393anarch
arch98628443__arch
avouch1434833avouch
birch124914023_birch
blotch13197143blotch
borsch1336133_borsch
botch126717453_botch
broach133611113broach
brooch13368443brooch
caroch13911763_caroch
catch125120373_catch
cerci93716393_cerci
church1636483church
cinch124516243_cinch
circa9311403_circa
clach124617823_clach
coact96130583_coact
coca88030643_co_ca
cocci82812673_cocci
cock126332903_co_ck
coco87330603_co_co
coerce10310403_coerce
concha134213283_concha
concho134414263_concho
conchs134714903_conchs
conchy163710223_conchy
coprah133710603_coprah
cor59960943_cor__
coral76033453_coral
corby125018533_corby
cord76740923_cor_d
cords86030623_cords
core67263113_cor_e
cored85044223_cored
corer75538873_corer
cores76361853_cores
corf95941483_cor_f
corgi8316083_corgi
coria75828323_coria
cork106635693_cor_k
corks116028273_corks
corky145221153_corky
corm85735373_cor_m
corms95626223_corms
corn69945813_cor_n
corns76034763_corns
cornu75921323_cornu
corny106023273_corny
corps95927043_corps
cors66656443_cor_s
corse75036183_corse
cory96941513_cor_y
cosh96127623_co_sh
cough115819643_cough
couth106122493_couth
croc85723733_croc_
croci95818133_croci
crock135921993_crock
crocs95722433_crocs
crotch133410083crotch
crouch133910203crouch
culch124512833_culch
cutch125116193_cutch
eparch13258423eparch
epoch1248203epo_ch
escort84616483escor_t
escorts9418403escorts
exarch18196173exarch
force105324273_force
forth116222673_forth
grouch12318473grouch
hooch135813703_hooch
hoorah124411113hoorah
hootch14386403hootch
horah117922043_horah
hotch136214723_hotch
inarch1139173inarch
larch105919793_larch
loach105116363_loach
loch95527133_lo_ch
lurch104814633_lurch
march125622893_march
merch125417963_merch
mooch125313613_mooch
morph121712513_morph
mouch124715803_mouch
north86018273_north
notch105613323_notch
orach105219233__orach
orc57034923__orc_
orca65522773__orca
orcs67025433__orcs
ouch95724633__ouch
parch125123003_parch
perch124518833_perch
poach124917863_poach
pooch124815303_pooch
pouch124617083_pouch
roach105717003_roach
rotch105815933_rotch
samech13277033samech
sauch104918773s_auch
scar66434203scar__
scarab10310063scarab
scarcer113911373scarcer
scare75334463scar_e
scared95227293scared
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143scar_f
scarfs114714683scarfs
scarp95724103scar_p
scarphs14437413scarphs
scarps104718603scarps
scarry116311183scarry
scars75433533scar_s
scart76139773scar_t
scarts85321493scarts
scary105222593scar_y
schorl1179803schor_l
schorls1248353schorls
schrik15206703schrik
schrod1247883schrod
scirrhi1242293scirrhi
scoff134413343sco_ff
scoffs14347503scoffs
scold85414863sco_ld
scolds95011233scolds
scolex1538243scolex
sconced12359173sconced
sconces113811453sconces
scone74621833sco_ne
scones84521303scones
scooched16206683scooched
scooches15188413scooches
scoop95617163sco_op
scoops105414363scoops
scoot75729143sco_ot
scoots85315933scoots
scop85925523sco__p
scope94821483sco_pe
scoped115116653scoped
scopes104719593scopes
scops95820193sco_ps
scorchers16145513scorchers
scorching1735633scorching
scorers94115313scorers
scoriae9310903scoriae
scorify1535203scorify
scoring103117213scoring
scorned10229953scorned
scorner9259763scorner
scot66242603sco__t
scotched16187933scotched
scotches15179473scotches
scoter83815473scoter
scotia8310793scotia
scots74025903sco_ts
scour75315533sco_ur
scoured103811153scoured
scourer93910433scourer
scourge1035653scourge
scours84913593scours
scouse84113633scouse
scout75031453sco_ut
scouths12527893scouths
scouts84817943scouts
scow96021423sco__w
scowed124413823scowed
scowl1012012973sco_wl
scowls11549593scowls
scows106617803sco_ws
scrag85916173sc_rag
scraich1436763scraich
scram910621613sc_ram
scrap97120403sc_rap
scratch1446013scratch
scree720031703sc_ree
screech1435213screech
screw109318533sc_rew
scrim95419723sc_rim
scrip96619193sc_rip
scrod85115063sc_rod
scrods94111603scrods
scroll8310163scroll
scroop10299773scroop
scrootch1542813scrootch
scrota8310183scrota
scrub94914203sc_rub
scrum95418193sc_rum
scrunch1444033scrunch
scry96017763sc_r_y
scultch1483543scultch
scurf104719323scur_f
scurfs113210813scurfs
scurfy14338763scurfy
scurry11419583scurry
scurvy14386103scurvy
sheuch14267043sheuch
shock144917023sho_ck
shoran94016033shoran
shore85432643shor_e
shored105723643shored
shores94830403shores
shorl84720243shor_l
shorls94516193shorls
shorn85722173shor_n
short85040523shor_t
shorts95321733shorts
shorty124313193shorty
sirrah9379753sirrah
sketch1535353sketch
skort94925633skor_t
skorts104211293skorts
skosh12407263sko_sh
slatch114510533slatch
slosh84514483slo_sh
sloth85019443slo_th
slouchy15454843slouchy
slough10539233slough
smock135311673smo_ck
smoochy17223863smoochy
smoosh11236733smoosh
smooth11259193smooth
smutch13205843smutch
snatch114310603snatch
snitch11357943snitch
snore55424953snor_e
snored74819543snored
snorer64316763snorer
snores64324323snores
snort54833753snor_t
snorts64116503snorts
soca66330053s_o_ca
sock105233213s_o_ck
sooth85924053s_ooth
soph97024203s_o_ph
sora45746913s_or_a
soras55041013s_oras
sorb68333043s_or_b
sorbs75022103s_orbs
sord56237203s_or_d
sords64527803s_ords
sore47059533s_or_e
sored66141783s_ored
sorel56231443s_orel
sorer56236573s_orer
sores55454283s_ores
sorgho10348713s_orgho
sorgo64719723s_orgo
sori46039833s_or_i
sorn46641063s_or_n
sorns55028423s_orns
soroche1237183s_oroche
sorry84618253s_orry
sort46264813s_or_t
sorta57125413s_orta
sorts54536663s_orts
sorus54527583s_orus
soth75932513s_o_th
sough95320463s_ough
source8410673source
south85223573s_outh
speech1347563speech
splotch1442843splotch
sporal82915453sporal
spore75428593spor_e
spored94821793spored
spores84726613spores
sport75935983spor_t
sports84619183sports
sporty115112493sporty
stanch113812373stanch
starchy15286743starchy
stench114111163stench
stich104117923s_tich
stitch11419103stitch
stock114417563sto_ck
stoic7317243stoic_
stoics8311113stoics
stomach1436033stomach
storax1389783storax
store56333813stor_e
stored75524213stored
storer64721673storer
stores65533663stores
storey95217613storey
stork96819693stor_k
storks106115953storks
storm76520383stor_m
storms85814633storms
stormy115510733stormy
story86723033stor_y
such96424813s__uch
sumach135310113sumach
sunporch1542603sunporch
surah86823253s_urah
swarth126012083swarth
swatch14549283swatch
switch14458913switch
swoosh12195213swoosh
sword95214113swor_d
swords104510803swords
swore84920813swor_e
sworn86115303swor_n
synch135011793s_ynch
torah87125273_torah
torc66333353_torc_
torchy14549533_torchy
torcs75123763_torcs
touch106519393_touch
vouch134611903_vouch
worth117120523_worth

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163516.39017639.4
3Display Results3513510.1103190.9
 (SQL Overall)1786913516.64026911.3
 
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.