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

438 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
betony11421158(None) 
beton76022061beton_
betons84919551betons
astony9510522astony
atony87218852_atony
barony115915302barony
baton75822422baton_
batons85519422batons
begone9512132begone
belon73924112belon_
belong93411042belong
belons84119412belons
benny105217362be_nny
betook12439602betook
betray111511442betray
beyond1237072beyond
bony96732082b__ony
botany1139262botany
briony1149042briony
bryony1435832bryony
buttony1236172buttony
ebony104511512_ebony
felony123710322felony
jeton124815402jeton_
jetons134512612jetons
ketone105014532ketone
lemony11419552lemony
metonym1445572metonym
peony105717562pe_ony
seton55223542seton_
setons64620172setons
stony85818642_stony
tetany959842tetany
tony75635152__tony
acetone9310793acetone
aeon45634613ae_on_
aeons57624653ae_ons
agony96415653_agony
antonym1246513antonym
atomy107415193_atomy
atone56527983_atone
atopy106813393_atopy
autonym1246633autonym
bacon95620593bacon_
bacons104917583bacons
balcony1435853balcony
baloney1237483baloney
barny105821733b_arny
baron78131243baron_
barong96015823barong
barons85025383barons
batboy1387533batboy
bating95132253bating
batty105422243bat_ty
beachy164011253beachy
beacon10511373beacon_
beacons11410733beacons
beady114719923be_ady
beaky146118023be_aky
beamy126218573be_amy
bean66443863be_an_
beano75421553be_ano
beanos85516513beanos
beans75734693be_ans
beaten84617063beaten_
beatify1536593beatify
beating104326873beating
beauty115410163beauty
bebop11410793bebo_p
bebops1237623bebops
beckon14309383beckon_
beckons15279143beckons
become123312593become
beechy16397503beechy
beefy135313833be_efy
been65335783be_en_
beery105220123be_ery
befog1159013befo_g
befogs1246453befogs
befool1137713befool
before11410153before
befoul1137253befoul
began86319573began_
begin85117353begin_
begins94415303begins
begonia1047213begonia
begot84625953bego_t
begun85113443begun_
behind1238063behind
behold1247343behold
behoof1458683behoof
behove14207203behove
behowl1445533behowl
beigne9148613beigne
beigy111110583be_igy
being84920503be_ing
beknot1239763beknot
belady12489933belady
belay105021523be_lay
belfry1435073belfry
belly104625493be_lly
belongs10408223belongs
below104617193belo_w
belows114614183belows
belting104119133belting
beltway1564373beltway
bemoan10310253bemoan
bemoans1138253bemoans
bemock1636173bemock
ben56554923be__n_
bend76435263be__nd
benday123810813benday
bendy115017253be_ndy
bene66439493be__ne
benne76521123be_nne
benni74715363be_nni
benomyl1443453benomyl
bens65945703be__ns
bent67759913be__nt
benthon1237693benthon_
benthons1337973benthons
bento75922953bento__
bentos86218303bento_s
berry104521773be_rry
besnow1145713besnow
besom95716973beso_m
besoms105712733besoms
besot76429713beso_t
besots86415453besots
besting104923923besting
bestow1149463besto_w
bestows1248863bestows
bet58376673bet___
beta66234133bet__a
betaine9413783betaine
betake124512703betake
betas75528763bet_as
betel74419903bet_el
betels84515063betels
beth96629233bet__h
bethank1666273bethank
bethel1169643bethel
bethink1677203bethink
bethorn1238643bethorn
bethorns1337323bethorns
beths105519223bet_hs
betide95115973betide
betime105914833betime
betise85616273betise
betoken13386503betoken
betokens14324573betokens
betonies10413063betonies
betrays12127823betrays
betroth1247543betroth
bets67051443bet__s
betta74916843bet_ta
bettas84913923bettas
betted94721163betted
better84723703better
betting103921403betting
bettor83612223bettor
bettors93312473bettors
bevor101510813bevo_r
bevors111610343bevors
bevy127115223be__vy
beworm1339993beworm
beworry1543743beworry
bewray14147733bewray
bey86645423be___y
beyonds1335063beyonds
bezant17814543bezant
bezoar1736913bezoar
biltong1034683biltong
biont7727163b_iont
bison75716983bison_
bisons83914373bisons
bitchy16479203bitchy
biting95321823biting
bitsy104511303bit_sy
bitty106119173bit_ty
bizone1738603bizone
blenny1156203blenny
blond85618373b_lond
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
blotty11178343blotty
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
boston8513043boston_
bostons9312903bostons
botchy16537823botchy
botfly1436093botfly
bothy136713963bot_hy
botonee9311833botonee
bouton8311533bouton_
boutons9310783boutons
boxy166420733b__oxy
boy87753563b__o_y
brainy114815643brainy
branny115111833branny
brawny144710603brawny
briny104719663b_riny
bronc91714343b_ronc
bronzy20306713b_ronzy
broody124510083broody
broomy13449953broomy
brosy106115383b_rosy
brothy14519623brothy
browny144510043browny
bunny104715803b_unny
buoy95921783b_uo_y
burton8311273burton_
burtons9310853burtons
butane8313653butane
butene8312623butene
button8310273button_
buttons9310333buttons
butty104020113but_ty
bygone1256173bygone
cetane8315283cetane
colony115417273colony
cony96537833__cony
cottony1237253cottony
crony105918673_crony
cyton101511463cyton_
cytons111710183cytons
debone93714783debone
decoy115716313deco_y
demon86520313demon_
demons94917723demons
deny86027123de__ny
deoxy1648883de_oxy
depone93616553depone
desoxy1744623desoxy
destiny113111463destiny
detent73624483detent
detour778193detour
detox13310953deto_x
devon95113683devon_
devons104512253devons
ebon66821103_ebon_
ebons74316093_ebons
eon36052083_e_on_
eons46638713_e_ons
eponym1345793_eponym
epoxy17465773_epoxy
ethoxy1933923_ethoxy
etna46415263_et_na
exon117116803_exon_
exons125813343_exons
exonym1844583_exonym
felon84619293felon_
felonry13294843felonry
felons93615763felons
fenny115115133fe_nny
ferny115816183fe_rny
feting104417793feting
fetor81214533feto_r
fetors91014473fetors
futon83113773futon_
futons93911513futons
gobony1236913gobony
goony95519783_goony
heron85025503heron_
heronry1346043heronry
herons94820543herons
hexone16289233hexone
incony1139083incony
intone61115433intone
irony85015903_irony
jenny153811623je_nny
jeon116821443je_on_
jetton1338033jetton_
jettons1437273jettons
jetty156212583jet_ty
jetway19105273jetway
ketene106613003ketene
keto86223453keto__
ketol95414003keto_l
ketols104210763ketols
ketones115014503ketones
ketonic1349923ketonic
ketose105711813ketose
legong836963legong
lemon75618183lemon_
lemons84415053lemons
leone55018823le_one
lepton82510803lepton_
leptons91910433leptons
litany939053litany
loony86918963_loony
meany104620483me_any
meiny104015413me_iny
melody1237203melody
melon73922083melon_
melons84117713melons
melton8311553melton_
meltons9410923meltons
memory1338803memory
meson74118313meson_
mesons83215843mesons
methoxy2243953methoxy
meting94320593meting
metol75917813meto_l
metols84115773metols
metonyms1545323metonyms
metonymy1843853metonymy
metope10611123metope
mony96830013__mony
moony104818273_moony
mutiny113612683mutiny
muton73817003muton_
mutons84314363mutons
muttony1235323muttony
nekton1036583nekton_
nektons1136393nektons
neon47026423ne_on_
neons55818683ne_ons
neoteny1045023neoteny
netop7312343neto_p
netops839213netops
nettly9459453nettly
netty85816763net_ty
newton936983newton_
newtons1036813newtons
niton55418283niton_
nitons64614903nitons
oniony9369703oniony
ostomy1137833ostomy
pelon74423213pelon_
penny105119453pe_nny
peon65635243pe_on_
peons75327183pe_ons
peptone11310763peptone
peroxy1838253peroxy
petty105320293pet_ty
phony136715443_phony
piton76121583piton_
pitons85319043pitons
pony96434053__pony
puton73617913puton_
putons83515153putons
ratany93411873ratany
rebody1238153rebody
recon75624243recon_
recons84922993recons
recopy1339043recopy
rectory123512733rectory
redeny102712733redeny
redon65424883redon_
redone74820053redone
redons75222183redons
resiny94617363resiny
retene69224273retene
retina65023383retina
retine66237333retine
retint65633443retint
retold73013753retold
retook104313443retook
retool63914483retool
retore67630773retore
retorn610923433retorn
retort66831153retort
retronym1354683retronym
retry84718083ret_ry
retune69121953retune
rewon86920583rewon_
rezone153814783rezone
satiny93817983satiny
saxony1636233saxony
second9411153second
sepoy10314303sepo_y
setoff1238913setoff
setose65114773setose
setous64917373setous
setout64719473setout
sexton133610793sexton_
sextons143710413sextons
simony1137903simony
spoony114111793spoony
stogy95414083_stogy
stone55431183_stone
stoney96217353_stoney
story86723033_story
swoony12408263swoony
syntony1344523syntony
teeny85417883te_eny
tenon53320513tenon_
tenons62916603tenons
tepoy10312163tepo_y
teston6313303teston_
testons7313563testons
tetchy1436003tetchy
tiny76134633__tiny
toby96322293__toby
tody86327213__tody
ton310265103__ton_
tone46953743__tone
toney86027413__toney
tong56434353__tong
tons46553053__tons
tory75840543__tory
towny116114493__towny
towy105325473__towy
toy69655193__to_y
veiny115414363ve_iny
veto76622993veto__
vetoed10359823vetoed
vetoer93410063vetoer
vetoes92914083vetoes
vetoing11309053vetoing
weeny115316163we_eny
wenny114412463we_nny
wetly114511713wet_ly
xenon122612453xenon_
xenons132710483xenons

Search took 10 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.403443402.0
2DLD Change Limit1127164388.80012808.6
3Display Results4384380.1403128.6
 (SQL Overall)1786914389.34319125.7
 
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.