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

114 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
reaggregations176284(None) 
reaggregation1653141reaggregation_
aggregations1553842__aggregations
reaggregating1552562reaggregati_ng
resegregations1653692resegregations
aggregation1454253__aggregation_
desegregations1763563desegregations
disaggregations1962513disaggregations
reaggregates1593123reaggregat__es
resegregation1563903resegregation_
segregations1445803se__gregations
aggradations1552704__aggradations
aggravations1752434__aggravations
aggregating1343584__aggregati_ng
aggregational1662224__aggregational
congregations17186414_congregations
desegregation1663814desegregation_
disaggregation1862694disaggregation_
exaggerations2253484exagg_erations
reaggregate14113194reaggregat___e
reaggregated16123164reaggregat__ed
reannexations2052834rea_nnexations
recreations13412254re__cre_ations
regenerations1447144re_generations
relegations1248974re___legations
remigrations15227794remigr__ations
resegregating1652844resegregati_ng
revegetations17114714reveg_etations
segregation1346384se__gregation_
abnegations1444925__a_bnegations
abrogations14116465__a_brogations
aggradation1452995__aggradation_
aggravation1652665__aggravation_
aggregates1344125__aggregat__es
aggregative1753365__aggregati_ve
aggressions1353855__aggre_ssions
allegations1246045__a_llegations
arrogations12126485__a_rrogations
congregation16226765_congregation_
deaerations12311675dea___erations
degenerations1546355de_generations
degradations1544555de__gradations
delegations1348035de___legations
denegations1348545de___negations
denigrations1447355denigr__ations
deprecations1748565de__precations
depredations1646735de__predations
derogations1349395de___rogations
desegregating1752735desegregati_ng
disaggregating1762155disaggregati_ng
emigrations14187155_emigr__ations
exaggeration2153865exagg_eration_
expurgations2274125_expur_gations
laureations1145575_la_ure_ations
nonsegregations17162695nonsegregations
peregrinations17114685peregrinations
rarefactions1752415r_a__refactions
reactivations18176145rea_ctivations
reaffirmations2251975reaffirmations
realizations21415535rea__lizations
reallocations1553805rea_llocations
reanimations1468785rea__nimations
reannexation1953165rea_nnexation_
reapplications2054255reapplications
reassertions1253645rea_sse_rtions
reattributions16112425reattributions
reciprocations20203385reciprocations
recordations1548645re_cor_dations
recreation12413615re__cre_ation_
recuperations1746085re_cuperations
redigestions1483865redig_e_stions
redintegrations17143255redintegrations
redirections1546175re_dire_ctions
reforestations1754465re_forestations
reformations1747605re_for_mations
refrigerations1863775refrigerations
regeneration1348195re_generation_
regimentations1784855re_gimentations
registrations1446895re_gistrations
regressions1247105re__gre_ssions
regulations12310715re__g_ulations
regurgitations16133145re_gurgitations
rehydrations1943985rehydr__ations
reinnervations1753445reinnervations
reintegrations15164785re_integrations
reiterations12410875re__iterations
rejuvenations23122695re_juvenations
relegation11610025re___legation_
relubrications1854195relubrications
remigration14228915remigr__ation_
remunerations1556205re_munerations
renaturations1355965renatur__ations
renegotiations15113375renegotiations
reoperations14410065re__operations
reparations13611665re_par__ations
repatriations15136515repatr_iations
reprobations1647775re__probations
reregulations1455715rereg_ulations
resegregates1452785resegregat__es
reservations1588585re_ser_vations
resignations1346885resig__nations
respirations14410305respir__ations
restorations12410955restor__ations
resurrections1553465resurre_ctions
retardations1396515re_tar_dations
retrogradations17151645retrogradations
revalorizations2754555revalorizations
revegetation16105305reveg_etation_
revelations14410305re___velations
reverberations19113585reverberations
segregating1445455se__gregati_ng
segregationist1692915se__gregationist
variegations1643455_va_riegations
vegetations1547325ve__g_etations

Search took 7 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 Filter178691950240.360496363.9
2DLD Change Limit950241146.47014686.9
3Display Results1141140.0761500.0
 (SQL Overall)1786911146.90625874.7
 
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.