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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 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
consecrations174921(None) 
consecration1649781consecration_
consecrating1747942consecrati_ng
consecrators1656052consecrat_ors
consecutions1647042consec_utions
conservations1849092conservations
consociations1747512consociations
conspirations1747722conspirations
deconsecrations2064512deconsecrations
reconsecrations1995102reconsecrations
concentrations1877073concentrations
concretions1549293con__cretions
condemnations1845403condemnations
condensations1646273condensations
confections18411393confec__tions
confederations20104603confederations
congelations1549733conge_lations
conjurations2148493con_jurations
connections15410703connec__tions
conscriptions1955003cons_criptions
consecrates1548393consecrat__es
consecrative1957313consecrati_ve
consecrator1546383consecrat_o_r
consecratory1954543consecrat_ory
consecution1547303consec_ution_
conservation1749403conservation_
considerations1764843considerations
consignations16105933consignations
consociation1648193consociation_
consolations1449733cons_olations
conspiration1648383conspiration_
constellations1654403constellations
consternations16116043consternations
constipations1747683constipations
consultations1546933consultations
consummations1955153consummations
contestations1547733contestations
convections18411493convec__tions
conversations1847453conversations
convocations1947363convoc_ations
cooperations1659193coope_rations
deconsecration1954783deconsecration_
desecrations1559213_desecrations
reconsecration1885563reconsecration_
botherations1754194bothe_rations
cancelations1657094cance_lations
cancellations1754394cancellations
caseations1258304c_ase__ations
castrations13410054c_as_trations
celebrations1645744c_elebrations
cerebrations1646964c_erebrations
coacervations2053874coacervations
coarctations16114494co_arctations
coeducations1745874coeduc_ations
cogenerations1655914cogenerations
collections1547934collec__tions
collocations1646404colloc_ations
colorations13911894co__lorations
commemorations1953444commemorations
commendations2055804commendations
commiserations2053454commise_rations
compellations1954804compellations
compensations19136184compensations
conations111318904con____ations
concelebrations21103164concelebrations
concentration1758014concentration_
conceptions17410594con__ceptions
concertinos15158124conce_r_tinos
conciliations1747204conciliations
concoctions1448254con__coctions
concretion1449294con__cretion_
condemnation1746044condemnation_
condensation1546784condensation_
condonations1548004con_donations
conductions1649664conduc__tions
confection17411184confec__tion_
confederation1995254confederation_
configurations2063704configurations
confirmations2055674confirmations
confiscations2044954confiscations
conflagrations2052724conflagrations
conflations16411144con__flations
conformations2046724conformations
confutations1767794con_futations
congelation14410344conge_lation_
congestions1449314conge__stions
conglobations1853944conglobations
congregations17186414congregations
conjugations2245864con_jugations
conjuration2049514con_juration_
connations12312944con___nations
connection14410534connec__tion_
connotations1447284con_notations
conscription1855334cons_cription_
consecrate1448434consecrat___e
consecrated1646914consecrat__ed
conservational1955334conservational
conservationist2084024conservationist
conservatisms2083534conservatisms
conservatives2195194conservatives
conservatizes27114454conservatizes
conservators1755974conservat_ors
consideration1655524consideration_
consignation15136314consignation_
consociating1755574consociati_ng
consociational1853544consociational
consolation13410984cons_olation_
consolidations1754744consolidations
conspirational1853954conspirational
conspirators1655534conspirat_ors
constellation1554794constellation_
consternation15106364consternation_
constipation1648564constipation_
constitutions1554864constitutions
constrains1249724cons_tra_i_ns
constrictions1747784constrictions
constructions1747714constructions
consultation1447474consultation_
consummation1855294consummation_
consumptions1845144cons_umptions
contemplations2074734contemplations
contentions13412094conte__ntions
contestation1448664contestation_
continuations1547144continuations
contortions1348684con_tor_tions
contractions16410404con__tractions
contraptions1647644con__traptions
contritions13410914con__tritions
conurbations1646664con_urbations
convection17411124convec__tion_
conventions16410534conve__ntions
conversation1747804conversation_
conversions1648274conve_r_sions
convictions1848044convic__tions
convocation1847884convoc_ation_
cooperation15410024coope_ration_
corporations16129484co_rporations
corrections1548864correc__tions
correlations1447864corre_lations
coruscations1645244corusc_ations
counteractions1855024counte_ractions
cunctations1576154cun__ctations
deconsecrating2053634deconsecrati_ng
desecration14410074_desecration_
eviscerations1882704eviscerations
execrations2048924__execrations
exonerations1947014exon_e_rations
fenestrations1695404fenestrations
generations12311424gen_e_rations
insertions10410344_inse_r_tions
inspirations1447304_inspirations
integrations13129474_integrations
mensurations1445714mens_urations
moderations1448274mo_de_rations
nonsecretors1452724nonsecret_ors
nonsegregations17162694nonsegregations
obscurations1644024_obscurations
obsecrating1644134_obsecrati_ng
observations1785014_observations
operations12312954_o_pe_rations
penetrations1448854pen_etrations
reconsecrating1954194reconsecrati_ng
secretions12117844___secretions
serrations10313094___serrations
sonications1349954son_ic_ations
tolerations1158134to_le_rations
venerations14411314ven_e_rations

Search took 6 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.1261418182.5
2DLD Change Limit950241675.11018595.7
3Display Results1671670.1101518.2
 (SQL Overall)1786911675.34633425.2
 
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.