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

354 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
cox121034678(None) 
box1210142341box
coax136922971coax
cob710258751cob
cod69660121cod
cog69552901cog
col59360351col
con510268021con
coo59566361coo
cop711162371cop
cor59960941cor
cos510270391cos
cot510483221cot
cow89856711cow
coxa136922961coxa
coy810557551coy
coz149345361coz
fox136737861fox
gox117137181gox
lox108240961lox
ox98242381_ox
pox126140691pox
sox106444191sox
vox136628151vox
ax911057782_ax
bo410957572bo_
boa56954032boa
bob76755662bob
bod67055542bod
bog67852412bog
boo58163662boo
bop77549482bop
bos57966812bos
bot59680402bot
bow87051902bow
boxy166420732boxy
boy87753562boy
cab78355402cab
cad67456362cad
calx135722792calx
cam78058982cam
can57760132can
cap76758982cap
car59165562car
cat58282342cat
caw86647932caw
cay87155982cay
cee55952702cee
cel56040552cel
cep75736332cep
chi86228652chi
chon96627792chon
chop116024922chop
chow125820992chow
cig67036182cig
cion613330912cion
cis57748032cis
clod76124612clod
clog76123242clog
clon66232482clon
clop86929892clop
clot66542422clot
cloy96623832cloy
coal66939252coal
coat67558342coat
cobb106421992cobb
cobs87043142cobs
coca88030642coca
cock126332902cock
coco87330602coco
coda77029342coda
code77347732code
codex155817572codex
cods76848102cods
coed77140542coed
coff126930782coff
coft97939682coft
cogs77340032cogs
coho97524492coho
coif96337902coif
coil66439652coil
coin66645352coin
coir66327242coir
coke107038382coke
coky137526822coky
cola66541392cola
cold77338772cold
cole66956112cole
cols66553082cols
colt67158242colt
coly96940532coly
coma87134852coma
comb106632112comb
come87547702come
comix163513192comix
comp106731252comp
cone67256962cone
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
cony96537832cony
coof96643272coof
cook107236932cook
cool66940492cool
coon67248942coon
coop87238652coop
coos67456492coos
coot67860382coot
cope86847382cope
cops86751372cops
copy116229802copy
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cors66656442cors
cory96941512cory
cosh96127622cosh
coss66143492coss
cost68057942cost
cosy97232702cosy
cote66648732cote
cots68054842cots
coup86729792coup
cove95837072cove
cowl97530812cowl
cows97046642cows
cowy126427362cowy
coxae146115182coxae
coxal146116672coxal
coxed154322812coxed
coxes145430862coxes
coys97537242coys
cozy185823802cozy
croc85723732croc
crop87628632crop
crow96428132crow
cru57129562cru
crux135415002crux
cry89726242cry
cub76940942cub
cud67937452cud
cue57544182cue
cum76440162cum
cup76738242cup
cur56841982cur
cut57957662cut
cwm106815082cwm
dex116936882dex
do310155252do_
doc66841512doc
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dos48062312dos
dot47573182dot
doux125817982doux
dow76749972dow
doxy156419952doxy
eon36052082eon
ex98835642_ex
fax138143312fax
fix136236102fix
fob86748332fob
foe66350812foe
fog76945562fog
foh98135892foh
fon66352272fon
fop86743702fop
for66952072for
fou66743782fou
foxy176517752foxy
foy96044262foy
go38748742go_
goa47343802goa
gob68950892gob
god57449792god
goo47754772goo
gor47848262gor
gos47155132gos
got49870442got
goy77844552goy
hex137436172hex
ho510258272ho_
hoax147718292hoax
hob87550922hob
hod76852462hod
hoe67562722hoe
hog78049062hog
hon67759382hon
hop87554592hop
hos68364192hos
hot67776052hot
how97252432how
hoy97447912hoy
icon66922042icon
ion36051022ion
jo99539602jo_
job128041772job
joe106642352joe
jog117438312jog
jot108259022jot
jow137639302jow
joy137036362joy
kex146029582kex
koa76737772koa
kob99442382kob
koi77534742koi
kop97440202kop
kor76538892kor
kos76944822kos
lax107651522lax
lex107943822lex
lo28053442lo_
lob57154462lob
log46252682log
loo38359822loo
lop58255312lop
lot38179262lot
low66051872low
lux106528772lux
max129045442max
mix126138172mix
mo49158482mo_
moa57249182moa
mob78651912mob
moc77845082moc
mod69054402mod
mog66949672mog
mol56654592mol
mom78853162mom
mon57561572mon
moo58460512moo
mop76950822mop
mor56855002mor
mos57067122mos
mot57279422mot
mow86650352mow
moxa136917742moxa
nix106932832nix
no29353242no_
nob58954422nob
nod47549562nod
nog46847312nog
noh66640642noh
nom510450642nom
noo37154042noo
nor38048822nor
nos38859322nos
not39474662not
now65950192now
oca56731732oca
od39255242_od
oe28473062_oe
of58247772_of
oh57447002_oh
oi29061482_oi
om48553002_om
on28057182_on
ooh67637092ooh
oot311274692oot
op45850162_op
or27354732_or
os211359882_os
ow58950172_ow
oxo107322962_oxo
oxy136320982_oxy
oy58950132_oy
pax127346852pax
pix126437932pix
pod66351482pod
poh86740532poh
poi57244662poi
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pot58078432pot
pow87147282pow
poxy166820892poxy
pyx157817012pyx
rax108445722rax
rex105740992rex
rob56754302rob
roc520243252roc
rod47953892rod
roe36861072roe
rom59855632rom
rot37282952rot
roux117419362roux
row67453672row
sax107447642sax
scop85925522scop
scot66242602scot
scow96021422scow
sex107043222sex
six105339742six
so28855442so_
sob57857942sob
sod46053702sod
sol37256622sol
som59153802som
son37761952son
sop57557862sop
sos37761602sos
sot310384292sot
sou37853692sou
sow66554762sow
soy67851452soy
tax109449152tax
to218858982to_
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
too38965422too
top510560682top
tor39261682tor
tot38884772tot
tow610557362tow
toy69655192toy
tux105426572tux
vex136429172vex
voe67739052voe
vow96136312vow
wax137041182wax
wo510447762wo_
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
yo59748552yo_
yob87945272yob
yod77545502yod
yok107335242yok
yom88043442yom
yon67348952yon
you66641822you
yow96945292yow
zax197630632zax
zoa128529992zoa
zoo126238912zoo

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.0632836365.1
2DLD Change Limit140843540.42333295.5
3Display Results3543540.0764657.9
 (SQL Overall)1786913540.562317955.5
 
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.