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

364 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
yods8653118(None) 
bods76244711bods
cods76848101cods
gods65438041gods
hods87239861hods
mods77945051mods
nods55838221nods
ods47546211_ods
pods76540151pods
rods56442061rods
sods54940211sods
tods56141841tods
yids85224951yids
yobs96028081yobs
yod77545501yod_
yodh119916101yodh
yodhs12669011yodhs
yoks116223741yoks
yous76230651yous
yows106433121yows
adds67622452adds
ados57633512ados
ads49755732_ads
aids57846352aids
ands57833612ands
apods86316342apods
bads77048862bads
beds75937782beds
bids75838432bids
boas66150832boas
bobs86340652bobs
bod67055542bod_
bode75838752bode
bodes84935102bodes
body107425672body
bogs75742752bogs
bolds85825282bolds
bonds86126842bonds
boos67955032boos
bops86037982bops
bos57966812bo_s
boss65938342boss
bots66453952bots
bows96242862bows
boys96737332boys
buds75235172buds
cads76144522cads
clods85320862clods
cobs87043142cobs
cod69660122cod_
coda77029342coda
codas84724242codas
code77347732code
codes86247292codes
coeds85920162coeds
cogs77340032cogs
colds85726972colds
cols66553082cols
cons66057692cons
coos67456492coos
cops86751372cops
cords86030622cords
cors66656442cors
cos510270392co_s
coss66143492coss
cots68054842cots
cows97046642cows
coys97537242coys
cuds76730472cuds
dads67442772dads
docs75631152docs
dodo66024912dodo
dodos75819392dodos
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dors56747602dors
dos48062312do_s
doss56235042doss
dots55647662dots
dows85941052dows
duds65530142duds
dyads10549972dyads
eds46638922_eds
elds56324852elds
ends56528522ends
eons46638712eons
fads86939872fads
feds85234312feds
feods99516852feods
fids87034732fids
fobs96034272fobs
foes76543442foes
fogs87035002fogs
folds95221692folds
fonds95824822fonds
fons76943892fons
foods95924162foods
fops96532682fops
fords95328182fords
foss76431642foss
foys105628292foys
fuds86528562fuds
gads67843382gads
geds66730812geds
gids65933732gids
goads77022852goads
goas55239942goas
gobs76935572gobs
god57449792god_
goes55644092goes
golds75421312golds
goods75124482goods
goos57644912goos
gos47155132go_s
gowds105814042gowds
goys86328412goys
hobs97038982hobs
hod76852462hod_
hoes75755732hoes
hogs87139662hogs
holds94623242holds
hols76946292hols
hons77350782hons
hoods95124082hoods
hops97942632hops
hos68364192ho_s
hots78349322hots
hows106345602hows
hoys107733932hoys
hyoids1377672hyoids
ids47535462_ids
ions46737852ions
jobs136529432jobs
joes116635892joes
jogs127129332jogs
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
kids96029632kids
koas85635092koas
kobs105831082kobs
kois85129392kois
kops107031292kops
kors85933012kors
kos76944822ko_s
koss85224812koss
lads56549132lads
lids56336452lids
loads65323372loads
lobs66441082lobs
lode56240112lode
lodes66436912lodes
logs57343112logs
loids66220702loids
loos49051122loos
lops66043352lops
lords64923502lords
loss45337962loss
lots47652092lots
lows75843012lows
mads76845362mads
meds75735362meds
mids76541782mids
moas65545342moas
mobs85737372mobs
mocs85834902mocs
mod69054402mod_
mode75840302mode
modes85537412modes
modi76826312modi
modus85417202modus
mogs75439332mogs
molds85324832molds
mols65948572mols
moms86539482moms
mons68152252mons
moods85224622moods
moos66051302moos
mops85940132mops
mors65950062mors
mos57067122mo_s
moss67641032moss
mots66853162mots
mows96340832mows
muds75530652muds
nobs66436902nobs
nod47549562nod_
node513036882node
nodes64633492nodes
nodi56626742nodi
nodus66315992nodus
noes45845392noes
nogs56534612nogs
noms65636402noms
nos38859322no_s
nous46136982nous
nows75738232nows
od39255242_od_
oda48133042_oda
odas57230262_odas
odd57725452_odd
odds68919922odds
ode47446582_ode
odes57243242_odes
oes35866192_oes
ohs66232312_ohs
olds55926572olds
oms56337512_oms
ons36148512_ons
oohs75220692oohs
oops65232672oops
oots46446442oots
ops56641252_ops
ors35750112_ors
os211359882_o_s
ouds56430102ouds
oyes74940132oyes
pads76742952pads
peds75835242peds
plods85719292plods
pod66351482pod_
pois66539042pois
pols66044562pols
poms87037742poms
ponds85323402ponds
pons65850602pons
poods85124752poods
poos65949112poos
pops86340952pops
pots66452362pots
pows95537662pows
prods85523552prods
puds75630512puds
quods154610222quods
rads56046602rads
reds56042862reds
rids56539542rids
roads66523612roads
robs65837872robs
rocs65533662rocs
rod47953892rod_
rode55844302rode
rodes614039082rodes
roes45954132roes
roms67038962roms
roods65125282roods
rots46454092rots
rows75941752rows
rynds9569972rynds
ryots85313782ryots
sobs64941752sobs
sod46053702sod_
soda56329382soda
sodas64123542sodas
sols45448162sols
soms66239372soms
sons46049552sons
sops65244562sops
sords64527802sords
sos37761602so_s
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
suds56135292suds
synods1077952synods
tads57143942tads
teds54932572teds
toads65621062toads
tod49457072tod_
tody86327212tody
toes46956442toes
togs57242432togs
toms68343492toms
tons46553052tons
tops66248122tops
tors46157382tors
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
udos56619902udos
urds55922422urds
vids85627532vids
voes75432822voes
voids95414672voids
vows106626942vows
wads87343142wads
weds86628932weds
woads94818442woads
woes76440662woes
wogs86531402wogs
woks116224902woks
wolds95420182wolds
wons74942042wons
woods95723032woods
woos76238802woos
wops96634152wops
words95425072words
wos66953532wo_s
wots76342892wots
wows104633492wows
wynds126310372wynds
yags86632292yags
yaks116025202yaks
yams95330732yams
yaps95933522yaps
yards95324612yards
yauds95013222yauds
yaws105531212yaws
yays105728912yays
yeas78638422yeas
yens75832262yens
yeps95924402yeps
yes66250612y_es
yews105323962yews
yid76640822yid_
yins75335122yins
yips95226692yips
yirds96612512yirds
yo59748552yo__
yob87945272yo_b
yock135924612yock
yocks144418372yocks
yodel94714082yodel
yodels104610072yodels
yodle94515042yodle
yodles103714332yodles
yoga87418052yoga
yogas96615602yogas
yogh116616142yogh
yoghs125410592yoghs
yogi86120422yogi
yogis95617742yogis
yok107335242yo_k
yoke115626392yoke
yokes125223022yokes
yolk116218992yolk
yolks125412772yolks
yom88043442yo_m
yon67348952yo_n
yond86122312yond
yoni77524392yoni
yonis85020822yonis
yore76335942yore
yores85031322yores
you66641822yo_u
your78623432your
yours85217872yours
youse85322232youse
yow96945292yo_w
yowe106728742yowe
yowes114926372yowes
yowl105820952yowl
yowls115715432yowls
yuks116418022yuks
yups96121602yups
ywis105313102ywis
zeds145821802zeds
zoos135828802zoos

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.0632836365.1
2DLD Change Limit298723641.12326600.2
3Display Results3643640.1901915.8
 (SQL Overall)1786913641.376129862.6
 
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.