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

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

88 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
coronations1341070(None) 
coronation12412071coronation_
corotations1349761corotations
carbonations1644842carbonations
carnations12311352car_nations
cognations1339592co_gnations
colorations13911892colorations
conations111318902c__onations
condonations1548002condonations
connations12312942co_nnations
coronating13410172coronati_ng
corotation12410972corotation_
corporations16129482corporations
crenations12511692c_renations
ozonations1945142_ozonations
pronations12314032_pronations
abrogations14116463abrogations
arrogations12126483arrogations
carbonation1545853carbonation_
carnation11312943car_nation_
catenations1348363catenations
chlorinations1855533chlorinations
chromatins1749123chromati_ns
coaptations1547543coaptations
coarctations16114493coarctations
cofunctions1845013cofunctions
cogitations1448903cogitations
cognation12310753co_gnation_
cognitions1346043co_gnitions
collations12312853co_llations
collocations1646403collocations
colonisations15216173colonisations
colonizations24229423colonizations
coloration12913183coloration_
combinations1897923combinations
comminations18810483comminations
conation101420883c__onation_
condonation1448853condonation_
conflations16411143conflations
confrontations1962783confrontations
connation11314263co_nnation_
connotations1447283connotations
consolations1449743consolations
convocations1947363convocations
cooptions13107763co_o_ptions
coordinations1684993coordinations
copulations151111113copulations
coronaries12410233coronari_es
coronates1110816923coronat__es
corotating1349323corotati_ng
corporation151210653corporation_
corrasions1246353cor_rasions
corrections1548863corrections
correlations1447863correlations
corrugations1565483corrugations
corruptions1555173corruptions
coruscations1645243coruscations
creations112614543c_r_eations
cremations14410713c_remations
crenation11412923c_renation_
darnations1138413dar_nations
derogations1349393derogations
detonations1239373detonations
dominations14611043dominations
donations101112353__donations
formations1538203for_mations
intonations1149523intonations
iodinations1268843iodinations
marinations13411273marinations
morulations13148163morulations
nominations13410533nominations
orations81515803_or__ations
ordinations1247993_ordinations
ozonation1845673_ozonation_
perorations13314063perorations
personations1448393personations
phonations1538313_phonations
probations14311083_probations
pronation11415703_pronation_
prorations12314463_prorations
prorogations1556723prorogations
protonations1449073protonations
rogations101510823__rogations
rotations91613843__rotations
tarnations1038903tar_nations
urinations10310693_urinations
vernations13310333ver_nations
zonations18139313__zonations

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 Filter1786911216330.436409841.7
2DLD Change Limit121633885.92320535.7
3Display Results88880.0461913.0
 (SQL Overall)178691886.40527898.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.