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

432 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
gods6543804(None) 
bods76244711bods
cods76848101cods
gads67843381gads
geds66730811geds
gids65933731gids
goads77022851goads
goas55239941goas
gobs76935571gobs
god57449791god_
goes55644091goes
golds75421311golds
goods75124481goods
goos57644911goos
gos47155131go_s
gowds105814041gowds
goys86328411goys
hods87239861hods
mods77945051mods
nods55838221nods
ods47546211_ods
pods76540151pods
rods56442061rods
sods54940211sods
tods56141841tods
yods86531181yods
adds67622452adds
ados57633512ados
ads49755732_ads
agons66423782agons
aids57846352aids
ands57833612ands
apods86316342apods
bads77048862bads
beds75937782beds
bids75838422bids
boas66150832boas
bobs86340642bobs
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
eds46638922_eds
egads74610922egads
egos55821652ego_s
elds56324852elds
ends56528522ends
eons46638712eons
fads86939872fads
feds85234312feds
feods99516852feods
fids87034732fids
fobs96034272fobs
foes76543442foes
fogs87035002fogs
folds95221692folds
fonds95824822fonds
fons76943892fons
foods95924162foods
fops96532682fops
fords95328182fords
foss76431642foss
foys105628292foys
fuds86528562fuds
gabs76740422gabs
gad57556652gad_
gadi66329722gadi
gadis74825292gadis
gaes56348032gaes
gags66441062gags
gals57946502gals
gams76648882gams
gaols66717572gaols
gaps76042972gaps
gars55750742gars
gas48870252g_as
gats56753442gats
gauds75717722gauds
gays87338022gays
ged57044532ged_
gees55647882gees
gelds75118342gelds
gels56836102gels
gems75329112gems
gens55740072gens
geode7412592geode
geodes8412152geodes
geoids8369842geoids
gets55442482gets
ghis85020162ghis
gibs75529262gibs
gid57047262gid_
gies55641422gies
gigs66631182gigs
gilds75417522gilds
gins55543952gins
gips75632922gips
girds74816992girds
gits55744592gits
glads75620612glads
gleds75417892gleds
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glows95518032glows
gnus56518002gnus
go38748742go__
goa47343802go_a
goad66830982goad
goal55829302goal
goals65521292goals
goat56250832goat
goats65527302goats
gob68950892go_b
gobo76126892gobo
gobos86219372gobos
goby106021082goby
godet7530042godet
godets8410932godets
godly104913292godly
godson857382godson
goer56827102goer
goers65520252goers
gogo69722832gogo
gogos77516522gogos
gold65430162gold
golf85731182golf
golfs95616102golfs
gonads84511732gonads
gone55639042gone
gong66827192gong
gongs74921612gongs
goo47754772go_o
good66531802good
goody105620392goody
goof85436872goof
goofs94821002goofs
gook96429602gook
gooks105422882gooks
goon57236172goon
goons65326772goons
goop75829482goop
goops86620962goops
goose65925902goose
goosy96018882goosy
gor47848262go_r
gore55744962gore
gores65740372gores
gorm75529392gorm
gorms85619592gorms
gorp75625902gorp
gorps85316992gorps
gorse65926812gorse
gorsy95915782gorsy
gory86129662gory
gosh86123422gosh
got49870442go_t
goth86825082goth
goths96513002goths
gourds8108252gourds
gout56646002gout
gouts64826172gouts
gowd96519982gowd
gowk125516472gowk
gowks136011952gowks
gown85724072gown
gowns95115102gowns
gox117137182go_x
goxes135018262goxes
goy77844552go_y
grads75625752grads
grids75321392grids
grody103412062grody
grogs76319412grogs
groks105716122groks
gross65421692gross
grots65025852grots
grows95523922grows
gude65423332gude
gudes74520812gudes
guids75516152guids
guls55930852guls
gums75030942gums
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
gyms107514592gyms
gyps105115022gyps
hobs97038982hobs
hod76852462hod_
hoes75755732hoes
hogs87139662hogs
holds94623242holds
hols76946292hols
hons77350782hons
hoods95124082hoods
hops97942632hops
hos68364192ho_s
hots78349322hots
hows106345602hows
hoys107733932hoys
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
mids76541772mids
moas65545342moas
mobs85737362mobs
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
pads76742952pads
pagods105310192pagods
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
sobs64941752sobs
sod46053702sod_
soda56329382soda
sodas64123542sodas
sols45448162sols
soms66239372soms
sons46049552sons
sops65244562sops
sords64527802sords
sos37761602so_s
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
suds56135292suds
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
yids85224952yids
yobs96028082yobs
yod77545502yod_
yodh119916102yodh
yodhs12669012yodhs
yoks116223742yoks
yous76230652yous
yows106433122yows
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.0762351197.4
2DLD Change Limit298724320.95331345.2
3Display Results4324320.0964500.0
 (SQL Overall)1786914321.125158836.4
 
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.