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

408 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
zoos13582880(None) 
boos67955031boos
coos67456491coos
goos57644911goos
loos49051121loos
moos66051301moos
poos65949111poos
woos76238801woos
zoo126238911zoo_
zooks184716941zooks
zoom156722101zoom
zooms164415521zooms
zoon137326981zoon
zoons144919691zoons
abos67734412abos
ados57633512ados
apos65433822apos
avos77227012avos
azons146518252azons
bazoos173212622bazoos
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
gazoos163010222gazoos
goas55239942goas
gobos86219372gobos
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
hoot75752092hoot
hoots84830242hoots
hops97942632hops
hos68364192_hos
hots78349322hots
hows106345602hows
hoys107733932hoys
ions46737852ions
jobs136529432jobs
joes116635892joes
jogs127129332jogs
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
kazoos19259112kazoos
koas85635092koas
kobos115616892kobos
kobs105831082kobs
kois85129392kois
kolos94921212kolos
kook75822602kook
kooks85217262kooks
kops107031292kops
kors85933012kors
kos76944822_kos
koss85224812koss
kotos95717692kotos
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
mons68152252mons
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
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
shoos84226352shoos
sobs64941752sobs
sods54940212sods
solos54830792solos
sols45448162sols
soms66239372soms
sons46049552sons
sook84933392sook
sooks94425452sooks
soon46240502soon
soot45761052soot
soots55536202soots
sops65244562sops
sos37761602_sos
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
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
wazoos18288552wazoos
woes76440662woes
wogs86531402wogs
woks116224902woks
wons74942042wons
woo66949802woo_
wood85329382wood
woods95723032woods
woof106532422woof
woofs114918002woofs
wool76427372wool
wools84421462wools
woops104917522woops
woosh113710732woosh
wops96634152wops
wos66953532_wos
wots76342892wots
wows104633492wows
yobs96028082yobs
yods86531182yods
yoks116223742yoks
yous76230652yous
yows106433122yows
zags146826682zags
zaps156826892zaps
zas126946832z_as
zeds145821802zeds
zees136331892zees
zeks175815062zeks
zeps156019342zeps
zeros144918102zeros
zigs145422792zigs
zins135735002zins
zips155723792zips
zits136030292zits
zoa128529992z_oa
zoea137118422zoea
zoeas145815612zoeas
zoic152316072zoic
zona136321962zona
zone135231082zone
zones145528042zones
zonk175018622zonk
zonks184815172zonks
zooey173914802zooey
zooid15312102zooid
zooids1637092zooids
zooty175415352zooty
zori137722922zori
zoris145320012zoris
zouk174413542zouk
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.0602978183.3
2DLD Change Limit298724080.98630296.1
3Display Results4084080.0934387.1
 (SQL Overall)1786914081.139156884.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.