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

235 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
odd5772546(None) 
add510132371add
od39255251o_d
oda48133051oda
odds68919931odds
ode47446591ode
ods47546221ods
old47033471old
oud47439081oud
ad311975042_ad
adds67622462adds
ado49146882ado
ads49755742ads
adz1312332872adz
aid49269092aid
and47244182and
bad67763162bad
bed67950632bed
bid67751822bid
bod67055552bod
bode75838762bode
boded95124962boded
bods76244722bods
body107425682body
bold75432812bold
bond75334362bond
bud67041282bud
cad67456372cad
cod69660132cod
coda77029352coda
code77347742code
coded95433182coded
cods76848112cods
coed77140542coed
cold77338772cold
cord76740922cord
cud67937462cud
dad58456172dad
de37049552_de
did56850532did
do310155262_do
doc66841512doc
dodo66024922dodo
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dos48062312dos
dot47573182dot
dow76749972dow
dud56737602dud
ed38645192_ed
eddo63411812eddo
eddy93912102eddy
edh76921572edh
eds46638932eds
eld46733802eld
end46834362end
fad77452422fad
fed76548362fed
fid76847702fid
fold86528942fold
fond86330952fond
food86830572food
ford86835492ford
fud76335162fud
gad57556662gad
ged57044542ged
gid57047282gid
goad66830982goad
god57449802god
gods65438052gods
gold65430162gold
good66531802good
gowd96519982gowd
had77658772had
hid76248392hid
hod76852472hod
hodad10311352hodad
hods87239872hods
hoed87837982hoed
hold86235062hold
hood85132332hood
id38941852_id
ids47535482ids
iodid74315532iodid
kid86540632kid
lad48165712lad
led46254562led
lid47453532lid
load56730602load
lode56240122lode
loid55531502loid
lord55032082lord
loud55228042loud
mad68958722mad
med66146752med
mid67354482mid
mod69054412mod
mode75840312mode
modi76826322modi
mods77945062mods
mold76034332mold
mood76332062mood
mud67336872mud
nod47549572nod
noddy105411202noddy
node513036892node
nodi56626752nodi
nods55838232nods
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oca56731732oca
odah87018932odah
odas57230262odas
odder74515392odder
oddly1037162oddly
odea56224572odea
odes57243242odes
odic74920582odic
odor55718092odor
odyl84111462odyl
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
oh57447002o_h
ohed87825182ohed
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061492o_i
oil37452062oil
oka76926802oka
oke75839482oke
olds55926582olds
oldy85316852oldy
ole37155212ole
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
ope56845242ope
oped76230152oped
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orad56031692orad
orb55736862orb
orc57034922orc
ordo54622362ordo
ore36661832ore
ors35750112ors
ort39465232ort
os211359882o_s
ose38147342ose
ouds56430112ouds
our36042892our
out38072152out
ova66823792ova
ow58950172o_w
owe67041032owe
owed86833872owed
owl66228972owl
own66429702own
ox98242382o_x
oxid12815492oxid
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pad68057332pad
ped66751532ped
pod66351492pod
pods76540162pods
pond75530492pond
pood75934322pood
pud65836662pud
rad47662012rad
red46755812red
redd66323182redd
rid46754642rid
road56332112road
rod47953902rod
rode55844312rode
rods56442072rods
rood56733002rood
rudd65917482rudd
sad47459212sad
sod46053712sod
soda56329392soda
soddy104210702soddy
sods54940222sods
sold54837412sold
sord56237202sord
sudd64719782sudd
tad47959832tad
ted46446572ted
toad55830182toad
tod49457082tod
toddy106812422toddy
tods56141852tods
tody86327222tody
toed56137042toed
told56132202told
udo49027312udo
urd46427062urd
vid77241822vid
void86220572void
wad77053902wad
wed75843632wed
woad85523942woad
wold85429072wold
wood85329382wood
word89832002word
wud76227162wud
yid76640842yid
yod77545512yod
yodh119916112yodh
yods86531192yods
yond86122312yond
zed135431182zed

Search took 1 second 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 Filter178691140840.263679433.5
2DLD Change Limit140842350.37637457.4
3Display Results2352350.0465108.7
 (SQL Overall)1786912350.685260862.8
 
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.