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

352 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
woks11622490(None) 
woes76440661woes
wogs86531401wogs
wok106334171wok_
woke115527961woke
wonks124818341wonks
wons74942041wons
woos76238801woos
wops96634151wops
works125621901works
wos66953531wo_s
wots76342891wots
wows104633491wows
yoks116223741yoks
amoks11413552amoks
arks85936872arks
asks85721212asks
auks85525262auks
awoke124912002awoke
awols84713522awols
boas66150832boas
bobs86340642bobs
bocks134526572bocks
bods76244712bods
bogs75742752bogs
bonks116326462bonks
books115729712books
boos67955032boos
bops86037982bops
borks115727702borks
bos57966812bo_s
bosk105825732bosk
bosks115218852bosks
boss65938342boss
bots66453952bots
bows96242862bows
boys96737332boys
cobs87043142cobs
cocks135227162cocks
cods76848102cods
cogs77340032cogs
coke107038382coke
cokes115537192cokes
coky137526822coky
cols66553082cols
conks115525702conks
cons66057692cons
cooks115429142cooks
coos67456492coos
cops86751372cops
corks116028272corks
cors66656442cors
cos510270392co_s
coss66143492coss
cots68054842cots
cows97046642cows
coys97537242coys
daks97130602daks
docks126022312docks
docs75631152docs
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dorks105724442dorks
dors56747602dors
dos48062312do_s
doss56235042doss
dots55647662dots
dows85941052dows
elks85820032elks
eons46638712eons
fobs96034272fobs
foes76543442foes
fogs87035002fogs
folks126017122folks
fons76943892fons
fops96532682fops
forks125324682forks
foss76431642foss
foys105628292foys
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
gooks105422882gooks
goos57644912goos
gos47155132go_s
gowks136011952gowks
goys86328412goys
groks105716122groks
hobs97038982hobs
hocks144925492hocks
hods87239862hods
hoes75755732hoes
hogs87139662hogs
hoke115935932hoke
hokes126231642hokes
holks124720562holks
hols76946292hols
honks125124522honks
hons77350782hons
hooks125027122hooks
hops97942632hops
hos68364192ho_s
hots78349322hots
howks155016852howks
hows106345602hows
hoys107733932hoys
ilks87218572ilks
inks86926502inks
ions46737852ions
irks86220132irks
jobs136529432jobs
jocks185118082jocks
joes116635892joes
jogs127129332jogs
joke155926162joke
jokes165423332jokes
joky186215312joky
joss115925592joss
jots116336142jots
jouks165612342jouks
jows146632092jows
joys146624662joys
koas85635092koas
kobs105831082kobs
kois85129392kois
konks84917112konks
kooks85217262kooks
kops107031292kops
kors85933012kors
kos76944822ko_s
koss85224812koss
leks85427602leks
lobs66441082lobs
locks115126922locks
logs57343112logs
looks95124862looks
loos49051122loos
lops66043352lops
loss45337962loss
lots47652092lots
lows75843012lows
moas65545342moas
mobs85737362mobs
mocks135023822mocks
mocs85834902mocs
mods77945052mods
mogs75439332mogs
moke106234222moke
mokes114631032mokes
mols65948572mols
moms86539482moms
monks116123392monks
mons68152252mons
moos66051302moos
mops85940132mops
mors65950062mors
mos57067122mo_s
mosk105622442mosk
mosks116117002mosks
moss67641032moss
mots66853162mots
mows96340832mows
nobs66436902nobs
nocks115121012nocks
nods55838222nods
noes45845392noes
nogs56534612nogs
noms65636402noms
nooks95420392nooks
nos38859322no_s
nous46136982nous
nows75738232nows
oaks86527902oaks
ods47546212_ods
oes35866192_oes
ohs66232312_ohs
oka76926802_oka
okas85225392_okas
oke75839482_oke
okes84936342_okes
oms56337512_oms
ons36148512_ons
oohs75220692oohs
oops65232672oops
oots46446442oots
ops56641252_ops
ors35750112_ors
os211359882_o_s
owes75137102owes
owls76022932owls
owns76819582owns
pocks135022962pocks
pods76540152pods
pois66539042pois
poke105335362poke
pokes116133012pokes
poky135922152poky
pols66044562pols
poms87037742poms
pons65850602pons
poos65949112poos
pops86340952pops
porks115124142porks
pots66452362pots
pows95537662pows
robs65837872robs
rocks114626412rocks
rocs65533662rocs
rods56442062rods
roes45954132roes
roms67038962roms
rooks95325042rooks
rots46454092rots
rows75941752rows
soaks95220292soaks
sobs64941752sobs
socks114926082socks
sods54940212sods
soke85436262soke
sokes95031422sokes
sols45448162sols
soms66239372soms
sons46049552sons
sooks94425452sooks
sops65244562sops
sos37761602so_s
sots45552442sots
souks94820522souks
sous46947212sous
sows75342492sows
soys75233932soys
suks85927122suks
swobs104910892swobs
swops105913972swops
swots85518422swots
tods56141842tods
toes46956442toes
togs57242432togs
toke86738492toke
tokes95234972tokes
toms68343492toms
tons46553052tons
tops66248122tops
tors46157382tors
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
tsks86410662tsks
twos76718022two_s
voes75432822voes
vows106626942vows
wabs97337232wabs
wacks146626282wacks
wads87343142wads
waes76048602waes
wags86140552wags
wake114935702wake
wakes126633652wakes
walks126218502walks
wanks126124482wanks
wans76452262wans
waps96642082waps
warks127932402warks
wars78659802wars
was68767562w_as
wats77555882wats
wauks125515162wauks
waws106834902waws
ways107737952ways
webs96622122webs
weds86628932weds
weeks125017862weeks
wees76249122wees
weka117013872weka
wekas123911792wekas
wens76337932wens
wets75940292wets
whops135013932whops
whys137011662whys
wicks144619362wicks
wigs84931252wigs
winks125325432winks
wins75949172wins
wis66552332w_is
wiss75630542wiss
wits76044872wits
wo510447762wo__
woad85523942woad
woads94818442woads
woe66651242wo_e
wog76242732wo_g
woken124614972woken
wold85429072wold
wolds95420182wolds
wolf105729562wolf
wolfs116214162wolfs
womb117022232womb
wombs125813342wombs
won66252062wo_n
wonk116125302wonk
wonky154011772wonky
wont75842502wont
wonts87621542wonts
woo66949802wo_o
wood85329382wood
woods95723032woods
woof106532422woof
woofs114918002woofs
wool76427372wool
wools84421462wools
woops104917522woops
woosh113710732woosh
wop87145132wo_p
word89832002word
words95425072words
wore77144672wore
work115528842work
worm96129482worm
worms105320752worms
worn75631752worn
worse86525262worse
worst86330132worst
wort76654752wort
worts88631182worts
wost76544362wost
wot610467482wo_t
wove105624312wove
wow96643472wo_w
wuss75219332wuss
wyes105727502wyes
wyns105717032wyns
yaks116025202yaks
yobs96028082yobs
yocks144418372yocks
yods86531182yods
yok107335242yok_
yoke115626392yoke
yokes125223022yokes
yolks125412772yolks
yous76230652yous
yows106433122yows
yuks116418022yuks
zeks175815062zeks
zonks184815172zonks
zooks184716942zooks
zoos135828802zoos
zouks184410502zouks

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.0961861364.6
2DLD Change Limit298723520.81036879.0
3Display Results3523520.0804400.0
 (SQL Overall)1786913520.986181228.2
 
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.