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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
aggravates155284(None) 
aggravate1443011aggravate_
aggravated1652471aggravated
aggregates1344142aggregates
margravates1752472margravates
aggrades1135863aggr__ades
aggravating1752423aggravating
aggravation1652673aggravation
aggravations1752443aggravations
aggregate1244213aggregate_
aggregated1443723aggregated
aguacates1244583a_guacates
gradates10510783__gradates
margravate1652513margravate_
margraviates1872043margraviates
abbreviates1851744abbreviates
abrogates12108994a_brogates
acerbates1347274acer_bates
acervate1336994acer_vate_
acrylates1446694a_crylates
activates1449694a_ctivates
aerates74627504a_er__ates
aestivates13107374aestivates
affricates1844624affricates
agametes1147294a_g_ametes
agates76121344a_g___ates
agaves104611514a_g_av__es
agemates111110034a_g_emates
aggadahs1462264agg_ada_hs
aggadas1055004agg_ada__s
aggradation1452994aggradation
aggradations1552704aggradations
aggrade1035644aggr__ade_
aggraded1244204aggr__aded
aggrandise1392854aggrandise
aggrandises1492764aggrandises
aggrandizes23122604aggrandizes
aggregately1751984aggregately
aggresses1146144aggr_esses
aggrieves14101904aggr_ieves
agitates9310884a_g_itates
agnates82813194a_g__nates
agrafes1137524a_gr__afes
agraffes1553044a_gra_ffes
aguacate1144974a_guacate_
aigrettes1046404aigr_ettes
airdates939734a_ir_dates
alginates10310124alg_inates
amadavats1551944amadavat_s
amirates101114804amir__ates
andradites1244784andradites
angulates10310864ang_ulates
approbates1645864approbates
arrogates10129434a_rrogates
aspartates1244674aspartates
avadavats1651524avadavat_s
cravats1237414__cravat_s
derivates13310104_derivates
enervates1248734ener_vates
engraves1237234engrav__es
excavates2144684_excavates
gavages1237684__g_avages
gradate9511234__gradate_
gradated1157434__gradated
graduates1147684__graduates
granites92116364__granites
grates75429894__gr__ates
gravamen1443934__gravamen
gravamens1542784__gravamens
graves104624004__grav__es
gravies11314094__grav_ies
gravitas12316024__gravitas
gravitates1444854__gravitates
gravities1338304__gravities
gravures1234904__gravures
gyrates113610264_gyr__ates
ingrates9514174ingr__ates
ingratiates1254424ingratiates
manganates1345954mang_anates
margraves1544834margrav__es
margraviate1752124margraviate_
margravines1752414margravines
migrates111112854migr__ates
paravanes1448314_paravanes
privates131812384__privates
pyruvates1743144_pyruvates
ravages1139404___ravages
reaggregates1593124reaggregates
regrates92618414regr__ates
savates10312954___savates
segregates1245344segregates
stravages1345844_stravages

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 Filter1786911614500.453394461.4
2DLD Change Limit161450929.26317429.6
3Display Results92920.0501840.0
 (SQL Overall)178691929.76618297.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.