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) 
deconsecrations2064491deconsecrations
reconsecration1885551reconsecration
consecration1649782__consecration
deconsecrating2053632deconsecrating
reconsecrations1995082reconsecrations
consecrations1749183__consecrations
deconcentration20103603deconcentration
deconsecrate17114173deconsecrat__e
deconsecrated19113853deconsecrat_ed
deconsecrates1894043deconsecrat_es
demonstration16126283demons_tration
desecration14410063de___secration
reconsecrating1954183reconsecrating
consecrating1747944__consecrating
consecrative1957314__consecrative
consecrator1546374__consecrat_or
consecution1547304__consec_ution
conservation1749404__conservation
consociation1648194__consociation
conspiration1648374__conspiration
deceleration1547174dec_ele_ration
decerebration1884194dec_erebration
decompensation2193354decompensation
decongestion1653914deconge__stion
deconstruction19134424deconstruction
decoration13314404deco____ration
decortication1857534decortic_ation
defenestration18173544defenestration
degeneration1447284degen_e_ration
demonstrations1795674demons_trations
desecrations1559184de___secrations
exoneration1847654_exon_e_ration
reconcentration1963984reconcentration
reconnection1655984reconnec__tion
reconsecrate1694744reconsecrat__e
reconsecrated1884384reconsecrat_ed
reconsecrates1784414reconsecrat_es
reconsideration18112584reconsideration
remonstration15117124remons_tration
concentration1757995__concentration
concretion1449295__con__cretion
condemnation1746045__condemnation
condensation1546785__condensation
confection17411185__confec__tion
confederation1995245__confederation
congelation14410345__conge_lation
conjuration2049515__con_juration
connection14410535__connec__tion
conscription1855325__cons_cription
consecrate1448435__consecrat__e
consecrated1646915__consecrat_ed
consecrates1548385__consecrat_es
consecrators1656045__consecrators
consecratory1954535__consecratory
consecutions1647035__consec_utions
conservations1849085__conservations
consideration1655505__consideration
consignation15136315__consignation
consociations1747505__consociations
consolation13410985__cons_olation
conspirations1747715__conspirations
constellation1554795__constellation
consternation15106355__consternation
constipation1648565__constipation
consultation1447475__consultation
consummation1855295__consummation
contestation1448665__contestation
convection17411125__convec__tion
conversation1747805__conversation
convocation1847875__convoc_ation
cooperation15410015__coope_ration
deaeration11313015de___ae_ration
decantation1448945decan___tation
decelerations1646405dec_ele_rations
decerebrations1993725dec_erebrations
declaration1447835dec___laration
decoction1447525deco___c__tion
decollation1448195deco___llation
decolonization26146025decolonization
decolorization26136405decolorization
decompensations22103025decompensations
deconcentrating2163065deconcentrating
decondition1545415decon___dition
decongestions1753565deconge__stions
deconstructions20124355deconstructions
decontamination2083255decontamination
decorations14312835deco____rations
decortications1966765decortic_ations
decussation1444305dec_us__sation
defecation1679805de___fec_ation
defenestrations1993305defenestrations
deforestation1754295defo_restation
degenerations1546335degen_e_rations
deionization2249875deion__ization
delectation1448555de___lectation
deliberation1546365de_libe_ration
delineation1247765delin_e__ation
demonetization2655865demonetization
demonization24410935demon__ization
demonstrating17104765demons_trating
demonstrational1862635demons_trational
demonstrative1964205demons_trative
demonstrator1573915demons_trat_or
denaturation1345885de__naturation
denegation1249415de__n_e_gation
denervation1567945de__n_ervation
denigration1348465de__n_igration
denunciation1554535de__nunciation
deprecation1648955de__prec_ation
depreciation1747075de__preciation
desecrating1548095de___secrating
desecrator1346005de___secrat_or
desertion10410205de___se_r_tion
desiccation1646385de___siccation
desideration1456385de_side_ration
desperation14510115de___speration
detonation11310945deton____ation
detoxication2246205deto_xic_ation
deuteration1249105de__ute_ration
disconnection1854195disconnec__tion
disconsolation1763405discons_olation
disintegration16123775disintegration
evisceration1773005_e_visceration
execration1949825_e___xecration
exenteration1955295_exente_ration
exonerations1947005_exon_e_rations
fenestration1596075fe__nestration
generation11312425ge__n_e_ration
incineration1446285incin_e_ration
inconsideration1871865inconsideration
mensuration1346495me__ns_uration
neurosecretion1671525neurosecretion
nonconservation2063085nonconservation
penetration1349895pe__n_etration
preponderation19103225preponde_ration
recollection1654855recollec__tion
recommendation2183215recommendation
reconception1855625recon__ception
reconciliation1854115reconciliation
reconfiguration2162055reconfiguration
reconfirmation2153225reconfirmation
reconnections1765745reconnec__tions
reconstitution1663555reconstitution
reconstruction1894765reconstruction
reconversion1754025reconve_r_sion
reconviction1955085reconvic__tion
recuperation1656715rec_upe_ration
redintegration16153645redintegration
regeneration1348195regen_e_ration
reinsertion1145445re_inse_r_tion
reintegration14175375re_integration
remonstrations16116485remons_trations
remuneration1446935remun_e_ration
reoperation13410895re_o_pe_ration
unconsecrated1853305unconsecrat_ed
veneration13412335ve__n_e_ration

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 Filter178691950240.1231452772.4
2DLD Change Limit950241579.28310236.3
3Display Results1571570.1101427.3
 (SQL Overall)1786911579.51618778.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.