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

318 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
oped7623015(None) 
aped78538151aped
coped105036851coped
doped95326711doped
hoped115628181hoped
loped85128331loped
moped105424731moped
ohed87825181ohed
ope56845241ope_
open66427001open
opes65942611opes
opted84914271opted
owed86833871owed
ped66751531_ped
roped84630811roped
sped76031491sped
toped85631311toped
abed79734132abed
aced79540882aced
aged67334252aged
ahed89536252ahed
amped104820512amped
ape57251182ape_
aper66336232aper
apes66047432apes
apex137220212apex
apod78123182apod
awed88436032awed
axed128829612axed
bed67950632_bed
biped104718832biped
bled75729312bled
boded95124962boded
boned85133242boned
booed85127272booed
bopped134413402bopped
bored85034302bored
bowed114533422bowed
boxed154318612boxed
bred75130972bred
caped104931802caped
coded95433182coded
coed77140542coed
coked124730692coked
coled85540762coled
comped135919872comped
coned86040052coned
cooed84534342cooed
cooped114821612cooped
cope86847382cope_
copen94826432copen
coper95336092coper
copes97747102copes
copied114618572copied
copped135221262copped
cored85044222cored
coted85033852coted
couped115019312couped
coved115027372coved
cowed115637852cowed
coxed154322812coxed
coyed114623802coyed
cred76530882cred
cued76329562cued
deed65340902deed
died66137862died
doled75430912doled
domed95423262domed
dope76038892dope_
doper86128392doper
dopes84935042dopes
dopey116020352dopey
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
duped95118322duped
dyed96720762dyed
ed38645192__ed
eked96718032eked
eloped95914152eloped
epee64628502epee
exed125420592exed
eyed86623232eyed
fed76548362_fed
feed84538902feed
fled85429772fled
fopped144012672fopped
foxed165115212foxed
gaed66031512gaed
gaped96123532gaped
ged57044542_ged
geed65435502geed
gied64631992gied
gled65631142gled
gored75227082gored
groped107515062groped
haed86338582haed
heed86437602heed
hied85434052hied
hoed87837982hoed
hoked135326992hoked
holed95634132holed
homed115425422homed
honed95332262honed
hooped125518182hooped
hope96639672hope_
hoper105829142hoper
hopes105835642hopes
hopped144318112hopped
hosed95830982hosed
hued86925852hued
hyped145313332hyped
iced78721892iced
imped105117982imped
ired55131872ired
japed156217632japed
jeed125428502jeed
joked175217912joked
jowed164724422jowed
joyed164811832joyed
kopek1037812kopek
led46254562_led
lied55838102lied
lobed86022132lobed
looed64626132looed
looped95217172looped
lope65941922lope_
loper75129232loper
lopes76437342lopes
lopped114218622lopped
louped95316382louped
loved95021362loved
lowed95233902lowed
loxed135017052loxed
med66146752_med
meed74934702meed
mooed85123982mooed
mope86838042mope_
mopeds11499662mopeds
moper94925922moper
mopes95134982mopes
mopey124821822mopey
mopped134114322mopped
moved114218152moved
mowed113629012mowed
need54934152need
nope65934192nope_
nosed65524562nosed
noted65123842noted
oared65030652oared
obe56638642obe_
obes66036832obes
obey96521302obey
od39255252o__d
odd57725462o_dd
ode47446592ode_
odea56224572odea
odes57243242odes
oe28473062o_e_
oes35866192o_es
offed12359162offed
ogee57629882ogee
ogled75915962ogled
oiled64429472oiled
oke75839482oke_
okeh114615322okeh
okes84936342okes
old47033472o_ld
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
omen66828182omen
omer67028392omer
one37050912one_
ones46146532ones
oohed94214212oohed
oozed154214262oozed
op45850162op__
opah96218402opah
opal66923522opal
opened94311862opened
opens76118552opens
opera7313572opera
opined95113852opined
ops56641252op_s
opt57545542op_t
opts68124742opts
opus66420592opus
orad56031692orad
orbed85516192orbed
ore36661832ore_
oread64619602oread
ores46056682ores
ose38147342ose_
oses46641512oses
oud47439082o_ud
outed65429062outed
oven76624142oven
over77227342over
owe67041032owe_
owes75137102owes
owned95113232owned
oxen116218592oxen
oxes116530722oxes
oxid12815492oxid
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
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
poem86225772poem
poet65552902poet
poked125425392poked
poled84934842poled
pond75530492pond
pood75934322pood
pooed85226242pooed
pooped113915942pooped
pope85535612pope_
popes95933812popes
popped104117812popped
pored85234512pored
posed85828412posed
poxed154817862poxed
pud65836662_pud
raped85334622raped
red46755812_red
reed55549622reed
riped85226432riped
robed85323732robed
romped114513652romped
rope65542912rope_
roper75431912roper
ropes75940062ropes
ropey106021872ropey
rosed65930352rosed
rouped95717352rouped
roved95323552roved
rowed94034322rowed
rued55729792rued
scoped115116662scoped
seed55549482seed
shed86536152shed
siped84927682siped
sled55334372sled
sloped94216852sloped
sned56026052sned
soaped95817972soaped
soled65835172soled
sopped114819902sopped
sored66141782sored
souped95017672souped
sowed94933862sowed
spaed85522272spaed
spec85821972spec
speed85526622speed
spend85619332spend
spew95421872spew
spied85427712spied
spud75818492spud
spued84918472spued
stoped94721012stoped
sued56537932sued
taped85327422taped
ted46446572_ted
teed55439262teed
tied55535222tied
toed56137042toed
toked105626492toked
toled65934922toled
toned65435342toned
tope65946382tope_
topee76029952topee
toper75231022toper
topes76941762topes
topped114617722topped
toted64929482toted
towed95134582towed
toyed96019802toyed
typed115815452typed
umped104717272umped
upend85011042upend
upped103715162upped
urped84615282urped
used55722822used
vied86328642vied
voled95323722voled
voted93919142voted
vowed124424572vowed
wed75843632_wed
weed85637512weed
wiped114722082wiped
wooed94419872wooed
wowed124023772wowed
yoked134821622yoked
yowed1253025182yowed
zed135431182_zed
zoned154020262zoned

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.280638182.1
2DLD Change Limit298723180.87634100.5
3Display Results3183180.0764184.2
 (SQL Overall)1786913181.232145041.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.