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

140 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
conflagration195301(None) 
conflagrations2052721conflagrations
confederation1995253confederation
configuration1954133configuration
conflation15412083confl___ation
deflagration1773473_deflagration
collaboration1763004co_llaboration
colligation1457454co_llig_ation
coloration12913184co__l_oration
concelebration20133564concelebration
concentration1758014concentration
confabulation2063304confabulation
confederations20104604confederations
configurations2063704configurations
confirmation1946184conf_irmation
confiscation1945534conf_iscation
conflagrant1752074conflagra__nt
conflations16411144confl___ations
confliction1845234confl__iction
conformation1947324conf_ormation
confrontation1853224confrontation
confutation1668724conf__utation
conglobation1754254congl_obation
conglomeration1963004conglomeration
congregation16226764congreg_ation
conjugation2146624con_jug_ation
conjuration2049514con__juration
consecration1649784con_secration
consideration1655524consideration
consignation15136314con_signation
conspiration1648384con_spiration
deflagrations1883024_deflagrations
inflammation19132884_inflammation
calibration1545995c__alibration
canalization23411165canal_ization
celebration1546465c__elebration
clavation1447005c___la_vation
coadaptation1751965co_adaptation
coagulation1447275co___agulation
coaptation1448345co___aptation
cocultivation2053055cocultivation
cogeneration1546445co_generation
cognation12310755co____gnation
collaborations1872745co_llaborations
collation11313995co__l__lation
colligations1556845co_llig_ations
collimation1557575co__llimation
collocation1547175co__llocation
colorations13911895co__l_orations
commemoration1853885commemoration
commiseration1964045commiseration
complexation25144245compl_exation
complication2048205compl_ication
compurgation19134185compurg_ation
conation101420885con_____ation
concatenation1764095concatenation
concelebrations21103165concelebrations
concentrations1877075concentrations
conciliation1648235con_ciliation
concretion1449295con___cretion
condemnation1746045con_demnation
condensation1546785con_densation
condonation1448855con__donation
confabulations2162805confabulations
confection17411185conf___ection
confederating2054015confederating
confederative2253755confederative
configurational2162205configurational
configurative2262815configurative
confirmations2055675conf_irmations
confiscations2044955conf_iscations
conflating16410005confl___ating
conflictions1945225confl__ictions
conformations2046725conf_ormations
confrontations1962785confrontations
confutations1767795conf__utations
congelation14410345con__gelation
congestion1349045con___gestion
conglobations1853945congl_obations
conglomerations2062735conglomerations
conglutination1762785conglutination
congratulation1782825congratulation
congregations17186415congreg_ations
conjugations2245865con_jug_ations
conjurations2148495con__jurations
connation11314265con____nation
connotation1347985con__notation
consecrations1749215con_secrations
conservation1749405con_servation
considerations1764845considerations
consignations16105935con_signations
consociation1648195con_sociation
consolation13410985con__solation
consolidation1655155consolidation
conspirations1747725con_spirations
constellation1554805constellation
consternation15106365consternation
constipation1648565con_stipation
consultation1447475con_sultation
consummation1855295con_summation
contagion1246995con_tag___ion
contamination1766955contamination
contemplation1985265contemplation
contestation1448665con_testation
continuation1448195con_tinuation
contortion1248665con__tor_tion
contraception1953755contraception
contraction15411245contra__ction
contradiction1854565contradiction
contraption1548105contra__ption
contravention18103875contravention
contrition12411415con___trition
conurbation1547465con__urbation
conversation1747805con_versation
convocation1847885con__vocation
cooperation15410025co__operation
copulation141111955copul___ation
corporation151210655co__rporation
corroboration1782825corroboration
corrugation1445995co_rrug_ation
covariation1646775co__variation
declaration1447835_decla_ration
deflagrating1852665_deflagrating
defloration1547265_defl_oration
denigration1348465den__igration
exhilaration2252525exhila_ration
homologation18122655homolog_ation
indagation1246155_in_dag_ation
infarction1545795_inf_a_rction
infatuation1444935_inf_atuation
infiltration1554525_infiltration
inflammations20102545_inflammations
inflation12311095_infl___ation
instauration12114835_instauration
integration121310495_in_tegration
narration9310065__n__arration
noncelebration18113315noncelebration
obligation1346785_o_blig_ation
reconfiguration2162055reconfiguration
toleration1048965to__l_eration

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 Limit1247901409.34613352.2
3Display Results1401400.0931505.4
 (SQL Overall)1786911409.82918180.0
 
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.