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
odd5772545(None) 
add510132361add
od39255241o_d
oda48133041oda
odds68919921odds
ode47446581ode
ods47546211ods
old47033461old
oud47439071oud
ad311975032_ad
adds67622452adds
ado49146872ado
ads49755732ads
adz1312332862adz
aid49269082aid
and47244172and
bad67763152bad
bed67950622bed
bid67751812bid
bod67055542bod
bode75838752bode
boded95124962boded
bods76244712bods
body107425672body
bold75432812bold
bond75334362bond
bud67041272bud
cad67456362cad
cod69660122cod
coda77029342coda
code77347732code
coded95433182coded
cods76848102cods
coed77140542coed
cold77338772cold
cord76740922cord
cud67937452cud
dad58456162dad
de37049542_de
did56850522did
do310155252_do
doc66841512doc
dodo66024912dodo
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dos48062312dos
dot47573182dot
dow76749972dow
dud56737592dud
ed38645182_ed
eddo63411802eddo
eddy93912092eddy
edh76921562edh
eds46638922eds
eld46733792eld
end46834352end
fad77452412fad
fed76548352fed
fid76847692fid
fold86528942fold
fond86330952fond
food86830572food
ford86835492ford
fud76335152fud
gad57556652gad
ged57044532ged
gid57047272gid
goad66830982goad
god57449792god
gods65438042gods
gold65430162gold
good66531802good
gowd96519982gowd
had77658762had
hid76248382hid
hod76852462hod
hodad10311352hodad
hods87239862hods
hoed87837982hoed
hold86235062hold
hood85132332hood
id38941842_id
ids47535472ids
iodid74315532iodid
kid86540622kid
lad48165702lad
led46254552led
lid47453522lid
load56730602load
lode56240112lode
loid55531492loid
lord55032082lord
loud55228042loud
mad68958712mad
med66146742med
mid67354472mid
mod69054402mod
mode75840302mode
modi76826312modi
mods77945052mods
mold76034332mold
mood76332062mood
mud67336862mud
nod47549562nod
noddy105411202noddy
node513036882node
nodi56626742nodi
nods55838222nods
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oca56731732oca
odah87018932odah
odas57230262odas
odder74515392odder
oddly1037162oddly
odea56224572odea
odes57243242odes
odic74920572odic
odor55718092odor
odyl84111462odyl
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
oh57447002o_h
ohed87825182ohed
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oil37452052oil
oka76926802oka
oke75839482oke
olds55926572olds
oldy85316842oldy
ole37155212ole
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
ope56845242ope
oped76230152oped
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orad56031692orad
orb55736862orb
orc57034922orc
ordo54622352ordo
ore36661832ore
ors35750112ors
ort39465232ort
os211359882o_s
ose38147342ose
ouds56430102ouds
our36042892our
out38072152out
ova66823792ova
ow58950172o_w
owe67041032owe
owed86833872owed
owl66228972owl
own66429702own
ox98242382o_x
oxid12815482oxid
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pad68057322pad
ped66751522ped
pod66351482pod
pods76540152pods
pond75530492pond
pood75934322pood
pud65836652pud
rad47662002rad
red46755802red
redd66323172redd
rid46754632rid
road56332112road
rod47953892rod
rode55844302rode
rods56442062rods
rood56733002rood
rudd65917472rudd
sad47459202sad
sod46053702sod
soda56329382soda
soddy104210702soddy
sods54940212sods
sold54837412sold
sord56237202sord
sudd64719772sudd
tad47959822tad
ted46446562ted
toad55830182toad
tod49457072tod
toddy106812422toddy
tods56141842tods
tody86327212tody
toed56137042toed
told56132202told
udo49027302udo
urd46427052urd
vid77241812vid
void86220562void
wad77053892wad
wed75843622wed
woad85523942woad
wold85429072wold
wood85329382wood
word89832002word
wud76227152wud
yid76640832yid
yod77545502yod
yodh119916102yodh
yods86531182yods
yond86122312yond
zed135431172zed

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.250714764.0
2DLD Change Limit140842350.39036112.8
3Display Results2352350.0465108.7
 (SQL Overall)1786912350.686260482.5
 
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.