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

146 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
amalgamations185170(None) 
amalgamation1751981amalgamation_
amalgamating1851602amalgamati_ng
amalgamators1771302amalgamat_ors
acclamations18164043accl_amations
amalgamates1652133amalgamat__es
amalgamator1691393amalgamat_o_r
acclamation17144754accl_amation_
acclimations18146294accl_imations
amalgamate1552264amalgamat___e
amalgamated1751844amalgamat__ed
ameliorations1563194ameliorations
analyzations2463664anal_yzations
declamations1745304decl_amations
emarginations1674154emarginations
exclamations23104104excl_amations
imaginations1546344ima_ginations
malformations2053074_malformations
marginations1546454_marginations
palmations1438734_pal__mations
reclamations1645714recl_amations
ablations11311515a_bl___ations
abnegations1444925abneg__ations
abrogations14116465abrog__ations
acclimation17127095accl_imation_
acylations1547605acyl___ations
adaptations1464575ada__ptations
adulations11310125adul___ations
adulterations1453175adulterations
affirmations2053235a_ffirmations
aggradations1552705a_ggradations
aggravations1752435a_ggravations
agitations11310065__a_gitations
agnations10310035__a_g_nations
alations82518895__al___ations
alienations1147885__alienations
alkylations1843355__alkylations
allegations1246045__allegations
alleviations1554495a_lleviations
allocations1347775__allocations
alterations11511665__alterations
amalgams1343205amalgam_____s
ambulations1547115am__bulations
amelioration1464005amelioration_
ammoniations1645415am_moniations
amortizations2456465amortizations
amplifications2384755amplifications
amputations1546445am__putations
analyzation2354385anal_yzation_
angulations1268055__angulations
animalizations2548255animal_izations
animations12312195__a_nimations
applications1846775appl_ications
arrogations12126485arrog__ations
assignations1344165assig_nations
automations1348235__automations
calcinations1647935_calcinations
calculations1647075_calculations
calibrations1645155_calibrations
canalizations24410435canal_izations
clavations1546185__cl_avations
coagulations1546515coa_gulations
collimations1656875_collimations
dalmatians1343565_dal__matians
dealations11311375deal___ations
declamation1646105decl_amation_
declarations1546805decl_arations
defamations1745895__defamations
deflagrations1883025deflagrations
desquamations2581755desquamations
dilatations1246415_dil_atations
disclamations1853725disclamations
emaciations1548165ema__ciations
emanations1289595em___anations
emancipations1953745emancipations
emargination1554865emargination_
emasculations1754605emasculations
emigrations14187155em_ig_rations
emulations12310945emul___ations
evaginations1645825eva_ginations
evaluations1457325eval__uations
exaggerations2253485exaggerations
exaltations1847295exal__tations
exclamation22104635excl_amation_
explanations2144625expl_anations
floatations1444105__floatations
fulgurations1692795_fulgurations
halations12312395_hal___ations
halogenations1772935_halogenations
imagination1447195ima_gination_
immigrations1743725immig_rations
implantations1753245implantations
implications1847025impl_ications
inaugurations1453155inaugurations
inflammations20102545inflammations
lacrimations1645705_lacrimations
lallations1038745_lal__lations
lavations1238975___l_avations
laxations1637625___l_axations
macerations1548475_ma_cerations
machinations19115765_machinations
maculations1569625_ma_culations
maladaptations1961335_maladaptations
malathions1543875_mal_a_thions
maledictions1752955_maledictions
malefactions1953145_malefactions
malformation1953325_malformation_
malfunctions1952665_malfunctions
malpositions1653675_malpositions
malversations1852565_malversations
margination1447435_margination_
marinations13411275_ma_rinations
mastications1649415_mastications
maturations1348445_ma_turations
meliorations1466755_meliorations
methanations1743975_methanations
migrations13168685_m_ig_rations
molestations1475475_molestations
nasalizations2248705nasal_izations
paginations1447755_pa_ginations
palliations1347725_pal_liations
palmation13310225_pal__mation_
palpations1437655_pal__pations
palpitations1645525_palpitations
paralyzations2783415paral_yzations
placations1438585__pl_acations
planations1238725__pl_anations
proclamations1952695proclamations
realizations21415535real_izations
reallocations1553805reallocations
reanimations1468785rea_nimations
reclamation1546355recl_amation_
relaxations1845645_rel_axations
salivations1448735_sal_ivations
saltations10310625_sal__tations
salutations1147645_sal_utations
salvations1338135_sal__vations
scalations1239785scal___ations
spallations1356105spal__lations
squamations2272745__squamations
stagflations1652865sta_gflations
stagnations1244905sta_g_nations
sublimations1646085subl_imations
validations1547245_val_idations
vallations1339085_val__lations
valuations1348785_val__uations

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.376475242.0
2DLD Change Limit1247901468.62614466.7
3Display Results1461460.0931569.9
 (SQL Overall)1786911469.09519647.2
 
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.