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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
aggregating134358(None) 
aggravating1752412aggravating
aggregation1454252aggregation
aggregations1553842aggregations
aggregative1753362aggregative
reaggregating1552562reaggregating
segregating1445452segregating
abnegating1444463a_bnegating
abrogating1497983a_brogating
aggrading1344843aggr__ading
aggregate1244203aggregat__e
aggregated1443713aggregat_ed
aggregately1751973aggregately
aggregates1344133aggregat_es
aggregational1662223aggregational
aggressing1344183aggre_ssing
arrogating121778393a_rrogating
congregating1754283congregating
disaggregating1762153disaggregating
abbreviating2051604abbreviating
abreacting1544534a_breacting
accrediting1752464accrediting
accreting1446334accre__ting
acerbating1546294acer_bating
acierating1348324a_cierating
aerating92821004a___erating
affricating2043964affricating
affrighting2252014affrighting
agenting1039384a_g_e_nting
agglomerating1861544agglomerating
aggradation1452994aggradation
aggradations1552704aggradations
aggravation1652664aggravation
aggravations1752434aggravations
aggregateness1662334aggregateness
aggregatively2262134aggregatively
aggrieving1681484aggr_ieving
agitating1138864a_g_itating
agreeing10295904a_gre__eing
alienating1147234a_lienating
altercating1455604altercating
alternating1245714alternating
angulating1247824ang_ulating
antedating1277554a_ntedating
appreciating1954094appreciating
approbating1844584approbating
arresting1038634a_rre_sting
asperating1349564a_sperating
assegaiing1241904a_ssegaiing
augmenting1443854augme_nting
cocreating15310294cocre_ating
corelating13511584_corelating
correlating1487084correlating
corrugating1544264corrugating
creating113921954__cre_ating
cremating14312204__cremating
degreasing1345424degre_asing
delegating1337674_delegating
deprecating1777284deprecating
depredating1655694depredating
derogating1348634_derogating
desegregating1752734desegregating
entreating11811554entre_ating
estreating11710364estre_ating
exaggerating2253184exagg_erating
foredating1577124_foredating
gelating103015734__g_elating
generating12310394_generating
gradating1237324__gradating
grating93923184__gr__ating
greasing102811394__gre_asing
greeting103112354__gre_eting
gregarine1144784__gregarine
gyrating1337454_gyr__ating
imprecating1844904imprecating
impregnating1852844impregnating
intreating11614014intre_ating
irrigating1245954_irrigating
laureating1146394laure_ating
legating102313114___legating
maltreating1455514maltre_ating
migrating13910534migr__ating
misrelating1447274misrelating
negating102012834___negating
overeating141016534overe_ating
predating13514654__predating
prorogating1556064prorogating
reaggregation1653144reaggregation
reaggregations1762844reaggregations
rebating112418344___rebating
recreating131214584recre_ating
redating102620174___redating
regaling10315364___regaling
regelating1239954reg_elating
regrating111316214___regrating
regreeting1237344regre_eting
regretting1237784regre_tting
relating92725444___relating
relegating1239484_relegating
remating112322424___remating
resegregating1652844resegregating
retreating111414774retre_ating
segregation1346384segregation
segregations1445804segregations
segregative1654064segregative
subrogating15164984subrogating
surrogating13194324surrogating
threating131010054_thre_ating
treating92519614__tre_ating
uncreating13310474uncre_ating
variegating1643214variegating
vegetating1545704veg_etating

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 Filter1786911488190.466383457.1
2DLD Change Limit1488191128.67317158.9
3Display Results1121120.0631777.8
 (SQL Overall)1786911129.20219418.7
 
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.