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

332 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
speech134756(None) 
beech124315502_beech
breech13348262breech
fleech14367342fleech
leech104913212_leech
peach125422492_peach
pech116125452_p_ech
perch124518832_perch
samech13277032samech
screech1435212screech
sheesh1237812sheesh
sheuch14267042sheuch
sketch1535352sketch
sneesh945892sneesh
spec85821972sp_ec_
speck135115652sp_eck
specs96916672sp_ecs
speeches1537412speeches
speed85526622spee_d
speedo94011992speedo
speeds94316052speeds
speedy1218410782speedy
speel74420762spee_l
speels85116392speels
speer74623902spee_r
speers85019952speers
spence103813792spence
stench114111162stench
apeek114711873apee_k
apercu1057383apercu
apiece10510083apiece
aspect10612823asp_ect
beach124623893_beach
beechy16397503_beechy
belch124415503_belch
bench125619503_bench
beseech1453873beseech
bleach133611403bleach
blench133710453blench
breach134213723breach
clench133910053clench
creesh11328333creesh
dreich12377723dreich
drench12369593drench
each95530583__each
eparch13258423eparch
epee64628503epee__
epees75219833epee_s
epoch1248203ep_och
etch95419143__etch
fetch134913473_fetch
fleece11369903fleece
fleecy14266483fleecy
flench144010813flench
fletch14388193fletch
french143511213french
heuch135312333_heuch
impeach1644273impeach
kench145513923_kench
ketch144912023_ketch
kvetch1832993kvetch
leach105422523_leach
lech96825443__lech
letch105215803_letch
merch125417963_merch
nonspeech1651873nonspeech
parch125123003_parch
patch125221223_patch
peace95026083_peace
peachy164510843_peachy
pec76744413_p_ec_
pechs125516203_p_echs
peck125730683_p_eck
pecs84634103_p_ecs
pee56066513_pee__
peed76239183_pee_d
peek106031433_pee_k
peeks115021113_peeks
peel65535613_pee_l
peels75226423_peels
peen65938083_pee_n
peens76428193_peens
peep85833693_pee_p
peeps95822363_peeps
peer66238353_pee_r
peers75130273_peers
peery105719443_peery
pees65257373_pee_s
peeve104915253_peeve
peh86740963_p_e_h
pence94924453_pence
piece96717993_piece
pinch125619303_pinch
pitch125018413_pitch
pleach134211243pleach
plench134010813plench
poach124917863_poach
pooch124815303_pooch
porch125918623_porch
pouch124617083_pouch
preach133613923preach
psych1554963_psych
punch125118423_punch
quench2036633quench
reach105123883_reach
reecho11318653_reecho
reechy14367823_reechy
retch104818303_retch
samechs14285353samechs
samekh15355133samekh
sauch104918773s_auch
scooch13228123scooch
scorch13198093scorch
scotch13207513scotch
screechy1842763screechy
sculch13226213sculch
scutch13247083scutch
search113312423search
sec55945323s__ec_
secco9312423s_ecco
secs65033893s__ecs
sect67443623s__ect
see35772263s_ee__
seed55549483s_ee_d
seeds64330063s_eeds
seedy94821533s_eedy
seek85935483s_ee_k
seeks94724643s_eeks
seel45042983s_ee_l
seels55632823s_eels
seely84522633s_eely
seem65438563s_ee_m
seems75525023s_eems
seen46943123s_ee_n
seep66540343s_ee_p
seeps74828753s_eeps
seepy104717973s_eepy
seer45547043s_ee_r
seers55136383s_eers
sees45361053s_ee_s
seethe93712483s_eethe
seiche11811833s_eiche
selah8319613s_elah
select82621173select
seneca839793seneca
sepic94617053sepic_
sheath12412883sheath
sheen85023313shee_n
sheens95116993sheens
sheeny124912193sheeny
sheep105321523shee_p
sheer84726893shee_r
sheers94322403sheers
sheet84836953shee_t
sheets93918493sheets
sheeve123412843sheeve
sheikh16206993sheikh
sheuchs15234933sheuchs
sheugh13295883sheugh
skee85431473skee__
skeed105018983skee_d
skeen94817403skee_n
skeens103912913skeens
skees95023123skee_s
skeet95429183skee_t
skeets104513253skeets
skeigh14265903skeigh
sketchy1943043sketchy
skreegh15182643skreegh
slatch114510533slatch
sleek94619043slee_k
sleeks104512463sleeks
sleeky13398963sleeky
sleep74920183slee_p
sleeps83913323sleeps
sleepy11479413sleepy
sleet55639133slee_t
sleets64318873sleets
sleety94112653sleety
sleeve93411593sleeve
sleigh10258203sleigh
sleuth937233sleuth
slouch11438523slouch
smeek114912353smee_k
smeeks12428433smeeks
smirch1356463smirch
smooch13266803smooch
smutch13205843smutch
snatch114310603snatch
sneck114713663s_neck
sneer54919953snee_r
sneers64016173sneers
sneery93610413sneery
sneeze15318523sneeze
sneezy18345273sneezy
snitch11357943snitch
space95325673sp_ace
spaced114517253spaced
spacer104917793spacer
spaces104722633spaces
spacey136212533spacey
spacy125415623sp_acy
spae65034323spae__
spaed85522273spae_d
spaes76029973spae_s
speak114618673sp_eak
speaks125114583speaks
spean74620513sp_ean
speans85417143speans
spear75821063sp_ear
spears84019473spears
specced14266703specced
specie10412223specie
specks144312703specks
sped76031493sp_e_d
speechify2251933speechify
speeded113310423speeded
speeder103811073speeder
speedos10298263speedos
speedup1272983speedup
speeled103712453speeled
speered103614813speered
speil75618643sp_eil
speils84116223speils
speir75315363sp_eir
speirs85013233speirs
speise84614253speise
speiss84311643speiss
spelean937123spelean
spell75020303sp_ell
spells84617683spells
spelt75430193sp_elt
spelts84614643spelts
speltz174010113speltz
spencer113610973spencer
spences113413923spences
spend85619333sp_end
spends94714473spends
spendy124911143spendy
spense83912433spense
spent75532833sp_ent
sperm93216013sp_erm
sperms102512603sperms
spew95421873sp_e_w
spewed125512333spewed
spewer115112143spewer
spewers124210653spewers
spews105015923sp_ews
sphene113412403sphene
sphere113313663sphere
sphery14318883sphery
spic85227433sp_ic_
spica94717943sp_ica
spice95528813sp_ice
spiced115218313spiced
spicer104719313spicer
spices104326033spices
spicey134414233spicey
spick134519073sp_ick
spics94123243sp_ics
spicy125417713sp_icy
spied85427713spie_d
spiel74623913spie_l
spiels85317953spiels
spier75728033spie_r
spiers84421743spiers
spies76037623spie_s
spilth11469733spilth
spinach1435403spinach
splash1168823splash
spleen8310263spleen
spleens937103spleens
spleeny1234553spleeny
splent84720193splent
splice104915103splice
splosh1186543splosh
splotch1442843splotch
spread9312533spread
spree74830863spre_e
sprees85620643sprees
sprent84522383sprent
spruce103910873spruce
sprucy13356323sprucy
spue66025523spue__
spued84918473spue_d
spues75025383spue_s
squelch2152943squelch
stanch113812373stanch
starch113013203starch
steed66024943stee_d
steeds73814883steeds
steek95418003stee_k
steeks103613703steeks
steel55721993stee_l
steels64117983steels
steely93612573steely
steep76020703stee_p
steeps85215193steeps
steer55423863stee_r
steers63820983steers
steeve93710903steeve
stenchy15256213stenchy
stich104117923s_tich
stitch11419103stitch
stretch1236413stretch
subecho1445073subecho
such96424813s__uch
sumach135310113sumach
swatch14549283swatch
sweeny12358843sweeny
sweep104715723swee_p
sweeps114110513sweeps
sweepy14447453sweepy
sweer84918573swee_r
sweet85330523swee_t
sweets94214433sweets
switch14458913switch
synch135011793s_ynch
teach105221123_teach
tech95925443__tech
teeth87315853_teeth
tench105620003_tench
teuch105214853_teuch
trench114211613trench
upreach1444693upreach
vetch134411843_vetch
welch134411493_welch
wench136214783_wench
wrench14439353wrench
wretch14326533wretch
yecch15558093_yecch
yech127220533__yech

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 Limit1127163326.31317854.6
3Display Results3323320.1063132.1
 (SQL Overall)1786913326.55927243.6
 
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.