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 “sped” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

323 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
sped7603149(None) 
aped78538151aped
oped76230151oped
ped66751531_ped
seed55549481seed
shed86536151shed
siped84927681siped
sled55334371sled
sned56026051sned
spaed85522271spaed
spec85821971spec
speed85526621speed
spend85619331spend
spew95421871spew
spied85427711spied
spud75818491spud
spued84918471spued
sued56537931sued
abed79734132abed
aced79540882aced
aged67334252aged
ahed89536252ahed
amped104820512amped
ape57251182ape_
aper66336232aper
apes66047432apes
apex137220212apex
apod78123182apod
ashed97829772ashed
asked106919312asked
aspen75216092aspen
asper75520432asper
awed88436032awed
axed128829612axed
bed67950632_bed
biped104718832biped
bled75729312bled
bred75130972bred
caped104931802caped
coed77140542coed
coped105036852coped
cred76530882cred
cued76329562cued
cusped114312042cusped
deed65340902deed
died66137862died
doped95326712doped
duped95118322duped
dyed96720762dyed
ed38645192__ed
eked96718032eked
epee64628502epee
espied9359782espied
exed125420592exed
eyed86623232eyed
fed76548362_fed
feed84538902feed
fled85429772fled
gaed66031512gaed
gaped96123532gaped
gasped104814292gasped
ged57044542_ged
geed65435502geed
gied64631992gied
gled65631142gled
haed86338582haed
hasped125014442hasped
heed86437602heed
hied85434052hied
hoed87837982hoed
hoped115628182hoped
hued86925852hued
hyped145313332hyped
iced78721892iced
imped105117982imped
ired55131872ired
isled64615992isled
japed156217632japed
jeed125428502jeed
led46254562_led
lied55838102lied
lisped94113422lisped
loped85128332loped
med66146752_med
meed74934702meed
moped105424732moped
need54934152need
ohed87825182ohed
ope56845242ope_
open66427002open
opes65942612opes
opted84914272opted
owed86833872owed
pad68057332_pad
pe47649032_pe_
pea56657242_pea
pec76744412_pec
peds75835252_peds
pee56066512_pee
peed76239182peed
peg65843062_peg
peh86740962_peh
pen56558842_pen
pend75934532_pend
pep76447082_pep
per56353092_per
pes57259782_pes
pet56477302_pet
pew86442302_pew
pied75035372pied
piped105123162piped
pled75231432pled
pod66351492_pod
pseud867042pseud
pud65836662_pud
raped85334622raped
rasped94715202rasped
red46755812_red
reed55549622reed
riped85226432riped
roped84630812roped
rued55729792rued
sabed86526812sabed
sad47459212s_ad
sade55544482sade
sae38365182sae_
said55742122said
sand55338472sand
saned65636272saned
sapid84720932sapid
sapped114422012sapped
sard55344242sard
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scad75725772scad
scaped115519552scaped
scend85516292scend
scoped115116662scoped
scud76221282scud
sea36161292s_ea
sec55945322s_ec
see35772262s_ee
seeds64330062seeds
seedy94821532seedy
seek85935482seek
seel45042982seel
seem65438562seem
seen46943122seen
seep66540342seep
seeped94317522seeped
seer45547042seer
sees45361052sees
seg45544882s_eg
sei36048932s_ei
sel38253322s_el
sen36058522s_en
send55237292send
sept65844362sept
ser36752402s_er
sered65737292sered
set36681252s_et
sew66247262s_ew
sewed95325162sewed
sex107043222s_ex
sexed136618542sexed
shad86230912shad
shaped125020102shaped
she66837692she_
shea76031572shea
sheds96122702sheds
shend94719972shend
sherd96321152sherd
shes75734352shes
shew108030762shew
shied96125492shied
shod86225062shod
shoed95723012shoed
shred98125612shred
side55444502side
sided74825962sided
sild55030592sild
sipe67341052sipe_
sipes76036952sipes
sipped113720632sipped
sired66134282sired
sited65130742sited
sized155519242sized
skee85431472skee
skeed105018982skeed
skeg95316162skeg
skep105219352skep
skew116218762skew
skid95720942skid
skied104417762skied
skyed13529922skyed
sleds64418852sleds
slew76228232slew
slid55828992slid
sliped95417062sliped
sloped94216852sloped
slued64220512slued
smew95017732smew
sneds65715352sneds
sniped94913482sniped
soaped95817972soaped
sod46053712s_od
sold54837412sold
soled65835172soled
sopped114819902sopped
sord56237202sord
sored66141782sored
souped95017672souped
sowed94933862sowed
spa55730812sp_a
spaced114517252spaced
spade84423322spade
spaded103816752spaded
spado83713702spado
spae65034322spae
spaes76029972spaes
spam85930042spam
span65234662span
spar65433302spar
spared95427492spared
spas67036722spas
spat66548522spat
spay96631662spay
spayed124213612spayed
spaz155626162spaz
speak114618672speak
spean74620512spean
spear75821062spear
speck135115652speck
specs96916672specs
speedo94011992speedo
speeds94316052speeds
speedy1218410792speedy
speel74420762speel
speer74623902speer
speil75618642speil
speir75315362speir
spell75020302spell
spelt75430192spelt
spends94714472spends
spendy124911142spendy
spent75532832spent
sperm93216022sperm
spewed125512332spewed
spews105015922spews
spic85227432spic
spiced115218312spiced
spiel74623912spiel
spier75728032spier
spies76037622spies
spik105419712spik
spiked134915552spiked
spiled94621992spiled
spin66231302spin
spined95423942spined
spired94921862spired
spit65545082spit
spited94820442spited
spiv95917792spiv
spode84617702spode
spoked134413892spoked
spored94821792spored
spot65540692spot
spread9312532spread
spree74830862spree
spry96819122spry
spuds85113672spuds
spue66025522spue
spues75025382spues
spumed114711542spumed
spun66221462spun
spur65321192spur
spy86023742sp_y
stead65520272stead
steed66024942steed
stem610628252stem
step67126292step
stet45947322stet
stew77525462stew
stey76224412stey
stied65723032stied
stiped94517072stiped
stoped94721012stoped
stud56220092stud
styed95815482styed
sudd64719782sudd
sue35651462sue_
suede64419752suede
suer45334032suer
sues46247652sues
suet46754822suet
supe65932762supe_
super74924482super
supes75628302supes
supped114415702supped
surd56433812surd
swede94413202swede
swiped123811092swiped
taped85327422taped
ted46446572_ted
teed55439262teed
tied55535222tied
toed56137042toed
toped85631312toped
tsked105910032tsked
typed115815452typed
umped104717272umped
upend85011042upend
upped103715162upped
urped84615282urped
used55722822used
vied86328642vied
wed75843632_wed
weed85637512weed
wiped114722082wiped
wisped123411892wisped
zed135431182_zed

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298723230.85634897.2
3Display Results3233230.0804037.5
 (SQL Overall)1786913231.202148661.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.