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

246 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
anergy1015686(None) 
energy10137511energy
aery77231682a_er_y
allergy1144502allergy
anergia847362anergia
anergic1048102anergic
angerly1137772angerly
angry9310862angr_y
apery106517902aper_y
clergy1234992clergy
nerdy95014702_nerdy
nervy114610862_nervy
onery8414122oner_y
synergy1442942synergy
aargh96314083a_argh
aarrgh10786303aarrgh
acerb9312763acer_b
aerie54634603a_erie
aerify122810113a_erify
aerily93017013a_erily
aero45435343a_er_o
aerugo735803a_erugo
affray1534973affray
agedly1136463agedly
agency1237033agency
ager55935843ager__
agers65027853ager_s
airy75734153a_ir_y
alary86123443alar_y
alert54740653aler_t
alertly1046793alertly
alerts64418223alerts
ambery133811133amber_y
ambry123512103ambr_y
amerce10310513amerce
amnesty1244823amnesty
anagogy12174443anagogy
anally9513503anally
analogy11177853analogy
anarch11310393anarch
anarchy1544933anarchy
andro6314163andr_o
andros7313303andros
ane37866953ane___
anear55420323ane_ar
aneared8512743aneared
anears63717183anears
anele55628833ane_le
aneled74719273aneled
aneles64626293aneles
anemia82613573anemia
anemic102713693anemic
anenst63514983anenst
anent54931843ane_nt
anergias947173anergias
anergies9310453anergies
aneroid8314003aneroid
anes45255933ane__s
aneurin749833aneurin
anew76623133ane__w
anga56831353an__ga
angary10311323angary
anger66225873anger__
angered93013473angered
angers75222543anger_s
angrily1137723angrily
anlage72514223anlage
annoy869713an_noy
anomy105113393an_omy
anorak1038923anorak
anorexy1743563anorexy
antigay1148223antigay
antra56521923antr_a
antral65719413antral
antre55224523antr_e
antres65021003antres
antrum8611313antrum
antsy85712793an_tsy
anural65714743anural
anuran64313243anuran
anuria6313123anuria
anuric8812103anuric
any68440493an___y
anyway1534803anyway
aper66336233aper__
apercu1057383apercu
apers76629133aper_s
army96624183a__rmy
array86317143a_rray
artery9911453arter_y
arty77531313a__rty
astray95615543astray
auberge1045633auberge
avenge1087553avenge
aver75931883aver__
average1158853average
avers85127313aver_s
averse95811183averse
avert86029493aver_t
averts95715243averts
aweary1237303aweary
aweigh1334933aweigh
awry107619683a_wr_y
bakery155911003baker_y
bankerly1744333bankerly
beanery1237563beaner_y
beery105220123beer_y
beigy111110583_beigy
berg75425543_berg_
bergs84718043_bergs
berry104521773_berry
canary11314693canar_y
caner75334773caner__
caners84629203caner_s
cannery123610013canner_y
cherry144810763cherry
cherty144612473cherty
deanery1137613deaner_y
deray95024183_deray
derby114715343_derby
derry94721373_derry
dreggy12364633dreggy
eagerly1136053eagerly
eatery95316353eater_y
edgy94713523__edgy
eery76129623_eer_y
eggy96611853__eggy
elegy939303ele_gy
emerge91510463emerge
emery104814333emer_y
enemy1059993ene_my
energid948303energid
entry82414263entr_y
erg45531073__erg_
ergo56420153__ergo
ergs55523813__ergs
every115215453ever_y
faery116015483faer_y
fakery16509263faker_y
fanega1055783fane_ga
ferly115517353_ferly
ferny115816183_ferny
ferry116020803_ferry
fiery114714793fier_y
finery124512893finer_y
fledgy14414913fledgy
gantry103810113gantr_y
germy115113663_germy
gnarly104610383gnarly
hedgy134510743_hedgy
henry114014473henr_y
herby134715313_herby
herry114922473_herry
inert53234373iner_t
inertly1038543inertly
inerts64517023inerts
innerly1037133innerly
japery18439143japer_y
jerky196712423_jerky
jerry155016183_jerry
kerry124916093_kerry
knarry1334613knarry
knurly13405533knurly
lanely93914483lane_ly
laneway1345273laneway
ledgy105712013_ledgy
leery85919133leer_y
leggy105210243_leggy
manege94113203mane_ge
mangy115021243man__gy
mannerly1344983mannerly
mercy125916183_mercy
merge84523683_merge
merry104721483_merry
naggy106612823_naggy
napery11489813naper_y
narky126017803_narky
nary76931223_nar_y
nearby11356053_nearby
nearly94813733_nearly
neddy10479873_neddy
needy94614693_needy
neg47237343_ne_g_
negs55727363_ne_gs
neigh94912383_neigh
nelly84618813_nelly
nerd56624943_ner_d
nerds65719253_nerds
nerol51017813_nerol
nerts55924983_nerts
nertz145117453_nertz
nerve86617373_nerve
netty85816763_netty
newly114610203_newly
newsy11489393_newsy
orgy85218003__orgy
ornery938463orner_y
overly122411363overly
panfry14456413panfr_y
pantry115014103pantr_y
papery134812743paper_y
parerga1035173parerga
peery105719443peer_y
perdy115417323_perdy
perky145319483_perky
perry105222713_perry
pinery115214293piner_y
porgy116916123_porgy
query174212083quer_y
qwerty2133583qwerty
rangy95320383ran__gy
sanely93114613sane_ly
saner54334323saner__
sedgy104512783_sedgy
serge64727463_serge
serry84824123_serry
sherry124510413sherry
skerry13356103skerry
snaggy11488053snaggy
snarky134210843snarky
snarly93815003snarly
sneaky13427843sneaky
sneery93610413sneery
sneezy18345273sneezy
surgy95118523_surgy
tangy94519933tan__gy
tannery10388663tanner_y
terga63315643_terga
terry84721873_terry
theurgy1442733theurgy
unary8315993unar_y
undergo937043undergo
uneasy9278853uneasy
unmerry1245023unmerry
veery115816253veer_y
venery123710663vener_y
verge93419833_verge
very108025643_ver_y
vinery124912603viner_y
wafery15398693wafer_y
waney115120323wane__y
watery123914493water_y
wavery154610053waver_y
wedgy13479793_wedgy
wherry15477333wherry
winery125014283winer_y

Search took 6 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.1401276364.3
2DLD Change Limit1127162465.73319660.9
3Display Results2462460.0803075.0
 (SQL Overall)1786912465.95330017.0
 
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.