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

354 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
joy13703636(None) 
boy87753561boy
coy810557551coy
foy96044261foy
goy77844551goy
hoy97447911hoy
jay136242671jay
jo99539601jo_
job128041771job
joe106642351joe
joey145719331joey
jog117438311jog
joky186215311joky
jot108259021jot
jow137639301jow
joys146624661joys
oy58950131_oy
soy67851451soy
toy69655191toy
aby810238062aby
ahoy101919182ahoy
any68440482any
ay511773892_ay
bay89661642bay
bey86645422bey
bo410957572bo_
boa56954032boa
bob76755662bob
bod67055542bod
body107425672body
bog67852412bog
bogy106426192bogy
bony96732082bony
boo58163662boo
bop77549482bop
bos57966812bos
bot59680402bot
bow87051902bow
box1210142342box
boxy166420732boxy
boyo96923842boyo
boys96737332boys
buoy95921782buoy
buy86436542buy
by77529232_by
cay87155982cay
cloy96623832cloy
cob710258752cob
cod69660122cod
cog69552902cog
coky137526822coky
col59360352col
coly96940532coly
con510268022con
cony96537832cony
coo59566362coo
cop711162372cop
copy116229802copy
cor59960942cor
cory96941512cory
cos510270392cos
cosy97232702cosy
cot510483222cot
cow89856712cow
cowy126427362cowy
cox1210346782cox
coys97537242coys
coz149345362coz
cozy185823802cozy
cry89726242cry
day76254112day
dey77243372dey
do310155252do_
doby106022162doby
doc66841512doc
doe47361952doe
dog57449752dog
dogy96126492dogy
dol47150652dol
dom69752442dom
don46757652don
dopy106224152dopy
dor47253922dor
dory85836232dory
dos48062312dos
dot47573182dot
doty86128222doty
dow76749972dow
doxy156419952doxy
dozy175920322dozy
dry76526032dry
enjoy1545962enjoy
eon36052082eon
fay97454862fay
fey95940882fey
fly97124952fly
fob86748332fob
foe66350812foe
fog76945562fog
fogy115923182fogy
foh98135892foh
fon66352272fon
fop86743702fop
for66952072for
fou66743782fou
fox136737862fox
foxy176517752foxy
foys105628292foys
fozy197017162fozy
fry96226502fry
gay76856492gay
gey75738302gey
go38748742go_
goa47343802goa
gob68950892gob
goby106021082goby
god57449792god
goo47754772goo
gor47848262gor
gory86129662gory
gos47155132gos
got49870442got
gox117137182gox
goys86328412goys
guy75728942guy
hay97358772hay
hey96741062hey
ho510258272ho_
hob87550922hob
hod76852462hod
hoe67562722hoe
hog78049062hog
holy106333432holy
homy126623222homy
hon67759382hon
hop87554592hop
hos68364192hos
hot67776052hot
how97252432how
hoya107418372hoya
hoys107733932hoys
icy86322122icy
ion36051022ion
ivy96317442ivy
jab128444112jab
jag116542712jag
jam126942522jam
jar107646152jar
jaw136237682jaw
jays146328342jays
jee106648642jee
jeon116821442jeon
jet106754822jet
jeu105532072jeu
jew135129082jew
jib125835962jib
jig115633512jig
jin106443932jin
jivy176213112jivy
jobs136529432jobs
jock176522642jock
joes116635892joes
joeys15518042joeys
jogs127129332jogs
john145512902john
join116724832join
joke155926162joke
jokey195014692jokey
jole117233822jole
jolly154517512jolly
jolt116639122jolt
jolty155713032jolty
josh145117612josh
joss115925592joss
jota116423622jota
jots116336142jots
jotty155012602jotty
jouk156015992jouk
jowl146120302jowl
jowly186410902jowly
jows146632092jows
joyed164811832joyed
jug115529542jug
jun105932062jun
jury146719592jury
jus106930222jus
jut105944012jut
kay106745542kay
key105833332key
koa76737772koa
kob99442382kob
koi77534742koi
kop97440202kop
kor76538892kor
kos76944822kos
lay68865352lay
ley66246812ley
lo28053442lo_
lob57154462lob
log46252682log
logy87025782logy
loo38359822loo
lop58255312lop
lory75931712lory
lot38179262lot
low66051872low
lox108240962lox
may88757622may
mo49158482mo_
moa57249182moa
mob78651912mob
moc77845082moc
mod69054402mod
mog66949672mog
mol56654592mol
moly96031912moly
mom78853162mom
mon57561572mon
mony96830002mony
moo58460512moo
mop76950822mop
mopy115721972mopy
mor56855002mor
mos57067122mos
mot57279422mot
mow86650352mow
my78125652_my
nay66952772nay
no29353242no_
nob58954422nob
nod47549562nod
nog46847312nog
noh66640642noh
nom510450642nom
noo37154042noo
nor38048822nor
nos38859322nos
nosy76322892nosy
not39474662not
now65950192now
od39255242_od
oe28473062_oe
of58247772_of
oh57447002_oh
oi29061482_oi
om48553002_om
on28057182_on
ooh67637092ooh
oot311274692oot
oozy167018132oozy
op45850162_op
or27354732_or
os211359882_os
ow58950172_ow
ox98242382_ox
oxy136320982oxy
pay88461182pay
ploy96123602ploy
ply86323552ply
pod66351482pod
pogy105623552pogy
poh86740532poh
poi57244662poi
poky135922152poky
pol56449382pol
poly96235152poly
pom78249912pom
pony96434052pony
poo57757112poo
pop76252252pop
posy96028422posy
pot58078432pot
pow87147282pow
pox126140692pox
poxy166820892poxy
pry85728052pry
ray66361992ray
rob56754302rob
roc520243252roc
rod47953892rod
roe36861072roe
rom59855632rom
ropy96323412ropy
rosy76024872rosy
rot37282952rot
row67453672row
say67264762say
shy96728192shy
sky106420992sky
sly66228562sly
so28855442so_
sob57857942sob
sod46053702sod
sol37256622sol
som59153802som
son37761952son
sop57557862sop
sos37761602sos
sot310384292sot
sou37853692sou
sow66554762sow
sox106444192sox
soya75724432soya
soys75233932soys
spy86023742spy
sty66227312sty
thy97022912thy
to218858982to_
toby96322292toby
tod49457072tod
tody86327212tody
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
tony75635152tony
too38965422too
top510560682top
tor39261682tor
tory75840542tory
tot38884772tot
tow610557362tow
towy105325472towy
toyo76925452toyo
toys78036342toys
troy77429682troy
try66529672try
voe67739052voe
vow96136312vow
vox136628152vox
way96757662way
why126920012why
wo510447762wo_
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
wry96524702wry
yay96948712yay
yo59748552yo_
yob87945272yob
yod77545502yod
yok107335242yok
yom88043442yom
yon67348952yon
you66641822you
yow96945292yow
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 Limit140843540.43632302.8
3Display Results3543540.0804425.0
 (SQL Overall)1786913540.579308620.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.