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

332 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
yow9694529(None) 
bow87051901bow
cow89856711cow
dow76749971dow
how97252431how
jow137639301jow
low66051871low
mow86650351mow
now65950191now
ow58950171_ow
pow87147281pow
row67453671row
sow66554761sow
tow610557361tow
vow96136311vow
wow96643471wow
yaw97145151yaw
yew96436291yew
yo59748551yo_
yob87945271yob
yod77545501yod
yok107335241yok
yom88043441yom
yon67348951yon
you66641821you
yowe106728741yowe
yowl105820951yowl
yows106433121yows
alow75328592alow
avow107816462avow
aw512563402_aw
blow95827192blow
bo410957572bo_
boa56954032boa
bob76755662bob
bod67055542bod
bog67852412bog
boo58163662boo
bop77549482bop
bos57966812bos
bot59680402bot
bowl96827702bowl
bows96242862bows
box1210142342box
boy87753562boy
brow97228442brow
caw86647932caw
chow125820992chow
cob710258752cob
cod69660122cod
cog69552902cog
col59360352col
con510268022con
coo59566362coo
cop711162372cop
cor59960942cor
cos510270392cos
cot510483222cot
cowl97530812cowl
cows97046642cows
cowy126427362cowy
cox1210346782cox
coy810557552coy
coz149345362coz
crow96428132crow
daw77148362daw
dew77139922dew
dhow116614002dhow
do310155252do_
doc66841512doc
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dos48062312dos
dot47573182dot
down86427492down
dows85941052dows
enow77819872enow
eon36052082eon
few95436962few
flow105924922flow
fob86748332fob
foe66350812foe
fog76945562fog
foh98135892foh
fon66352272fon
fop86743702fop
for66952072for
fou66743782fou
fowl105723632fowl
fox136737862fox
foy96044262foy
frow106425052frow
glow85222522glow
go38748742go_
goa47343802goa
gob68950892gob
god57449792god
goo47754772goo
gor47848262gor
gos47155132gos
got49870442got
gowd96519982gowd
gowk125516472gowk
gown85724072gown
gox117137182gox
goy77844552goy
grow86127302grow
haw97153272haw
hew97642722hew
ho510258272ho_
hob87550922hob
hod76852462hod
hoe67562722hoe
hog78049062hog
hon67759382hon
hop87554592hop
hos68364192hos
hot67776052hot
howe106734102howe
howf136127202howf
howk145221962howk
howl107625692howl
hows106345602hows
hoy97447912hoy
ion36051022ion
jaw136237682jaw
jew135129082jew
jo99539602jo_
job128041772job
joe106642352joe
jog117438312jog
jot108259022jot
jowl146120302jowl
jows146632092jows
joy137036362joy
know116115842know
koa76737772koa
kob99442382kob
koi77534742koi
kop97440202kop
kor76538892kor
kos76944822kos
law68656642law
lo28053442lo_
lob57154462lob
log46252682log
loo38359822loo
lop58255312lop
lot38179262lot
lowe75435312lowe
lown76929292lown
lows75843012lows
lox108240962lox
maw87050092maw
meow95117882meow
mew86137732mew
mo49158482mo_
moa57249182moa
mob78651912mob
moc77845082moc
mod69054402mod
mog66949672mog
mol56654592mol
mom78853162mom
mon57561572mon
moo58460512moo
mop76950822mop
mor56855002mor
mos57067122mos
mot57279422mot
mown95424442mown
mows96340832mows
naw66346492naw
new66237092new
no29353242no_
nob58954422nob
nod47549562nod
nog46847312nog
noh66640642noh
nom510450642nom
noo37154042noo
nor38048822nor
nos38859322nos
not39474662not
nows75738232nows
nowt78833752nowt
od39255242_od
oe28473062_oe
of58247772_of
oh57447002_oh
oi29061482_oi
om48553002_om
on28057182_on
ooh67637092ooh
oot311274692oot
op45850162_op
or27354732_or
os211359882_os
owe67041032_owe
owl66228972_owl
own66429702_own
ox98242382_ox
oy58950132_oy
paw87651172paw
pew86442302pew
plow95923232plow
pod66351482pod
poh86740532poh
poi57244662poi
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pot58078432pot
pows95537662pows
pox126140692pox
prow97030382prow
raw67252252raw
rob56754302rob
roc520243252roc
rod47953892rod
roe36861072roe
rom59855632rom
rot37282952rot
rows75941752rows
ryot75528562ryot
saw68255352saw
scow96021422scow
sew66247262sew
show106229182show
slow77729492slow
snow76324792snow
so28855442so_
sob57857942sob
sod46053702sod
sol37256622sol
som59153802som
son37761952son
sop57557862sop
sos37761602sos
sot310384292sot
sou37853692sou
sown75127452sown
sows75342492sows
sox106444192sox
soy67851452soy
stow77325742stow
taw610155452taw
tew66640152tew
to218858982to_
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
too38965422too
top510560682top
tor39261682tor
tot38884772tot
town76928702town
tows78545552tows
towy105325472towy
toy69655192toy
trow78031422trow
two67925832two
vaw95937462vaw
voe67739052voe
vows106626942vows
vox136628152vox
vrow105817472vrow
waw97046382waw
wo510447762wo_
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wows104633492wows
ya510251502y_a
yag76947732yag
yah99046352yah
yak107038562yak
yam87448992yam
yap85949822yap
yar67253832yar
yawl104918972yawl
yawn106219092yawn
yawp125215582yawp
yaws105531212yaws
yay96948712yay
ye57650062y_e
yea66445752yea
yeh97135772yeh
yen66847382yen
yep86638962yep
yes66250612yes
yet66960692yet
yews105323962yews
yid76640822yid
yin67648732yin
yip87241172yip
yobs96028082yobs
yock135924612yock
yodh119916102yodh
yods86531182yods
yoga87418052yoga
yogh116616142yogh
yogi86120422yogi
yoke115626392yoke
yoks116223742yoks
yolk116218992yolk
yond86122312yond
yoni77524392yoni
yore76335942yore
your78623432your
yous76230652yous
yowed1253025182yowed
yowes114926372yowes
yowie114616452yowie
yowls115715432yowls
yuk106725602yuk
yum86132822yum
yup86031702yup
zoa128529992zoa
zoo126238912zoo

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140843320.35639561.8
3Display Results3323320.0635269.8
 (SQL Overall)1786913320.482370728.2
 
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.