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

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

123 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
reaggregation165314(None) 
reaggregations1762841reaggregations
aggregation1454252__aggregation
reaggregating1552562reaggregating
resegregation1563902resegregation
aggregations1553843__aggregations
desegregation1663813desegregation
disaggregation1862693disaggregation
reaggregate14113193reaggregat__e
reaggregated16123163reaggregat_ed
reaggregates1593123reaggregat_es
resegregations1653693resegregations
segregation1346383se__gregation
aggradation1452994__aggradation
aggravation1652664__aggravation
aggregating1343584__aggregating
aggregational1662224__aggregational
aggregative1753364__aggregative
congregation16226764_congregation
desegregations1763564desegregations
disaggregations1962514disaggregations
exaggeration2153864exagg_eration
reannexation1953164rea_nnexation
recreation12413614re__cre_ation
regeneration1348194re_generation
relegation11610024re___legation
remigration14228914remigr__ation
resegregating1652844resegregating
revegetation16105304reveg_etation
segregations1445804se__gregations
abnegation1345415__a_bnegation
abrogation13107335__a_brogation
aggradations1552705__aggradations
aggravations1752435__aggravations
aggregate1244205__aggregat__e
aggregated1443715__aggregat_ed
aggregately1751975__aggregately
aggregates1344125__aggregat_es
aggression1253945__aggre_ssion
allegation1146815__a_llegation
arrogation11107445__a_rrogation
congregations17186415_congregations
deaeration11313015dea___eration
degeneration1447285de_generation
degradation1445385de__gradation
delegation1238885de___legation
denegation1249415de___negation
denigration1348465denigr__ation
deprecation1648965de__precation
depredation1546925de__predation
derogation12410395de___rogation
desegregating1752735desegregating
disaggregating1762155disaggregating
disaggregative2171595disaggregative
emigration13228215_emigr__ation
exaggerations2253485exagg_erations
expurgation2154555_expur_gation
laureation1046155_la_ure_ation
nonsegregation16132805nonsegregation
peregrination16125205peregrination
premigration1755695premigr__ation
rarefaction1652655r_a__refaction
reaccreditation2081185reaccreditation
reactivation17176955rea_ctivation
reaffirmation2152065reaffirmation
reafforestation21101475reafforestation
realization20417225rea__lization
reallocation1454495rea_llocation
reanimation1359635rea__nimation
reannexations2052835rea_nnexations
reapplication1954725reapplication
reassertion1154025rea_sse_rtion
reattribution15112525reattribution
reciprocation19183495reciprocation
recordation1449265re_cor_dation
recreations13412255re__cre_ations
recuperation1656725re_cuperation
redigestion1384155redig_e_stion
redintegration16153645redintegration
redirection1446045re_dire_ction
reforestation1654575re_forestation
reformation1648415re_for_mation
refrigeration1764155refrigeration
regenerations1447145re_generations
regimentation1695435re_gimentation
registration1347535re_gistration
regression1146955re__gre_ssion
regulation11312055re__g_ulation
regurgitation15143405re_gurgitation
rehydration1844645rehydr__ation
reinnervation1653625reinnervation
reintegration14175375re_integration
reiteration11412165re__iteration
rejuvenation22123005re_juvenation
relegations1248975re___legations
relubrication1754505relubrication
remigrations15227795remigr__ations
remuneration1446935re_muneration
renaturation1256755renatur__ation
renegotiation14113665renegotiation
reoperation13410905re__operation
reparation12612725re_par__ation
repatriation14126975repatr_iation
reprobation1548505re__probation
reregulation1346415rereg_ulation
resegregate1352975resegregat__e
resegregated1552805resegregat_ed
resegregates1452785resegregat_es
reservation1489145re_ser_vation
resignation1247475resig__nation
respiration13511195respir__ation
restoration11412095restor__ation
resurrection1453355resurre_ction
retardation12106865re_tar_dation
retrogradation16151885retrogradation
revalorization2664835revalorization
revegetations17114715reveg_etations
revelation13410925re___velation
reverberation1893885reverberation
segregating1445455se__gregating
segregative1654065se__gregative
variegation1543455_va_riegation
vegetation1448215ve__g_etation

Search took 9 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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901237.95315690.9
3Display Results1231230.0801537.5
 (SQL Overall)1786911238.17321863.6
 
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.