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

157 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
deconsecration195478(None) 
deconsecrations2064511deconsecrations
reconsecration1885561reconsecration
consecration1649782__consecration
deconsecrating2053632deconsecrating
reconsecrations1995102reconsecrations
consecrations1749213__consecrations
deconcentration20103623deconcentration
deconsecrate17114173deconsecrat__e
deconsecrated19113853deconsecrat_ed
deconsecrates1894043deconsecrat_es
demonstration16126283demons_tration
desecration14410073de___secration
reconsecrating1954193reconsecrating
consecrating1747944__consecrating
consecrative1957314__consecrative
consecrator1546384__consecrat_or
consecution1547304__consec_ution
conservation1749404__conservation
consociation1648194__consociation
conspiration1648384__conspiration
deceleration1547174dec_ele_ration
decerebration1884194dec_erebration
decompensation2193364decompensation
decongestion1653924deconge__stion
deconstruction19134434deconstruction
decoration13314424deco____ration
decortication1857534decortic_ation
defenestration18173544defenestration
degeneration1447284degen_e_ration
demonstrations1795674demons_trations
desecrations1559214de___secrations
exoneration1847654_exon_e_ration
reconcentration1963994reconcentration
reconnection1655994reconnec__tion
reconsecrate1694754reconsecrat__e
reconsecrated1884394reconsecrat_ed
reconsecrates1784424reconsecrat_es
reconsideration18112584reconsideration
remonstration15117124remons_tration
concentration1758015__concentration
concretion1449295__con__cretion
condemnation1746045__condemnation
condensation1546785__condensation
confection17411185__confec__tion
confederation1995255__confederation
congelation14410345__conge_lation
conjuration2049515__con_juration
connection14410535__connec__tion
conscription1855335__cons_cription
consecrate1448435__consecrat__e
consecrated1646915__consecrat_ed
consecrates1548395__consecrat_es
consecrators1656055__consecrators
consecratory1954545__consecratory
consecutions1647045__consec_utions
conservations1849095__conservations
consideration1655525__consideration
consignation15136315__consignation
consociations1747515__consociations
consolation13410985__cons_olation
conspirations1747725__conspirations
constellation1554795__constellation
consternation15106365__consternation
constipation1648565__constipation
consultation1447475__consultation
consummation1855295__consummation
contestation1448665__contestation
convection17411125__convec__tion
conversation1747805__conversation
convocation1847885__convoc_ation
cooperation15410025__coope_ration
deaeration11313015de___ae_ration
decantation1448945decan___tation
decelerations1646425dec_ele_rations
decerebrations1993745dec_erebrations
declaration1447835dec___laration
decoction1447525deco___c__tion
decollation1448195deco___llation
decolonization26146025decolonization
decolorization26136415decolorization
decompensations22103045decompensations
deconcentrating2163085deconcentrating
decondition1545415decon___dition
decongestions1753565deconge__stions
deconstructions20124365deconstructions
decontamination2083255decontamination
decorations14312885deco____rations
decortications1966775decortic_ations
decussation1444305dec_us__sation
defecation1679805de___fec_ation
defenestrations1993305defenestrations
deforestation1754305defo_restation
degenerations1546355degen_e_rations
deionization2249885deion__ization
delectation1448555de___lectation
deliberation1546365de_libe_ration
delineation1247765delin_e__ation
demonetization2655875demonetization
demonization24410945demon__ization
demonstrating17104765demons_trating
demonstrational1862635demons_trational
demonstrative1964215demons_trative
demonstrator1573925demons_trat_or
denaturation1345885de__naturation
denegation1249415de__n_e_gation
denervation1567945de__n_ervation
denigration1348465de__n_igration
denunciation1554535de__nunciation
deprecation1648965de__prec_ation
depreciation1747075de__preciation
desecrating1548095de___secrating
desecrator1346005de___secrat_or
desertion10410205de___se_r_tion
desiccation1646385de___siccation
desideration1456395de_side_ration
desperation14510115de___speration
detonation11310945deton____ation
detoxication2246205deto_xic_ation
deuteration1249105de__ute_ration
disconnection1854205disconnec__tion
disconsolation1763415discons_olation
disintegration16123785disintegration
evisceration1773005_e_visceration
execration1949835_e___xecration
exenteration1955295_exente_ration
exonerations1947015_exon_e_rations
fenestration1596075fe__nestration
generation11312425ge__n_e_ration
incineration1446295incin_e_ration
inconsideration1871865inconsideration
mensuration1346495me__ns_uration
neurosecretion1671525neurosecretion
nonconservation2063095nonconservation
penetration1349895pe__n_etration
preponderation19103225preponde_ration
recollection1654855recollec__tion
recommendation2183225recommendation
reconception1855645recon__ception
reconciliation1854125reconciliation
reconfiguration2162055reconfiguration
reconfirmation2153225reconfirmation
reconnections1765755reconnec__tions
reconstitution1663565reconstitution
reconstruction1894775reconstruction
reconversion1754025reconve_r_sion
reconviction1955085reconvic__tion
recuperation1656725rec_upe_ration
redintegration16153645redintegration
regeneration1348195regen_e_ration
reinsertion1145445re_inse_r_tion
reintegration14175375re_integration
remonstrations16116485remons_trations
remuneration1446935remun_e_ration
reoperation13410905re_o_pe_ration
unconsecrated1853305unconsecrat_ed
veneration13412345ve__n_e_ration

Search took 7 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.360496363.9
2DLD Change Limit950241576.03315750.7
3Display Results1571570.1061481.1
 (SQL Overall)1786911576.49927495.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.