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

137 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
conflagrations205272(None) 
conflagration1953011conflagration_
confederations20104603confederations
configurations2063703configurations
conflations16411143confl___ations
deflagrations1883023_deflagrations
collaborations1872744co_llaborations
colligations1556844co_llig_ations
colorations13911894co__l_orations
concelebrations21103164concelebrations
concentrations1877074concentrations
confabulations2162804confabulations
confederation1995254confederation_
configuration1954134configuration_
confirmations2055674conf_irmations
confiscations2044954conf_iscations
conflagrant1752074conflagra___nt
conflation15412084confl___ation_
conflictions1945224confl__ictions
conformations2046724conf_ormations
confrontations1962784confrontations
confutations1767794conf__utations
conglobations1853944congl_obations
conglomerations2062734conglomerations
congregations17186414congreg_ations
conjugations2245864con_jug_ations
conjurations2148494con__jurations
consecrations1749214con_secrations
considerations1764844considerations
consignations16105934con_signations
conspirations1747724con_spirations
deflagration1773474_deflagration_
inflammations20102544_inflammations
calibrations1645155c__alibrations
canalizations24410435canal_izations
celebrations1645745c__elebrations
clavations1546185c___la_vations
coadaptations1851685co_adaptations
coagulations1546515co___agulations
coaptations1547545co___aptations
cocultivations2152765cocultivations
cogenerations1655915co_generations
cognations1339595co____gnations
collaboration1763005co_llaboration_
collations12312855co__l__lations
colligation1457455co_llig_ation_
collimations1656875co__llimations
collocations1646405co__llocations
coloration12913185co__l_oration_
commemorations1953445commemorations
commiserations2053455commiserations
complexations26134015compl_exations
complications2147435compl_ications
compurgations20123895compurg_ations
conations111318905con_____ations
concatenations1873725concatenations
concelebration20133565concelebration_
concentration1758015concentration_
conciliations1747205con_ciliations
concretions1549295con___cretions
condemnations1845405con_demnations
condensations1646275con_densations
condonations1548005con__donations
confabulation2063305confabulation_
confections18411395conf___ections
confederating2054015confederati_ng
configurational2162205configurational
confirmation1946185conf_irmation_
confiscation1945535conf_iscation_
conflating16410005confl___ati_ng
confliction1845235confl__iction_
conformation1947325conf_ormation_
confrontation1853225confrontation_
confutation1668725conf__utation_
congelations1549735con__gelations
congestions1449315con___gestions
conglobation1754255congl_obation_
conglomeration1963005conglomeration_
conglutinations1862545conglutinations
congratulations1882785congratulations
congregation16226765congreg_ation_
conjugation2146625con_jug_ation_
conjuration2049515con__juration_
connations12312945con____nations
connotations1447285con__notations
consecration1649785con_secration_
conservations1849095con_servations
consideration1655525consideration_
consignation15136315con_signation_
consociations1747515con_sociations
consolations1449745con__solations
consolidations1754745consolidations
conspiration1648385con_spiration_
constellations1654405constellations
consternations16116045consternations
constipations1747685con_stipations
consultations1546935con_sultations
consummations1955155con_summations
contagions1346605con_tag___ions
contaminations1886105contaminations
contemplations2074735contemplations
contestations1547735con_testations
continuations1547145con_tinuations
contortions1348685con__tor_tions
contraceptions2053385contraceptions
contractions16410405contra__ctions
contradictions1954145contradictions
contraptions1647645contra__ptions
contraventions19103575contraventions
contritions13410915con___tritions
conurbations1646665con__urbations
conversations1847455con_versations
convocations1947365con__vocations
cooperations1659195co__operations
copulations151111115copul___ations
corporations16129485co__rporations
corroborations1882625corroborations
corrugations1565485co_rrug_ations
covariations1745985co__variations
declarations1546805_decla_rations
deflagrating1852665_deflagrati_ng
deflorations1646065_defl_orations
denigrations1447355den__igrations
exhilarations2352415exhila_rations
homologations19102355homolog_ations
indagations1345405_in_dag_ations
infarctions1645025_inf_a_rctions
infatuations1544435_inf_atuations
infiltrations1653905_infiltrations
inflammation19132885_inflammation_
inflations13310325_infl___ations
instaurations13114255_instaurations
integrations13129475_in_tegrations
narrations1038945__n__arrations
noncelebrations19122825noncelebrations
obligations1446145_o_blig_ations
tolerations1158135to__l_erations

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.343520965.0
2DLD Change Limit950241376.25015203.8
3Display Results1371370.0931473.1
 (SQL Overall)1786911376.68626726.1
 
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.