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

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

97 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
consecrative195731(None) 
consecrate1448432consecrat__e
consecrating1747942consecrating
consecration1649782consecration
consecutive1855952consec_utive
conservative20106992conservative
concentrative2056213concentrative
confederative2253753confederative
connective1749253connec__tive
consecrated1646913consecrat_ed
consecrates1548393consecrat_es
consecrations1749213consecrations
consecrator1546383consecrat_or
consecrators1656053consecrators
consecratory1954543consecratory
conservatives2195193conservatives
conservatize26125503conservatize
constative15410103cons__tative
consultative1754783consultative
consummative2164053consummative
convective2049113convec__tive
cooperative1847053coope_rative
collective1747124collec__tive
commemorative2163044commemorative
commiserative2283274commise_rative
comparative20176214co_mparative
compensative2154654compensative
conative131214624con____ative
conceptive1949514con__ceptive
concertize23169354conce_r_tize
conciliative1954164conciliative
concoctive1646804con__coctive
concretize23166714con__cretize
conductive1848144conduc__tive
configurative2262814configurative
confutative1955444con_futative
congestive1647614conge__stive
connectives1847504connec__tives
connotative1665384con_notative
conscribe1545924cons_cr__ibe
consecution1547314consec_ution
consecutively2383254consec_utively
conservation1749404conservation
conservatism19104954conservatism
conservatively25133874conservatively
conservatized28113604conservatized
conservatizes27114454conservatizes
conservatoire1862764conservatoire
conserve1339934conse_r___ve
consociate1446854consociat__e
consociating1755574consociating
consociation1648194consociation
conspiration1648384conspiration
constatives1646934cons__tatives
constitutive1754104constitutive
constrictive1956624constrictive
constructive1957444constructive
consultive1546674cons__ultive
consumptive2054224cons_umptive
contemplative22123704contemplative
continuative1755214continuative
contortive1546844con_tor_tive
contractive1849524con__tractive
contrastive1647294con__trastive
cooperatives1965554coope_ratives
corporative1847154co_rporative
corrective1747444correc__tive
correlative1645544corre_lative
counteractive2055954counte_ractive
cunctative1744504cun__ctative
deconsecrate17114174deconsecrat__e
deconsecrating2053634deconsecrating
deconsecration1954784deconsecration
execrative2246044__execrative
exonerative2155394exon_e_rative
generative1458574gen_e_rative
inconsecutive2062504inconsec_utive
inoperative1646754inope_rative
integrative1547124_integrative
noncreative1648234non__creative
nondeceptive2053734nondeceptive
nonnarrative1553834nonnarrative
nonnegative1555174nonne_gative
nonoperative1756284nonoperative
nonrelative1456834nonre_lative
nonselective1755414nonselective
nonsensitive1564954nonsensitive
nonspeculative2161994nonspeculative
obsecrate1344644_obsecrat__e
obsecrating1644134_obsecrating
operative141110554_o_pe_rative
penetrative1646114pen_etrative
reconsecrate1694754reconsecrat__e
reconsecrating1954194reconsecrating
reconsecration1885564reconsecration
secretive1446934___secretive
tolerative1346254to_le_rative

Search took 9 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.406440125.6
2DLD Change Limit124790978.14315324.8
3Display Results97970.0462108.7
 (SQL Overall)178691978.59520790.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.