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

394 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
coke10703838(None) 
cake105439961cake
choke145118021choke
code77347731code
coked124730691coked
cokes115537191cokes
coky137526821coky
cole66956111cole
come87547701come
cone67256961cone
cope86847381cope
core67263111core
cote66648731cote
cove95837071cove
cuke105824981cuke
hoke115935931hoke
joke155926161joke
moke106234221moke
oke75839481_oke
poke105335361poke
soke85436261soke
toke86738491toke
woke115527961woke
yoke115626391yoke
awoke124912002awoke
bake105637512bake
bike106532602bike
bloke114316632bloke
bode75838752bode
bole66448692bole
bone65949322bone
bore66051332bore
broke116019782broke
cade76443912cade
cafe95230322cafe
cage75339062cage
caked126128622caked
cakes116037672cakes
cakey145517272cakey
caky136222442caky
came87648752came
cane66653122cane
cape87242782cape
care66968372care
case65848082case
cate66254602cate
cave95941262cave
cede74928772cede
cee55952702c_ee
cepe84926652cepe
cere66741472cere
cete64934782cete
choked164914792choked
choker154314372choker
chokes154917382chokes
chokey184811712chokey
choky175711222choky
chore105126762chore
chose105925402chose
cine66242942cine
cire65836372cire
cite65640342cite
clone75728162clone
close76425222close
clove105619442clove
cloze165517542cloze
clue65324532clue
coal66939252coal
coat67558352coat
coax136922982coax
cob710258752co_b
cobb106422002cobb
coble94823172coble
cobs87043142cobs
coca88030642coca
cock126332902cock
cocked155022562cocked
cocker144320392cocker
cockle143913572cockle
cocks135227162cocks
cocky164215932cocky
coco87330602coco
cod69660122co_d
coda77029342coda
codec107120342codec
coded95433182coded
coden86128542coden
coder86134222coder
codes86247292codes
codex155817582codex
cods76848102cods
coed77140542coed
coff126930782coff
coft97939682coft
cog69552902co_g
cogs77340032cogs
coho97524492coho
coif96337912coif
coil66439652coil
coin66645352coin
coir66327242coir
col59360352co_l
cola66541392cola
cold77338772cold
coled85540762coled
coles76055062coles
cols66553082cols
colt67158242colt
coly96940532coly
coma87134852coma
comae97128422comae
comake144413422comake
comb106632112comb
combe116223542combe
comer95832692comer
comes97246992comes
comet95946072comet
comp106731252comp
comte96125472comte
con510268022co_n
coned86040052coned
cones76457422cones
coney105932882coney
conge85227592conge
coni65534802coni
conk106531442conk
conked135019112conked
conker124721552conker
conks115525702conks
conky145818742conky
conn66229132conn
cons66057692cons
conte76633202conte
cony96537832cony
coo59566362co_o
cooed84534342cooed
cooee74531022cooee
cooer74831012cooer
cooey105828222cooey
coof96643272coof
cook107236932cook
cooked135921362cooked
cooker124722452cooker
cookey155414332cookey
cookie123716042cookie
cooks115429142cooks
cooky145321362cooky
cool66940492cool
coon67248942coon
coop87238652coop
coos67456492coos
coot67860382coot
cop711162372co_p
coped105036842coped
copen94826432copen
coper95336092coper
copes97747102copes
cops86751372cops
copse95623922copse
copy116229802copy
cor59960942co_r
cord76740922cord
cored85044222cored
corer75538872corer
cores76361852cores
corf95941482corf
cork106635692cork
corked135020782corked
corker124720852corker
corks116028272corks
corky145221152corky
corm85735382corm
corn69945812corn
cors66656442cors
corse75036182corse
cory96941512cory
cos510270392co_s
cosec96320182cosec
coses76949492coses
coset75748842coset
cosey106226712cosey
cosh96127622cosh
cosie74728262cosie
coss66143492coss
cost68057942cost
cosy97232702cosy
cot510483222co_t
coted85033852coted
cotes76347842cotes
cots68054842cots
coude85022632coude
coup86729792coup
coupe96023482coupe
coved115027372coved
coven106925042coven
cover105430772cover
coves105539172coves
covet105638942covet
covey136121782covey
cow89856712co_w
cowed115637852cowed
cower104531772cower
cowl97530812cowl
cows97046642cows
cowy126427362cowy
cox1210346782co_x
coxa136922962coxa
coxae146115182coxae
coxed154322812coxed
coxes145430862coxes
coy810557552co_y
coyed114623802coyed
coyer105222842coyer
coys97537242coys
coz149345362co_z
cozen165019702cozen
cozes166033242cozes
cozey196718542cozey
cozie163519132cozie
cozy185823802cozy
crake114823522crake
crone75231332crone
crore74922872crore
croze164719452croze
cube85830212cube
cue57544182c_ue
cukes115422092cukes
cure66149122cure
cute66440452cute
cyme119420372cyme
deke95228762deke
dike95935762dike
doe47361952do_e
doge66233802doge
dole56550002dole
dome77240732dome
done55747912done
dope76038892dope
dore56353302dore
dose56442432dose
dote55442882dote
dove85131562dove
doze145829082doze
duke95628102duke
dyke126418182dyke
eke75630092_eke
evoke12478852evoke
fake115534942fake
foe66350812fo_e
fore78351472fore
fyke145915292fyke
gone55639042gone
gore55744962gore
hake115637842hake
hike116830392hike
hoe67562722ho_e
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
hole77553392hole
home98042442home
hone77549322hone
hope96639672hope
hose76547242hose
hove107132222hove
howe106734102howe
jake155925772jake
joe106642352jo_e
joked175217912joked
joker165715892joker
jokes165423332jokes
jokey195014692jokey
joky186215312joky
jole117233822jole
juke154721662juke
kike76524792kike
kore85834162kore
lake85741602lake
leke85527402leke
like86040842like
lobe65535362lobe
lode56240112lode
loge56837192loge
lone45849132lone
lope65941922lope
lore45850352lore
lose45144582lose
love75234762love
lowe75435312lowe
make105537892make
mike105535292mike
mode75840302mode
mokes114631032mokes
mole66251832mole
mome85239352mome
mope86838042mope
more67154522more
mote67048082mote
moue65835572moue
move96630722move
node513036882node
nome66038422nome
none45743172none
nope65934192nope
nose46739362nose
note46239962note
nuke85920752nuke
obe56638642_obe
ocker113915752ocker
ode47446582_ode
oe28473062_o_e
oka76926802_oka
okeh114615322_okeh
okes84936342_okes
ole37155212_ole
one37050912_one
ooze136420602ooze
ope56845242_ope
ore36661832_ore
ose38147342_ose
owe67041032_owe
peke105926202peke
pike106335212pike
poked125425392poked
poker115122882poker
pokes116133012pokes
pokey145318972pokey
poky135922152poky
pole65951302pole
pome85636692pome
pone65747532pone
pope85535612pope
pore66451262pore
pose66441732pose
puke105025462puke
rake84841572rake
robe65335642robe
rode55844302rode
roe36861082ro_e
role45851822role
rope65542912rope
rose46148902rose
rote46249022rote
roue45941742roue
rove75136982rove
ryke115616402ryke
sake85244962sake
scone74621832scone
scope94821482scope
score75526742score
sike87138782sike
smoke115015822smoke
sokes95031422sokes
sole46053672sole
some66040382some
sone46649982sone
sore47059532sore
spoke114818662spoke
stoke94922512stoke
syke115420562syke
take84739262take
tike85534482tike
toe310166852to_e
toked105626492toked
token95419312token
toker95924912toker
tokes95234972tokes
tole46052902tole
tome67543192tome
tone46953742tone
tope65946382tope
tore47359322tore
tote46643672tote
troke94821052troke
tyke115720502tyke
uke75727292_uke
voe67739052vo_e
vole75236982vole
vote74728622vote
wake114935702wake
woe66651242wo_e
wok106334172wok_
woken124614972woken
woks116224902woks
wore77144672wore
wove105624312wove
yok107335242yok_
yoked134821622yoked
yokel124812612yokel
yokes125223022yokes
yoks116223742yoks
yore76335942yore
yowe106728742yowe
zone135231082zone

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.296603685.8
2DLD Change Limit298723940.89033564.0
3Display Results3943940.0934236.6
 (SQL Overall)1786913941.279139711.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.