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

468 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
woos7623880(None) 
boos67955031boos
coos67456491coos
goos57644911goos
loos49051121loos
moos66051301moos
poos65949111poos
woes76440661woes
wogs86531401wogs
woks116224901woks
wons74942041wons
woo66949801woo_
wood85329381wood
woods95723031woods
woof106532421woof
woofs114918001woofs
wool76427371wool
wools84421461wools
woops104917521woops
woosh113710731woosh
wops96634151wops
wos66953531w_os
wots76342891wots
wows104633491wows
zoos135828801zoos
abos67734412abos
ados57633512ados
apos65433822apos
avos77227012avos
awols84713522awols
bios66335322bios
boas66150832boas
bobs86340652bobs
bods76244712bods
bogs75742752bogs
bohos105618252bohos
bolos75531372bolos
boo58163662boo_
boob85932582boob
boobs96221992boobs
book106836332book
books115729712books
boom87435672boom
booms95427122booms
boon67142172boon
boons75031912boons
boor66130682boor
boors74325012boors
boost75132472boost
boot67759372boot
boots75837972boots
bops86037982bops
bos57966812_bos
boss65938342boss
bots66453952bots
bows96242862bows
boyos105418282boyos
boys96737332boys
bozos165216862bozos
broos75126412broos
bros65635662bros
cobs87043142cobs
cocos95624692cocos
cods76848102cods
cogs77340032cogs
cohos105921852cohos
cols66553082cols
cons66057692cons
coo59566362coo_
coof96643272coof
coofs105924712coofs
cook107236932cook
cooks115429142cooks
cool66940492cool
cools75632632cools
coon67248942coon
coons76737282coons
coop87238652coop
coops96229642coops
coot67860382coot
coots75636842coots
cops86751372cops
cors66656442cors
cos510270392_cos
coss66143492coss
cots68054842cots
cows97046642cows
coys97537242coys
docs75631152docs
dodos75819392dodos
does56554472does
dogs66440152dogs
dojos135111792dojos
dols56943052dols
doms76239572doms
dons56048702dons
doom76430072doom
dooms85321342dooms
door56928512door
doors65022132doors
dors56747602dors
dos48062312_dos
doss56235042doss
dots55647662dots
dows85941052dows
duos56728132duos
egos55821652egos
eons46638712eons
epos66723732epos
eros45238452eros
fobs96034272fobs
foes76543442foes
fogs87035002fogs
fons76943892fons
food86830572food
foods95924162foods
fool75330592fool
fools86824202fools
foot76248012foot
foots85528282foots
fops96532682fops
foss76431642foss
foys105628292foys
goas55239942goas
gobos86219382gobos
gobs76935572gobs
gods65438042gods
goes55644092goes
gogos77516522gogos
goo47754772goo_
good66531802good
goods75124482goods
goof85436872goof
goofs94821002goofs
gook96429602gook
gooks105422882gooks
goon57236172goon
goons65326772goons
goop75829482goop
goops86620962goops
goose65925902goose
goosy96018882goosy
gos47155132_gos
goys86328412goys
hobos106321352hobos
hobs97038982hobs
hods87239862hods
hoes75755732hoes
hogs87139662hogs
hols76946292hols
homos105921782homos
hons77350782hons
hood85132332hood
hoods95124082hoods
hoof106036582hoof
hoofs115721042hoofs
hook116133282hook
hooks125027122hooks
hoop96129982hoop
hoops105621072hoops
hoot75752102hoot
hoots84830252hoots
hops97942632hops
hos68364192_hos
hots78349332hots
hows106345602hows
hoys107733932hoys
ions46737852ions
jobs136529432jobs
joes116635892joes
jogs127129332jogs
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
koas85635092koas
kobos115616892kobos
kobs105831082kobs
kois85129402kois
kolos94921212kolos
kook75822602kook
kooks85217262kooks
kops107031292kops
kors85933012kors
kos76944822_kos
koss85224812koss
kotos95717702kotos
lobos75921842lobos
lobs66441082lobs
locos75822602locos
logos67225332logos
logs57343112logs
loo38359822loo_
loof78141052loof
loofs85623782loofs
look87333472look
looks95124862looks
loom67035052loom
looms75124642looms
loon47344792loon
loons55731722loons
loop67835012loop
loops75723962loops
loose56627682loose
loot46955822loot
loots55431422loots
lops66043352lops
loss45337962loss
lotos54724632lotos
lots47652092lots
lows75843012lows
mhos95517772mhos
moas65545342moas
mobs85737372mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mojos145314462mojos
mols65948572mols
moms86539482moms
monos75930862monos
mons68152262mons
moo58460512moo_
mood76332062mood
moods85224622moods
mool67533862mool
mools76027172mools
moon67140812moon
moons75331002moons
moor66628552moor
moors74923142moors
moose76327192moose
moot67653622moot
moots75831662moots
mops85940132mops
mors65950062mors
mos57067122_mos
moss67641032moss
mots66853162mots
mows96340832mows
mozos165516332mozos
naos47429732naos
nobs66436902nobs
nods55838222nods
noes45845392noes
nogs56534612nogs
nolos54423352nolos
nomos75919742nomos
noms65636402noms
noo37154042noo_
nook85728492nook
nooks95420392nooks
noon47134622noon
noons54125282noons
noose55624062noose
nos38859322_nos
nous46136982nous
nows75738232nows
ods47546212_ods
oes35866192_oes
ohs66232312_ohs
oms56337512_oms
onos46229002onos
ons36148512_ons
ooh67637092_ooh
oohs75220692oohs
oops65232672oops
oot311274692_oot
oots46446442oots
ops56641252_ops
ors35750112_ors
os211359882__os
owes75137102owes
owls76022932owls
owns76819582owns
pods76540152pods
pois66539042pois
polos76129912polos
pols66044562pols
pomos95321582pomos
poms87037742poms
pons65850602pons
poo57757112poo_
pood75934322pood
poods85124752poods
poof95541662poof
poofs105222792poofs
pooh96027382pooh
poohs103915712poohs
pool65835952pool
pools74427702pools
poon67341262poon
poons75430972poons
poop86532812poop
poops94422412poops
poor65630222poor
pops86340952pops
pots66452362pots
pows95537662pows
pros65742782pros
rhos76319062rhos
robs65837872robs
rocs65533662rocs
rods56442062rods
roes45954132roes
roms67038962roms
rood56733002rood
roods65125282roods
roof75738832roof
roofs85321152roofs
rook85532032rook
rooks95325042rooks
room66235082room
rooms75324682rooms
roose56127092roose
roost55730932roost
root45655922root
roots55933672roots
rotos56027882rotos
rots46454092rots
rows75941752rows
shoos84226362shoos
sobs64941752sobs
sods54940212sods
solos54830792solos
sols45448162sols
soms66239372soms
sons46049552sons
sook84933392sook
sooks94425452sooks
soon46240502soon
soot45761062soot
soots55536212soots
sops65244562sops
sos37761602_sos
sots45552452sots
sous46947212sous
sows75342492sows
soys75233932soys
swobs104910892swobs
swoon85014782swoon
swoons94511142swoons
swoop105213432swoop
swoops114910922swoops
swoosh12195212swoosh
swops105913972swops
swots85518432swots
taos45541002taos
tods56141842tods
toes46956442toes
togs57242432togs
toms68343492toms
tons46553052tons
too38965422too_
took86531072took
tool46735682tool
tools55325242tools
toom66532932toom
toon47740632toon
toons55027532toons
toot45958882toot
toots55331872toots
topos75726392topos
tops66248122tops
toros54336192toros
tors46157382tors
toss45637972toss
tots46654122tots
tows78545552tows
toyos87519142toyos
toys78036342toys
twos76718022twos
udos56619902udos
voes75432822voes
vows106626942vows
wabs97337232wabs
wads87343142wads
waes76048602waes
wags86140552wags
wahoos122310592wahoos
wans76452272wans
waps96642082waps
wars78659802wars
was68767562w_as
wats77555882wats
waws106834902waws
ways107737952ways
wazoos18288552wazoos
webs96622122webs
weds86628932weds
wees76249122wees
wens76337932wens
wets75940292wets
who95526772who_
whoa106615202whoa
whom127018182whom
whoof144612692whoof
whoofs15457242whoofs
whoop134211442whoop
whoops14487862whoops
whoosh15244352whoosh
whop125520922whop
whops135013932whops
whose114914532whose
whoso11509222whoso
whys137011662whys
wigs84931252wigs
winos84625042winos
wins75949172wins
wis66552332w_is
wiss75630542wiss
wits76044872wits
wo510447762w_o_
woad85523942woad
woads94818442woads
woe66651242w_oe
wog76242732w_og
wok106334172w_ok
woke115527962woke
wold85429072wold
wolds95420182wolds
wolf105729562wolf
wolfs116214162wolfs
womb117022232womb
wombs125813342wombs
won66252062w_on
wonk116125302wonk
wonks124818342wonks
wont75842502wont
wonts87621542wonts
woodsy13505922woodsy
woody125116882woody
wooed94419872wooed
wooer84316692wooer
wooers93712442wooers
wooly114417672wooly
woozy204410602woozy
wop87145132w_op
word89832002word
words95425072words
wore77144672wore
work115528842work
works125621902works
worm96129482worm
worms105320762worms
worn75631752worn
worse86525262worse
worst86330132worst
wort76654752wort
worts88631182worts
wost76544362wost
wot610467482w_ot
wove105624312wove
wow96643472w_ow
wuss75219332wuss
wyes105727502wyes
wyns105717032wyns
yobs96028082yobs
yods86531182yods
yoks116223742yoks
yous76230652yous
yows106433122yows
zoo126238912zoo_
zooks184716942zooks
zoom156722102zoom
zooms164415522zooms
zoon137326982zoon
zoons144919692zoons

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 Limit298724680.87634100.5
3Display Results4684680.1064415.1
 (SQL Overall)1786914681.058168895.1
 
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.