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

103 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
agglutination1511265(None) 
agglutinations16102511agglutinations
agglutinating1662472agglutinating
agglutinative1862062agglutinative
agglutinate13122853agglutinat__e
agglutinated1592463agglutinat_ed
agglutinates1472553agglutinat_es
agglutinin1262043agglutin__i_n
conglutination1762783conglutination
agglomeration1762084agglomeration
agglutinable1661494agglutina_ble
agglutinins1371904agglutin__ins
agglutinogen15121604agglutin_ogen
anglicization25113604anglicization
conglutinations1862544conglutinations
deglutition1352344degluti__tion
hallucination18122834hallucination
illumination1455164_illumination
multination1348974_mul_tination
abomination1547485a__bomination
acclimation17127095accl__imation
acculturation17173345acculturation
activation15610135a___ctivation
adjudication2352445a_djudication
adulteration1353665adul_teration
aestivation1447925a__estivation
agglomerations1861785agglomerations
agglutinability2271095agglutinability
agglutinogens16131515agglutinogens
aggradation1452995agg__radation
aggravation1652665agg__ravation
aggregation1454255agg__regation
agitation10311225a_g___itation
agnation9311725a_g____nation
alienation1048795a__l_ienation
alleviation1454655a_llevi_ation
alliteration1285165a_lliteration
alteration10612905a__l_teration
alternation1147625a__lternation
amortization2347205a_mortization
amplification2275185amplification
amputation1447345a_mput__ation
anglicizations26123335anglicizations
angulation1149555ang_u__lation
application1747475appl__ication
argumentation16103585arg_umentation
aromatization2457095aromatization
assassination1382005assassination
automation1249145a___utomation
calcination1548905_cal_cination
calumniation1663995_calumniation
chlorination1756245_chlorination
cocultivation2053055cocultivation
columniation1665425_columniation
conglutinating1862425conglutinating
culmination1557645_cul_mination
cultivation16116415_cul_tivation
declination14411875decl__ination
deglaciation1654305deglaci_ation
deglutitions1452155degluti__tions
delamination1548855_delamination
deputization2447225_deputization
destination12413845__destination
digitization2347685dig_itization
dogmatization2655985dogmatization
elimination1348535__elimination
elucidation1445015__elucidation
elutriation1146715__elutriation
eluviation1376615__eluvi_ation
fluorination1594715__fluorination
fulmination1655885_ful_mination
gallicization2574035gallicization
gelatinization2453955_gelatinization
gemination131410655__g_emination
germination14148975__germination
glaciation1346585__glaci_ation
gleization20115785__gl_eization
guttation1046175__g_ut_tation
hallucinations19112525hallucinations
illuminations1554445_illuminations
illuviation1453575_illuvi_ation
inclination1349735incl__ination
ingratiation1355805ingrati_ation
lamination12311225___lamination
legitimation1555165leg_itimation
litigation1148175___litigation
lunation8311925___lu__nation
magnetization2554835magnetization
margination1447435marg___ination
mutilation1249755___mutilation
negotiation1245775neg_oti_ation
pagination1348995pag___ination
palletization2495195palletization
patination12312575___patination
pectination15410335__pectination
pelletization2495115pelletization
pollination1348015_pol_lination
ruination9311275___ru_ination
rumination12410835___rumination
salutation1048905_salut__ation
supination1249885___supination
uglification1845495_uglification
urination9312175____urination

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901038.62614466.7
3Display Results1031030.0631634.9
 (SQL Overall)1786911039.07919681.8
 
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.