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

138 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
consecrating174794(None) 
consecration1649782consecration
consecrations1749212consecrations
consecrative1957312consecrative
consociating1755572consociating
deconsecrating2053632deconsecrating
obsecrating1644132_obsecrating
reconsecrating1954192reconsecrating
concentrating1856433concentrating
concerting15313893conce_r_ting
concreting1539873con__creting
confecting18310553confec__ting
confederating2054013confederating
connecting15310383connec__ting
conscribing1853903cons_cribing
conscripting1954023cons_cripting
consecrate1448433consecrat__e
consecrated1646913consecrat_ed
consecrates1548393consecrat_es
consecrator1546383consecrat_or
consecrators1656053consecrators
consecratory1954543consecratory
consenting13313223conse__nting
conserving1639763conse_r_ving
consorting13410743cons_or_ting
constellating1653263constellating
consternating1654973consternating
constipating1775393constipating
consummating1953663consummating
convecting18310433convec__ting
converting16313133conve_r_ting
cooperating1648423coope_rating
desecrating1548093_desecrating
caseating12311744c_ase__ating
castrating1349774c_as_trating
celebrating1646114c_elebrating
cerebrating1646664c_erebrating
cocreating15310294co___creating
coequating2245324co__equating
coerecting15218784coerec__ting
coexerting2045494coexe_r_ting
coinfecting1944574coinfec__ting
collecting1548284collec__ting
collocating1645904colloc_ating
colocating1548624co_loc_ating
commemorating1953074commemorating
commentating1957044commentating
commiserating2053194commise_rating
compensating1955004compensating
concaving1737354con__c_aving
concealing1549304con__cealing
conceiting15311774con__ceiting
concelebrating2172594concelebrating
concerning1548904conce_r_ning
concertina14410614conce_r_tina
concertino14910844conce_r_tino
conciliating1775614conciliating
concocting1448414con__cocting
conducting1648834conduc__ting
conferring1648744confe_r_ring
confiscating2053614confiscating
conflating16410004con__flating
congealing1447634conge__aling
congesting14410114conge__sting
conglobating1853164conglobating
congregating1754284congregating
conjecturing2452794conjecturing
conjugating2244504con_jugating
consecution1547314consec_ution
consecutions1647054consec_utions
consecutive1855954consec_utive
conservation1749404conservation
conservations1849094conservations
conservatism19104954conservatism
conservative20106994conservative
conservatize26125504conservatize
conservatizing2983094conservatizing
consisting1349524cons__isting
consociation1648194consociation
consociations1747514consociations
consolidating1753284consolidating
conspiration1648384conspiration
conspirations1747724conspirations
conspiring1546554conspir__ing
constituting1554654constituting
constrain1149334cons_tra_in_
constraining1554544cons_training
constrains1249724cons_tra_ins
constraint12411134cons_tra_int
constricting1747024constricting
constructing1746754constructing
construing1347444cons_tr_uing
consulting1349084cons__ulting
contacting15610074contac__ting
contemplating2054124contemplating
contenting13313324conte__nting
contesting13312214conte__sting
contorting13410104con_tor_ting
contracting16610474con__tracting
contrasting1459354con__trasting
conventing16311544conve__nting
converging1758094conve_r_ging
conversing16310544conve_r_sing
convicting1847584convic__ting
corelating13511584co_re_lating
correcting15199304correc__ting
correlating1487084corre_lating
corseting12312174corse___ting
coruscating1644694corusc_ating
coscripting1843904co_s_cripting
cosseting1239544cosse___ting
counteracting1856284counte_racting
deconsecration1954784deconsecration
deconsecrations2064514deconsecrations
eviscerating1852674eviscerating
execrating2047884__execrating
exonerating1945554exon_e_rating
generating12310384gen_e_rating
inserting10914244_inse_r_ting
integrating1349494_integrating
moderating1448804mo_de_rating
nondecreasing1762094nondecreasing
nonoperating1555414nonoperating
nonsporting1444824nonspor_ting
operating12313724_o_pe_rating
overrating14814204_o_verrating
penetrating1447664pen_etrating
reconsecration1885564reconsecration
reconsecrations1995104reconsecrations
recrating121318794___recrating
secreting1279824___secreting
serrating10513204___serrating
sonicating1348314son_ic_ating
tolerating1148594to_le_rating
uncrating12813184_un__crating
underrating1388254_underrating
unseating10713204_unse__ating
venerating14410054ven_e_rating

Search took 8 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.376475242.0
2DLD Change Limit1247901387.26617174.5
3Display Results1381380.0931483.9
 (SQL Overall)1786911387.73523101.6
 
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.