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

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

72 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
agglomeration176208(None) 
agglomerations1861781agglomerations
agglomerating1861542agglomerating
agglomerative2061912agglomerative
agglomerate1561943agglomerat__e
agglomerated1791613agglomerat_ed
agglomerates1691903agglomerat_es
conglomeration1963003conglomeration
adulteration1353664adul_teration
agglutination15112654agglutination
aggregation1454254agg__regation
alliteration1285164a_lliteration
alteration10612904a__l_teration
conglomerations2062734conglomerations
abomination1547485a__bomination
acceleration1654815a_cceleration
acclamation17144755acclam__ation
acclimation17127095acclim__ation
admiration1347735a___dmiration
adoration10311315a__do__ration
adulterations1453175adul_terations
adumbration1652615a__dumbration
aeration8319935a_____eration
agglutinations16102515agglutinations
aggradation1452995agg__radation
aggravation1652665agg__ravation
aggregations1553845agg__regations
alienation1048795a__l_ienation
alimentation14105335a__limentation
allegation1146815a__l_legation
alliterations1384555a_lliterations
allocation1248575a_llo__cation
alterations11511665a__l_terations
altercation1347015a__l_tercation
alternation1147625a__l_ternation
amelioration1464005amel_ioration
anglicization25113605anglicization
argumentation16103585arg_umentation
asseveration1552895a_sseveration
atomization2249245a__tomization
augmentation1554395aug__mentation
automation1249145a_utom__ation
cogeneration1546445cog_eneration
coloration12913185_colo__ration
conglomeratic2062165conglomerati_c
conglomerating2062425conglomerating
conglomerative22132325conglomerative
conglomerator1892175conglomerat_or
cooperation15410025__cooperation
defloration1547265deflo__ration
degeneration1447285deg_eneration
deliberation1546365_deliberation
enumeration13105915__enumeration
exaggeration2153865exagg___eration
exoneration1847655__exoneration
exploration2066715explo__ration
generation11312425__g_eneration
glomerate1245675__glomerat__e
halogenation1683185_halogenation
immoderation1753435_immoderation
laceration1249575___laceration
liberation1269995___liberation
literation10511415___literation
moderation1348655___moderation
numeration12137965___numeration
obliteration1453895_obliteration
operation11314005____operation
proliferation1853035proliferation
regeneration1348195reg_eneration
reoperation13410905__reoperation
toleration1048965___toleration
ulceration1247265__ul_ceration

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.393454684.5
2DLD Change Limit124790728.00015598.8
3Display Results72720.0461565.2
 (SQL Overall)178691728.43921174.4
 
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.