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 “bryony” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

280 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
bryony143583(None) 
briony1149041briony
barony115915302barony
baryon111211612baryon_
baryons121010472baryons
betony114211582betony
beyond1237072beyond
bony96732082b__ony
brainy114815642brainy
branny115111832branny
brawny144710602brawny
briny104719662br_iny
bronc91714342br_onc
bronzy20306712br_onzy
broody124510082broody
broomy13449952broomy
brosy106115382br_osy
browny144510042browny
crony105918672cr_ony
irony85015902ir_ony
agony96415653_agony
anyon85615223anyon_
anyone94612733anyone
anyons94513503anyons
argon65520593argon_
argons75018203argons
argosy1036423argosy
armory114211473armory
aroynt9312893aroynt
arrowy12288273arrowy
arson55118833arson_
arsons63917213arsons
astony9510523astony
atony87218853_atony
bacon95620593bacon_
bacons104917583bacons
balcony1435853balcony
baloney1237483baloney
barny105821733b_arny
baron78131243baron_
barong96015823barong
barons85025383barons
baryonic1546203baryonic
baryton1246003baryton_
barytone1356023barytone
barytons1345573barytons
baton75822423baton_
batons85519423batons
baying125222583baying
bayonet121212213bayonet
bayou10512363bayo_u
bayous11411153bayous
begone9512133begone
belon73924113belon_
belong93411043belong
belons84119413belons
benny105217363b_enny
beton76022063beton_
betons84919553betons
beyonds1335063beyonds
biont7727163b_iont
biryani1244033biryani
bison75716983bison_
bisons83914373bisons
bizone1738603bizone
blenny1156203blenny
blond85618373b_lond
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
blowy134315323b_lowy
body107425673b__ody
bogy106426193b__ogy
boloney1247763boloney
bond75334363b__ond
bone65949323b__one
boney105227313b__oney
bong75633413b__ong
bonk105531713b__onk
bonny105816623b_onny
booby125319513b_ooby
boody115420403b_oody
boogy114518323b_oogy
boomy125421823b_oomy
boon67142173b_oon_
boons75031913b_oons
booty106125913b_ooty
boozy194917063b_oozy
boron76727143boron_
borons85520543borons
bosomy13509033bosomy
boson76019733boson_
bosons85016653bosons
botany1139263botany
boxy166420733b__oxy
boy87753563b__o_y
boyo96923843boyo__
boyos105418283boyo_s
braggy13337173braggy
brain76229383brain_
brains85125473brains
braky145015813br_aky
bran65740383br_an_
brand85124493br_and
brandy124712063brandy
brank115222283br_ank
brans75437433br_ans
brant74742173br_ant
brashy145210593brashy
brassy11509233brassy
bratty1159683bratty
brawly144312353brawly
brawn106018563brawn_
brawns115614083brawns
braxy175410893br_axy
bray95232903br__ay
braying134416313braying
bready124511183bready
breezy20295853breezy
bren65629563br_en_
brens75823363br_ens
brent75734133br_ent
briary114912003briary
bricky17489093bricky
briery114510773briery
brin67038193br_in_
brine75132273br_ine
bring85528503br_ing
brink116122003br_ink
brins75533973br_ins
brio65432493brio__
brios74725723brio_s
bro56236603br_o__
broad84817693br_oad
brock136017073br_ock
broil74918223br_oil
broke116019783br_oke
brolly114510853brolly
brome94421973br_ome
bromo95217203br_omo
bronco10179493br_onco
broncs101611153br_oncs
bronze173610923br_onze
broo65129823br_o_o
brooch13368443brooch
brood84620243br_ood
broods95416383broods
brook114717763br_ook
brooks125813883brooks
broom95022213br_oom
brooms104915873brooms
broos75126413br_oos
bros65635663br_o_s
brose75227033br_ose
broth106521093br_oth
brothy14519623brothy
brow97228443br_o_w
brown105619533br_own
browns116415633browns
brows105425983br_ows
bruin75818333bruin_
bruins86014953bruins
brumby15385953brumby
brung84613913br_ung
brunt75728753br_unt
brushy14468263brushy
bryology1744513bryology
bryonies1336843bryonies
bunny104715803b_unny
buoy95921783b_uo_y
burton8311273burton_
burtons9310853burtons
burying133413913burying
buttony1236173buttony
buying124213833buying
buyoff1754233buyoff
buyout11310103buyout
bygone1256173bygone
byroad1236623byroad
byway1647533b_yway
colony115417273colony
cony96537833__cony
cranny114210273cranny
crayon114110003crayon_
crayons12439233crayons
crone75231333cr_one
croon75522783croon_
croons85418423croons
crying123612283crying
cryogeny1743553cryogeny
cryonic1437833cryonic
drone65324983dr_one
drooly104911073drooly
droopy12458243droopy
drying113411603drying
dryly12538453dry_ly
ebony104511513_ebony
embryon1474063embryon_
embryons1574043embryons
euryoky1741813euryoky
felony123710323felony
frond95316343fr_ond
frons86124043fr_ons
front85029223fr_ont
frying134511403frying
gobony1236913gobony
goony95519783_goony
grainy103914213grainy
granny104311163granny
greeny104811453greeny
grody103412063gr_ody
groovy13375403groovy
groyne1037213groyne
gyron95314623gyron_
gyrons105511223gyrons
harmony1538173harmony
hryvna1541573hryvna
incony1139083incony
iron46728463ir_on_
irone55126363ir_one
irons55324133ir_ons
jargony1834493jargony
krona93611793kr_ona
krone94018733kr_one
kroon94514483kroon_
krooni10397183krooni
kroons103711243kroons
lemony11419553lemony
loony86918963_loony
mony96830013__mony
moony104818273_moony
myopy15457353_myopy
oniony9369703oniony
orgone71110913orgone
orlon5415003orlon_
orlons6411013orlons
peony105717563_peony
phony136715443_phony
pony96434053__pony
prion75119993prion_
prions84317783prions
priory114110263priory
prone75332623pr_one
prong85218113pr_ong
prosy106319253pr_osy
proxy175011013pr_oxy
prying124114803prying
pyrone112714473pyrone
rainy85921083_rainy
rayon83815703rayon_
rayons94113343rayons
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
ropy96323413_r_opy
rosy76024873_r_osy
runny84613483_runny
rynd86414103_ry_nd
ryot75528563_ryo_t
ryots85313783_ryots
saxony1636233saxony
simony1137903simony
spoony114111793spoony
stony85818643_stony
swoony12408263swoony
tony75635153__tony
toyon86715673toyon_
toyons95512133toyons
tranny94210863tranny
trona54118953tr_ona
trone55131863tr_one
troy77429683tr_o_y
trying104214073trying
tryout9410753tryout
wrong94712323wr_ong
wrying13379623wrying
wryly14356703wry_ly
yon67348953__yon_
yond86122313__yond
yoni77524393__yoni

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162805.64019985.1
3Display Results2802800.0933010.8
 (SQL Overall)1786912806.10929250.5
 
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.