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

169 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
energies931078(None) 
anergies9310451anergies
energids1045581energids
energise947331energise
energises1047061energises
energizes1945471energizes
anergias947172anergias
clergies1137902clergies
elegies81312902ele_gies
emerges101310882emerg_es
emeries91620022emer_ies
enemies9313692ene_mies
energid948302energi_d
energised1145182energised
energize1845562energize
energized2044542energized
energizer1943742energizer
energizers2042902energizers
entries71523162entr_ies
epergnes1156712epergnes
exergues1644122exergues
synergies1345092synergies
veneries112815032vener_ies
aeries64737783_aer_ies
allergies10137783allergies
anergia847363anergi_a
anergic1048103anergi_c
aneroids9310203aneroids
aperies9423203aper_ies
beaneries11310903beaner_ies
berries94423553_berries
celeries10316313celer_ies
cherries131812983cherries
deaneries10310833deaner_ies
demerges12129503demerg_es
derbies103016053_derbies
derries83124623_derries
deterges101510093deterg_es
eateries8324313eater_ies
eerie55228533e_er_ie_
eerier64320023e_er_ier
eeriest73620673e_er_iest
effigies1543513effigies
elderlies1044673elderlies
elegise8139393ele_gise
elegises9128823ele_gises
elegits8149343ele_gits
elegizes18137103ele_gizes
emerge91510463emerg_e_
emerged11158213emerg_ed
emerging1237893emerging
emeroids11147723emeroids
emperies12314563emper_ies
encages103313783encag_es
endrins8312163endr_ins
energetics1343453energetics
energumen1253073energumen
energumens1352793energumens
energy10137513energ__y
enervates1248723enervates
enframes1357453enframes
engages92912493engag_es
engines81114463en__gines
engorges1045753engorg_es
engrails945383engrails
engrains937583engrains
engraves1237233engraves
enlarges946073enlarg_es
enmities10611353enmities
enologies10312983enologies
enrages83114853en_rages
enrobes92211113en_robes
enskies1138573en_skies
enterics10312853enter_ics
entities8617413entities
entrails8310163entrails
entrains8312963entrains
entrees71813773entr_ees
entropies11411023entropies
enures63919713enur__es
enureses838113enureses
envies9314053en__vies
epergne1046143epergne_
equerries1844883equerries
eserines8413743eserines
eternise8119663eternise
eternises9119453eternises
eternizes18118013eternizes
eulogies938523eulogies
exequies2444153exequies
exercise1747063exercise
exercises1846463exercises
exergue1544193exergue_
eyries93816813e_yr_ies
faeries104118993faer_ies
ferlies103216693_ferlies
ferneries1239043ferner_ies
ferries103521083_ferries
fineries112416743finer_ies
generates10312713generates
generics11118793gener_ics
gentries91315263gentr_ies
henneries1248643henner_ies
henries102718283hen_r_ies
herries104025073_herries
inertias8410383inertias
interties9320333interties
jerkies183411583_jerkies
jerries143817513_jerries
kerries113317913_kerries
kneesies1245543kneesies
mercies113817563_mercies
mergees104411233_mergees
merges94122483_merg_es
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
peeries93623023peer_ies
penuries10311663penur_ies
perries93226603_perries
pierogies1245873pierogies
pineries102419083piner_ies
porgies103017003_porgies
queries16315873quer_ies
reenergizes2152803reenergizes
remerges111110203remerg_es
reneges82513593rene_g_es
reveries112518513rever_ies
sceneries1149393scener_ies
sentries81318053sentr_ies
serges74225963_serg_es
series64540973_ser_ies
serries73925353_serries
sherries111812893sherries
skerries12168673skerries
snuggies10246363snuggies
synergias1343423synergias
synergids1443013synergids
tergites9310543_tergites
terries73425633_terries
theurgies1343353theurgies
undergoes1139053undergoes
underlies101414203underlies
veeries102916893veer_ies
veggies1237553_veggies
vegies104314273_ve_gies
venerates12312263venerates
verges104320173_verg_es
vineries112716043viner_ies
wedgies123910203_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.1701051123.5
2DLD Change Limit1461621696.90621164.5
3Display Results1691690.0632682.5
 (SQL Overall)1786911697.13925030.3
 
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.