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

162 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
anergies931045(None) 
anergias947171anergias
energies9310781energies
aeries64737782a_er_ies
allergies10137782allergies
anergia847362anergi_a
anergic1048112anergi_c
aneroids9310202aneroids
aperies9423202aper_ies
clergies1137902clergies
energids1045582energids
energise947332energise
energises1047062energises
energizes1945472energizes
synergies1345092synergies
aegis6316783a_e_gi_s
aegises8311373a_e_gises
aerates74627493a_erates
aerie54634603a_er_ie_
aeried74221863a_er_ied
aerier64823153a_er_ier
aeriest73924053a_er_iest
aerifies111313393a_erifies
aerobes9311493a_erobes
agencies1138743agencies
aggies83515513a__ggies
allergins10146383allergins
amberies122514683amber_ies
ambries111614553ambr_ies
amerces1149853amer_ces
amnesties1166873amnesties
anaerobes1144993anaerobes
anagogies11156163anagogies
analgias9107803analgias
analogies101910643analogies
anarchies1448183anarchies
androids1047753androids
aneles64626293ane__les
anemias92512143ane_mias
anemones10249473anemones
anemoses10159433anemoses
anergy10156863anerg__y
aneroid8314003aneroi_d
aneurins849073aneurins
angaries9314393angaries
angles74426703an__gles
angrier839023angr_ier
angriest9310253angr_iest
ankerites1348523ankerites
anlages82414113anlag_es
anomies93316993an_omies
anorexies1645703anorexies
anserines9411293anserines
antres65021003antr__es
anureses837973anureses
anurias7312253anur_ias
argils75213623a__rgils
argles75218483a__rgles
argues74516413a__rgues
armies85123693a__rmies
arteries8321483arter_ies
asperges11318093asperg_es
auberges1146673auberg_es
aubergines1354273aubergines
avenges1157543aveng_es
averages1249183averages
aversives1545913aversives
bakeries14312193baker_ies
beaneries11310903beaner_ies
berries94423553_berries
canaries10318943canar_ies
canneries11313083canner_ies
cherries131812983cherries
deaneries10310833deaner_ies
derbies103016053_derbies
derries83124623_derries
eateries8324313eater_ies
elegies81312903ele_gies
emerges101310883emerg_es
emeries91620023emer_ies
enemies9313693ene_mies
energid948303energi_d
energised1145183energised
energize1845563energize
energized2044543energized
energizer1943743energizer
energizers2042903energizers
entries71523163entr_ies
epergnes1156713epergnes
exergues1644123exergues
faeries104118993faer_ies
fakeries1559833faker_ies
ferlies103216693_ferlies
ferries103521083_ferries
fineries112416743finer_ies
flaneries1249563flaner_ies
gantries91413793gantr_ies
henries102718283henr_ies
herries104025073_herries
inertias8410383inertias
interties9320333interties
japeries17311463japer_ies
jerkies183411583_jerkies
jerries143817513_jerries
kerries113317913_kerries
kneesies1245543kneesies
maneges103612143mane_g_es
mercies113817563_mercies
mergees104411233_mergees
merges94122493_merg_es
naperies10313903naper_ies
nargiles976793_nargiles
neddies92710703_neddies
nellies73418723_nellies
nerdier83110353_nerdier
nerdiest92511163_nerdiest
nereides938503_nereides
nereids838743_nereids
nereis6315343_nerei_s
nerves94216193_ner_ves
nervier10298833_nervier
nerviest11188833_nerviest
nervines112310463_nervines
newbies12147423_newbies
newies91014073_ne_wies
newsies101310383_newsies
noogies82814583_noogies
onerier7311613oner_ier
oneriest8313443oner_iest
orgies72316093__orgies
overlies112417043overlies
panfries13149203panfr_ies
pantries101817393pantr_ies
peeries93623023peer_ies
perries93226603_perries
pierogies1245873pierogies
pineries102419083piner_ies
porgies103017003_porgies
queries16315873quer_ies
serges74225973_serg_es
series64540973_ser_ies
serries73925353_serries
sherries111812893sherries
skerries12168673skerries
snuggies10246363snuggies
synergias1343423synergias
synergids1443013synergids
tanneries9310423tanner_ies
tergites9310543_tergites
terries73425633_terries
theurgies1343353theurgies
undergoes1139053undergoes
underlies101414203underlies
veeries102916893veer_ies
veggies1237553_veggies
vegies104314273_ve_gies
veneries112815033vener_ies
verges104320183_verg_es
vineries112716043viner_ies
wedgies123910213_wedgies
wherries14179023wherries
wineries112316533winer_ies

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621627.33019940.2
3Display Results1621620.0762131.6
 (SQL Overall)1786911627.82622833.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.