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

330 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
yok10733524(None) 
wok106334171wok
yak107038561yak
yo59748551yo_
yob87945271yob
yock135924611yock
yod77545501yod
yoke115626391yoke
yoks116223741yoks
yolk116218991yolk
yom88043441yom
yon67348951yon
you66641821you
yow96945291yow
yuk106725601yuk
amok10217402amok
ark77044962ark
ask77130702ask
auk76234142auk
bo410957572bo_
boa56954032boa
bob76755662bob
bock126032512bock
bod67055542bod
bog67852412bog
bonk105531712bonk
boo58163662boo
book106836332book
bop77549482bop
bork106933822bork
bos57966812bos
bosk105825732bosk
bot59680402bot
bow87051902bow
box1210142342box
boy87753562boy
cob710258752cob
cock126332902cock
cod69660122cod
cog69552902cog
coke107038382coke
coky137526822coky
col59360352col
con510268022con
conk106531442conk
coo59566362coo
cook107236932cook
cop711162372cop
cor59960942cor
cork106635692cork
cos510270392cos
cot510483222cot
cow89856712cow
cox1210346782cox
coy810557552coy
coz149345362coz
dak86340692dak
do310155252do_
doc66841512doc
dock116228742dock
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dork96531462dork
dos48062312dos
dot47573182dot
dow76749972dow
eek77935102eek
elk76726122elk
eon36052082eon
fob86748332fob
foe66350812foe
fog76945562fog
foh98135892foh
folk116021542folk
fon66352272fon
fop86743702fop
for66952072for
fork115930942fork
fou66743782fou
fox136737862fox
foy96044262foy
go38748742go_
goa47343802goa
gob68950892gob
god57449792god
goo47754772goo
gook96429602gook
gor47848262gor
gos47155132gos
got49870442got
gowk125516472gowk
gox117137182gox
goy77844552goy
grok95819682grok
ho510258272ho_
hob87550922hob
hock136031302hock
hod76852462hod
hoe67562722hoe
hog78049062hog
hoke115935932hoke
holk116027942holk
hon67759382hon
honk116931192honk
hook116133282hook
hop87554592hop
hos68364192hos
hot67776052hot
how97252432how
howk145221962howk
hoy97447912hoy
ick97329322ick
ilk78325302ilk
ink76433632ink
ion36051022ion
irk76426362irk
jo99539602jo_
job128041772job
jock176522642jock
joe106642352joe
jog117438312jog
joke155926162joke
joky186215312joky
jot108259022jot
jouk156015992jouk
jow137639302jow
joy137036362joy
koa76737772koa
kob99442382kob
koi77534742koi
konk79320612konk
kook75822602kook
kop97440202kop
kor76538892kor
kos76944822kos
kyak105213632kyak
lek75640302lek
lo28053442lo_
lob57154462lob
lock106134362lock
log46252682log
loo38359822loo
look87333472look
lop58255312lop
lot38179262lot
low66051872low
lox108240962lox
mo49158482mo_
moa57249182moa
mob78651912mob
moc77845082moc
mock126429442mock
mod69054402mod
mog66949672mog
moke106234222moke
mol56654592mol
mom78853162mom
mon57561572mon
monk105928512monk
moo58460512moo
mop76950822mop
mor56855002mor
mos57067122mos
mosk105622442mosk
mot57279422mot
mow86650352mow
no29353242no_
nob58954422nob
nock106127182nock
nod47549562nod
nog46847312nog
noh66640642noh
nom510450642nom
noo37154042noo
nook85728492nook
nor38048822nor
nos38859322nos
not39474662not
now65950192now
oak76238652oak
od39255242_od
oe28473062_oe
of58247772_of
oh57447002_oh
oi29061482_oi
oka76926802_oka
oke75839482_oke
om48553002_om
on28057182_on
ooh67637092ooh
oot311274692oot
op45850162_op
or27354732_or
os211359882_os
ow58950172_ow
ox98242382_ox
oy58950132_oy
pock126129292pock
pod66351482pod
poh86740532poh
poi57244662poi
poke105335362poke
poky135922152poky
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pork106929682pork
pot58078432pot
pow87147282pow
pox126140692pox
rob56754302rob
roc520243252roc
rock105735182rock
rod47953892rod
roe36861072roe
rom59855632rom
rook85532032rook
rot37282952rot
row67453672row
ryot75528562ryot
so28855442so_
soak87227662soak
sob57857942sob
sock105233212sock
sod46053702sod
soke85436262soke
sol37256622sol
som59153802som
son37761952son
sook84933392sook
sop57557862sop
sos37761602sos
sot310384292sot
sou37853692sou
souk86127172souk
sow66554762sow
sox106444192sox
soy67851452soy
suk75632972suk
to218858982to_
tod49457072tod
toe310166852toe
tog410255042tog
toke86738492toke
tom514358052tom
ton310265102ton
too38965422too
took86531072took
top510560682top
tor39261682tor
tot38884772tot
tow610557362tow
toy69655192toy
tsk75814732tsk
voe67739052voe
vow96136312vow
vox136628152vox
wo510447762wo_
woe66651242woe
wog76242732wog
woke115527962woke
woks116224902woks
won66252062won
wonk116125302wonk
woo66949802woo
wop87145132wop
work115528842work
wos66953532wos
wot610467482wot
wow96643472wow
ya510251502y_a
yack135425972yack
yag76947732yag
yah99046352yah
yaks116025202yaks
yam87448992yam
yank115423662yank
yap85949822yap
yapok14468152yapok
yar67253832yar
yaw97145152yaw
yay96948712yay
ye57650062y_e
yea66445752yea
yeh97135772yeh
yelk115320002yelk
yen66847382yen
yep86638962yep
yerk116222082yerk
yes66250612yes
yet66960692yet
yeuk116015472yeuk
yew96436292yew
yid76640822yid
yin67648732yin
yip87241172yip
yobs96028082yobs
yocks144418372yocks
yodh119916102yodh
yods86531182yods
yoga87418052yoga
yogh116616142yogh
yogi86120422yogi
yoked134821622yoked
yokel124812612yokel
yokes125223022yokes
yolks125412772yolks
yolky15529522yolky
yond86122312yond
yoni77524392yoni
yore76335942yore
your78623432your
yous76230652yous
yowe106728742yowe
yowl105820952yowl
yows106433122yows
yuck136423532yuck
yuks116418022yuks
yum86132822yum
yup86031702yup
zek167323162zek
zoa128529992zoa
zonk175018622zonk
zoo126238912zoo
zouk174413542zouk

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 Limit140843300.32643202.5
3Display Results3303300.0635238.1
 (SQL Overall)1786913300.452395334.1
 
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.