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

498 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
wons7494204(None) 
cons66057691cons
dons56048701dons
eons46638711eons
fons76943891fons
hons77350781hons
ions46737851ions
mons68152251mons
ons36148511_ons
owns76819581owns
pons65850601pons
sons46049551sons
tons46553051tons
wans76452261wans
wens76337931wens
wins75949171wins
woes76440661woes
wogs86531401wogs
woks116224901woks
won66252061won_
wonk116125301wonk
wonks124818341wonks
wont75842501wont
wonts87621541wonts
woos76238801woos
wops96634151wops
wos66953531wo_s
wots76342891wots
wows104633491wows
wyns105717031wyns
aeons57624652aeons
agons66423782agons
ains46158882ains
awns75324432awns
awols84713522awols
axons125517932axons
azons146518252azons
bans66555132bans
bens65945702bens
bins66548252bins
boas66150832boas
bobs86340652bobs
bods76244712bods
bogs75742752bogs
bond75334362bond
bonds86126842bonds
bone65949322bone
bones76446532bones
bong75633412bong
bongs87828422bongs
bonk105531712bonk
bonks116326462bonks
bonus75324322bonus
bony96732082bony
boons75031912boons
boos67955032boos
bops86037982bops
bos57966812bo_s
boss65938342boss
bots66453952bots
bows96242862bows
boys96737332boys
buns66243722buns
cans65050842cans
cions75222852cions
clons75228132clons
cobs87043142cobs
cods76848102cods
cogs77340032cogs
coins75834552coins
cols66553082cols
con510268022con_
cone67256962cone
cones76457422cones
coni65534802coni
conk106531442conk
conks115525702conks
conn66229132conn
conns75024232conns
conus76726532conus
cony96537832cony
coons76737282coons
coos67456492coos
cops86751372cops
corns76034762corns
cors66656442cors
cos510270392co_s
coss66143492coss
cots68054842cots
cows97046642cows
coys97537242coys
dans56748142dans
dens55945072dens
dins56652042dins
docs75631152docs
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
don46757652don_
dona55529632dona
donas65926472donas
done55747912done
dong66031652dong
dongs76525812dongs
donsy96414682donsy
dors56747602dors
dos48062312do_s
doss56235042doss
dots55647662dots
downs94918572downs
dows85941052dows
duns55140432duns
ebons74316092ebons
ens37245922_ens
eon36052082eon_
erns45428222erns
exons125813342exons
fans76247362fans
fens76139762fens
fins75849092fins
fobs96034272fobs
foes76543442foes
fogs87035002fogs
fohns117310782fohns
foins85523382foins
fon66352272fon_
fond86330952fond
fonds95824822fonds
font77143752font
fonts86124752fonts
fops96532682fops
foss76431642foss
foys105628292foys
frons86124042frons
funs75235732funs
gens55740072gens
gins55543952gins
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
gone55639042gone
gong66827192gong
gongs74921612gongs
goons65326772goons
goos57644912goos
gos47155132go_s
gowns95115102gowns
goys86328412goys
guns55533482guns
hens75642572hens
hins76447992hins
hobs97038982hobs
hods87239862hods
hoes75755732hoes
hogs87139662hogs
hols76946292hols
hon67759382hon_
hone77549322hone
hones88144492hones
hong85833952hong
hongs95126202hongs
honk116931192honk
honks125124522honks
hops97942632hops
horns86125332horns
hos68364192ho_s
hots78349322hots
hows106345602hows
hoys107733932hoys
huns76136932huns
icons76516492icons
ikons96311012ikons
inns46920932inns
ins35945602_ins
ion36051022ion_
irons55324132irons
jins115635012jins
jobs136529432jobs
joes116635892joes
jogs127129332jogs
johns15398712johns
joins125818412joins
jones125028182jones
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
kaons95014852kaons
kens85435232kens
kins85747902kins
koans95818622koans
koas85635092koas
kobs105831082kobs
kois85129392kois
konk79320612konk
konks84917112konks
kops107031292kops
kors85933012kors
kos76944822ko_s
koss85224812koss
lens46146492lens
lins47059052lins
lions55923212lions
loans56026462loans
lobs66441082lobs
logs57343112logs
loins56728422loins
lone45849132lone
long56933342long
longs65527062longs
loons55731722loons
loos49051122loos
lops66043352lops
loss45337962loss
lots47652092lots
lows75843012lows
mans66354532mans
moans74624362moans
moas65545342moas
mobs85737372mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mols65948572mols
moms86539482moms
mon57561572mon_
monas74732152monas
monk105928512monk
monks116123392monks
mono66036712mono
monos75930862monos
mony96830002mony
moons75331002moons
moos66051302moos
mops85940132mops
morns75527442morns
mors65950062mors
mos57067122mo_s
moss67641032moss
mots66853162mots
mows96340832mows
muns65535912muns
muons75816172muons
nans46139392nans
neons55818682neons
nobs66436902nobs
nods55838222nods
noes45845392noes
nogs56534612nogs
noms65636402noms
nona46929062nona
nonas55126652nonas
none45743172none
nones55639132nones
noons54125282noons
nos38859322no_s
nouns56717312nouns
nous46136982nous
nows75738232nows
nuns45228232nuns
ods47546212_ods
oes35866192_oes
ohs66232312_ohs
oms56337512_oms
on28057182_on_
one37050912_one
ones46146532_ones
ono36838032_ono
onos46229002_onos
onus45826812_onus
oohs75220692oohs
oops65232672oops
oots46446442oots
ops56641252_ops
ors35750112_ors
os211359882_o_s
owes75137102owes
owls76022932owls
own66429702own_
pans65855722pans
pens65649642pens
peons75327182peons
phons105221142phons
pins65558452pins
pions75826392pions
pods76540152pods
pois66539042pois
pols66044562pols
poms87037742poms
pond75530492pond
ponds85323402ponds
pone65747532pone
pones74547042pones
pong76231142pong
pongs85526342pongs
pony96434052pony
poons75430972poons
poos65949112poos
pops86340952pops
porns75527342porns
pots66452362pots
pows95537662pows
puns66641482puns
rins46153192rins
roans54926442roans
robs65837872robs
rocs65533662rocs
rods56442062rods
roes45954132roes
roms67038962roms
rots46454092rots
rows75941752rows
runs46438072runs
sans45153352sans
sins46755272sins
sobs64941752sobs
sods54940212sods
sols45448162sols
soms66239372soms
son37761952son_
sone46649982sone
sones55444142sones
song55133672song
songs67725552songs
sonsy86416372sonsy
sops65244562sops
sorns55028412sorns
sos37761602so_s
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
suns45841902suns
swans84625012swans
swobs104910892swobs
swoons94511142swoons
swops105913972swops
swots85518422swots
swouns9358242swouns
tans46154812tans
tens45647412tens
tins45251302tins
tods56141842tods
toes46956442toes
togs57242432togs
toms68343492toms
ton310265102ton_
tone46953742tone
tones56048662tones
tong56434352tong
tongs65928462tongs
tonus56324302tonus
tony75635152tony
toons55027532toons
tops66248122tops
tors46157382tors
toss45637972toss
tots46654122tots
towns86018882towns
tows78545552tows
toys78036342toys
tuns45138662tuns
twins85118982twins
twos76718022two_s
udons65411462udons
uns35936752_uns
urns46323892urns
vans76236722vans
voes75432822voes
vows106626942vows
wabs97337232wabs
wads87343142wads
waes76048602waes
wagons103911212wagons
wags86140552wags
wains86930862wains
wan66761932wan_
wand85833872wand
wands96425482wands
wane76344712wane
wanes85040882wanes
wank115632502wank
wanks126124482wanks
want76156162want
wants87932212wants
wany106432352wany
waps96642082waps
warns87231002warns
wars78659802wars
was68767562w_as
wats77555882wats
waws106834902waws
ways107737952ways
weans85326742weans
webs96622122webs
weds86628932weds
weens85224052weens
wees76249122wees
wen66249602wen_
wend85330452wend
wends95822812wends
went76051872went
wets75940292wets
whens114618762whens
whins114922332whins
whops135013932whops
whys137011662whys
wigs84931252wigs
win66456292win_
wind85533852wind
winds95425602winds
wine74953422wine
wines85546862wines
wing86339222wing
wings95727242wings
wink116435022wink
winks125325432winks
wino75933612wino
winos84625042winos
winy107034322winy
wis66552332w_is
wiss75630542wiss
wits76044872wits
wo510447762wo__
woad85523942woad
woads94818442woads
woe66651242wo_e
wog76242732wo_g
wok106334172wo_k
woke115527962woke
wold85429072wold
wolds95420182wolds
wolf105729562wolf
wolfs116214162wolfs
womans114613652womans
womb117022232womb
wombs125813342wombs
wonky154011772wonky
woo66949802wo_o
wood85329382wood
woods95723032woods
woof106532422woof
woofs114918002woofs
wool76427372wool
wools84421462wools
woops104917522woops
woosh113710732woosh
wop87145132wo_p
word89832002word
words95425072words
wore77144672wore
work115528842work
works125621902works
worm96129482worm
worms105320752worms
worn75631752worn
worse86525262worse
worst86330132worst
wort76654752wort
worts88631182worts
wost76544362wost
wot610467482wo_t
wound94414212wound
wounds103811632wounds
wove105624312wove
wovens12449832wovens
wow96643472wo_w
wrens85016242wrens
wrong94712322wrong
wrongs10338932wrongs
wuss75219332wuss
wyes105727502wyes
wyn95921442wyn_
wynd116114462wynd
wynds126310372wynds
wynn105811292wynn
wynns11517472wynns
yens75832262yens
yins75335122yins
yobs96028082yobs
yods86531182yods
yoks116223742yoks
yon67348952yon_
yond86122312yond
yoni77524392yoni
yonis85020822yonis
yous76230652yous
yows106433122yows
zins135735002zins
zona136321962zona
zone135231082zone
zones145528042zones
zonk175018622zonk
zonks184815172zonks
zoons144919692zoons
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 Limit298724980.93631914.5
3Display Results4984980.1104527.3
 (SQL Overall)1786914981.109161128.0
 
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.