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

93 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
consecutive185594(None) 
connective1749252connec_tive
consecrative1957312consecrative
consecution1547302consecution
consecutively2383242consecutively
convective2049112convec_tive
inconsecutive2062502inconsecutive
collective1747123collec_tive
conceptive1949513conce_ptive
concoctive1646803concoc_tive
conductive1848143conduc_tive
congestive1647613conge_stive
connectives1847503connec_tives
consecutions1647043consecutions
conservative20106983conservative
constative15410103cons_tative
constitutive1754103constitutive
constructive1957443constructive
consultive1546673cons_ultive
consumptive2054223consumptive
corrective1747443correc_tive
nonconsecutive2173023nonconsecutive
nonexecutive2452873nonexecutive
persecutive1853933persecutive
coactive1598624co__ac_tive
collectives1846034collec_tives
competitive2074764competitive
conative131214624con___ative
conceive1539234con__c_eive
concertize23169354conce_rtize
concessive1745824conce_ssive
conclusive1744204con_clusive
concubine1545754con__cubine
concussive1744214con__cussive
conducive1745284con__ducive
confecting18310554confec_ting
confection17411184confec_tion
conflictive2153774conflictive
confutative1955444confutative
conjecture21134744conjec_ture
conjunctive2554434conjunctive
connectible1755254connec_tible
connecting15310384connec_ting
connection14410534connec_tion
connectively2255174connec_tively
connotative1665384connotative
conscribe1545924cons_c_ribe
consecrate1448434consec_rate
consecrating1747944consecrating
consecration1649784consecration
consecutiveness2262814consecutiveness
consenting13313214conse_nting
consequence2455014consequence
conservatives2195194conservatives
conservatize26125494conservatize
conserve1339924conse___rve
constatives1646934cons_tatives
constrictive1956624constrictive
consultative1754784consultative
consummative2164054consummative
consumptives2153114consumptives
continuative1755214continuative
contortive1546844con_tortive
contractive1849524contractive
contrastive1647294contrastive
contributive1953584contributive
contusive1445784con__tusive
convecting18310434convec_ting
convection17411124convec_tion
cooperative1847054cooperative
correctives1845574correc_tives
correlative1645544correlative
costive12312844co_s___tive
executive2164744__executive
infective17108974_infec_tive
injective2178024_injec_tive
insectile1147114_insec_tile
inspective1746404_inspec_tive
invective1798044_invec_tive
nonactive1448974non_ac_tive
nondeceptive2053734nondeceptive
nondeductive1953764nondeductive
nonelective1666854nonelec_tive
nonexecutives2561724nonexecutives
nonnegative1555174nonnegative
nonreactive1645954nonreactive
nonrelative1456834nonrelative
nonsecure1145244nonsecu__re
nonselective1755414nonselective
nonsensitive1564954nonsensitive
nonspeculative2161994nonspeculative
objective2345374_objec_tive
orective1339354_o_rec_tive

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 Filter1786911488190.420425454.8
2DLD Change Limit148819939.36015899.5
3Display Results93930.0631476.2
 (SQL Overall)178691939.84318154.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.