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

171 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
reconsecration188556(None) 
deconsecration1954781deconsecration
reconsecrations1995101reconsecrations
consecration1649782__consecration
deconsecrations2064512deconsecrations
reconsecrating1954192reconsecrating
consecrations1749213__consecrations
deconsecrating2053633deconsecrating
reconcentration1963993reconcentration
reconnection1655993reconnec__tion
reconsecrate1694753reconsecrat__e
reconsecrated1884393reconsecrat_ed
reconsecrates1784423reconsecrat_es
reconsideration18112583reconsideration
remonstration15117123remons_tration
consecrating1747944__consecrating
consecrative1957314__consecrative
consecrator1546384__consecrat_or
consecution1547304__consec_ution
conservation1749404__conservation
consociation1648194__consociation
conspiration1648384__conspiration
deconcentration20103624deconcentration
deconsecrate17114174deconsecrat__e
deconsecrated19113854deconsecrat_ed
deconsecrates1894044deconsecrat_es
demonstration16126284demons_tration
desecration14410074de___secration
exoneration1847654_exon_e_ration
preponderation19103224preponde_ration
recollection1654854recollec__tion
recommendation2183224recommendation
reconception1855644recon__ception
reconciliation1854124reconciliation
reconfiguration2162054reconfiguration
reconfirmation2153224reconfirmation
reconnections1765754reconnec__tions
reconstitution1663564reconstitution
reconstruction1894774reconstruction
reconversion1754024reconve_r_sion
reconviction1955084reconvic__tion
recuperation1656724rec_upe_ration
redintegration16153644redintegration
regeneration1348194regen_e_ration
reinsertion1145444re_inse_r_tion
reintegration14175374re_integration
remonstrations16116484remons_trations
remuneration1446934remun_e_ration
reoperation13410904re_o_pe_ration
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
deceleration1547175dec_ele_ration
decerebration1884195dec_erebration
decompensation2193365decompensation
decongestion1653925deconge__stion
deconstruction19134435deconstruction
decoration13314425deco____ration
decortication1857535decortic_ation
defenestration18173545defenestration
degeneration1447285degen_e_ration
demonstrations1795675demons_trations
desecrations1559215de___secrations
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
precancellation2161165precancellation
preconception2154285precon__ception
preconvention2074005preconve__ntion
preconviction2253705preconvic__tion
preponderations20112875preponde_rations
reannexation1953165re_anne_xation
reassertion1154025re_asse_r_tion
recalibration1754435rec_alibration
recanalization2557675recanalization
recantation1349865recan___tation
reciprocation19183495reciproc_ation
recodification22125665recodification
recollections1754725recollec__tions
recolonization25155885recolonization
recombination19106175reco_mbination
recommendations22113095recommendations
recompilation1955155reco_mpilation
recomputation1974395reco_mputation
reconcentrating2063345reconcentrating
reconceptions1965125recon__ceptions
reconciliations1953745reconciliations
recondition1447125recon___dition
reconfirmations2283085reconfirmations
reconnecting1745355reconnec__ting
reconstitutions1763275reconstitutions
reconstructions19124735reconstructions
recontamination1983545recontamination
reconversions1853865reconve_r_sions
reconverting1876405reconve_r_ting
reconvictions2054875reconvic__tions
recordation1449265reco___rdation
recreation12413615rec__re__ation
rectification2049515rectific_ation
recuperations1746085rec_upe_rations
redecoration1546015re___decoration
redintegrations17143255redintegrations
reforestation1654575refo_restation
refrigeration1764155refrige_ration
regenerations1447145regen_e_rations
registration1347535re_gis_tration
reinfection1645445re_infec__tion
reinfestation1664255re_infestation
reinjection2044585re_injec__tion
reinnervation1653625re_innervation
reinsertions1245275re_inse_r_tions
reinspection1653265re_inspec__tion
reintegrations15164785re_integrations
reiteration11412165re__ite_ration
relocation12312115relo___c_ation
remonetization2555885remonetization
remonstrating1695555remons_trating
remonstrative1874575remons_trative
remonstrator1474085remons_trat_or
remunerations1556205remun_e_rations
renaturation1256755re__naturation
renunciation1455315re__nunciation
reoperations14410065re_o_pe_rations
reorientation1375595re_orientation
representation16154125representation
resection111613275re___sec__tion
reservation1489145re___servation
respiration13511195re___spiration
restoration11412095re___storation
reverberation1893885reverbe_ration
revocation15410815revo___c_ation
unconsecrated1853305unconsecrat_ed
veneration13412345ve__n_e_ration

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 Filter178691950240.1061685764.2
2DLD Change Limit950241717.36012910.9
3Display Results1711710.1261357.1
 (SQL Overall)1786911717.59223536.7
 
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.