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

257 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
sketch153536(None) 
ketch144912021_ketch
sketchy1943051sketchy
etch95419142__etch
fetch134913472_fetch
fletch14388192fletch
kench145513922_kench
kvetch1832992kvetch
letch105215802_letch
resketch1742132resketch
retch104818302_retch
scotch13207522scotch
scutch13247082scutch
sheuch14267042sheuch
skeigh14265902skeigh
sketched1835392sketched
sketcher1735432sketcher
sketches1746822sketches
slatch114510532slatch
smutch13205842smutch
snatch114310602snatch
snitch11357942snitch
speech1347562speech
stench114111162stench
stitch11419102stitch
stretch1236412stretch
swatch14549282swatch
switch14458912switch
vetch134411842_vetch
wretch14326532wretch
aitch105216163_aitch
batch124620103_batch
beach124623893_beach
beech124315503_beech
belch124415503_belch
bench125619503_bench
beth96629233_bet_h
bitch125017763_bitch
bleach133611403bleach
blench133710453blench
blotch13197143blotch
botch126717453_botch
breach134213723breach
breech13348263breech
butch125416543_butch
catch125120373_catch
chetah14399583chetah
cheth135013823chet_h
clench133910053clench
clutch13367753clutch
cratch134110793cratch
crotch133410083crotch
crutch13408243crutch
cultch13385953cultch
cutch125116193_cutch
detach12310413_detach
ditch115015093_ditch
doeth9411983doet_h
dreich12377723dreich
drench12369593drench
dutch114713823_dutch
each95530583__each
eth66630983__et_h
fetich1479693_fetich
fitch134816873_fitch
fleech14367343fleech
flench144010813flench
flitch14928173flitch
french143511213french
glitch12286353glitch
grutch12285563grutch
hatch135719593_hatch
heth107028023_het_h
heuch135312333_heuch
hitch134515473_hitch
hootch14386413hootch
hotch136214733_hotch
hutch135414093_hutch
itch95619173__itch
keck94920713_ke_ck
ketches164012193_ketches
ketchup1842783_ketchup
keto86223453_ket_o
ketol95414003_ketol
kheth15509753khet_h
kith115826353_kit_h
kitsch1533353_kitsch
klatch15445933klatch
kvetchy2241803kvetchy
latch104620463_latch
leach105422523_leach
lech96825443_le_ch
leech104913213_leech
match125621103_match
merch125417963_merch
meth95827843_met_h
mutch125016173_mutch
natch105018223_natch
nautch1144813nautch
notch105613323_notch
okeh114615323oke__h
patch125221223_patch
peach125422493_peach
pech116125453_pe_ch
perch124518833_perch
pitch125018413_pitch
pleach134211243pleach
plench134010813plench
preach133613923preach
quench2036633quench
quitch2036413quitch
ratch104221363_ratch
reach105123883_reach
rotch105815933_rotch
saith85826553sait_h
samech13277033samech
sauch104918773s_auch
scooch13228123scooch
scootch1434463scootch
scorch13198093scorch
scratch1446013scratch
screech1435223screech
sculch13226213sculch
scultch1483543scultch
search113312423search
sec55945323s_e_c_
secco9312423s_ecco
secs65033893s_e_cs
sect67443623s_e_ct
sects75622893s_ects
seecatch1542693seecatch
seethe93712483seethe
seiche11811833s_eiche
selah8319613s_elah
set36681253s_et__
seta45637313s_et_a
setae56026223s_etae
setal56430903s_etal
seton55223543s_eton
sets45549503s_et_s
sett45949053s_et_t
setts55124323s_etts
setup73915823s_etup
sheath12412893sheath
sheesh1237813sheesh
sheikh16206993sheikh
sheuchs15234933sheuchs
sheugh13295883sheugh
sith75435153s_it_h
sixth155512233sixt_h
skat87037903skat__
skate94721553skat_e
skated114414883skated
skater105015493skater
skates104219403skates
skatol1035723skatol
skats94621543skat_s
skean94415623ske_an
skeane104611373skeane
skeans104512913skeans
skee85431473ske__e
skeed105018983ske_ed
skeen94817403ske_en
skeens103912913skeens
skees95023123ske_es
skeet95429183ske_et
skeeter113410413skeeter
skeets104513253skeets
skeg95316163ske__g
skegs105011233ske_gs
skein94814413ske_in
skeins103911903skeins
skell94915833ske_ll
skells105013783skells
skelm114211293ske_lm
skelms12368023skelms
skelp114211423ske_lp
skelps12407923skelps
skelter113610003skelter
skene96118123ske_ne
skenes104616633skenes
skep105219353ske__p
skeps115614253ske_ps
skeptic1545203skeptic
skeptics1653863skeptics
skerry13356103skerry
sketchers1834513sketchers
sketchier1853413sketchier
sketchily2142333sketchily
sketching1935083sketching
sketchpad2161363sketchpad
skew116218763ske__w
skewed145610233skewed
skewer13519613skewer
skews125413803ske_ws
skit85437533skit__
skite95120053skit_e
skited114313483skited
skites104418043skites
skits94721863skit_s
skosh12407273sk_osh
skreegh15182643skreegh
skreigh15243703skreigh
sleigh10258203sleigh
sleuth937233sleuth
sloth85019453slot_h
slouch11438523slouch
smirch1356463smirch
smith107818053smit_h
smooch13266803smooch
smutchy17193153smutchy
snatchy15355293snatchy
snath86419803snat_h
sneck114713663sne_ck
sneesh945893sneesh
sooth85924063soot_h
soth75932523s_ot_h
south85223573sout_h
spec85821973spe_c_
speck135115653spe_ck
specs96916673spe_cs
spence103813793spence
splotch1442853splotch
squelch2152953squelch
stanch113812373stanch
starch113013203starch
stenchy15256213stenchy
stet45947323stet__
stets55423913stet_s
stich104117923s_tich
stretchy1644083stretchy
such96424813s__uch
suet46754823suet__
suets55126103suet_s
suety85318493suet_y
sumach135310113sumach
swath115920383swat_h
swith115917403swit_h
synch135011793s_ynch
synth113711823synt_h
teach105221123_teach
tech95925443_te_ch
teeth87315853teet_h
tench105620003_tench
tetchy1436003_tetchy
teth76327893_tet_h
teuch105214853_teuch
thatch1435613thatch
trench114211613trench
twitch14406163twitch
watch135617063_watch
welch134411493_welch
wench136214783_wench
witch134517563_witch
wrench14439353wrench
yecch15558093_yecch
yech127220533_ye_ch

Search took 6 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.390458182.1
2DLD Change Limit1127162575.31321215.1
3Display Results2572570.0763381.6
 (SQL Overall)1786912575.77930920.7
 
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.