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

(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
reconsecrations1995101reconsecrations_
deconsecrations2064512deconsecrations_
reconsecration1885562reconsecration__
consecrations1749213__consecrations_
deconsecration1954783deconsecration__
reconsecrating1954193reconsecrati_n_g
consecration1649784__consecration__
deconsecrating2053634deconsecrati_n_g
reconnections1765754reconnec__tions_
reconsecrates1784424reconsecrat__es_
remonstrations16116494remons_trations_
consecrating1747945__consecrati_n_g
consecrators1656055__consecrat_ors_
consecutions1647055__consec_utions_
conservations1849095__conservations_
consociations1747515__consociations_
conspirations1747725__conspirations_
deconsecrates1894045deconsecrat__es_
demonstrations1795675demons_trations_
desecrations1559215de___secrations_
exonerations1947015_exon_e_rations_
preponderations20112875preponde_rations_
recollections1754725recollec__tions_
recommendations22113095recommendations_
reconcentration1963995reconcentration__
reconceptions1965125recon__ceptions_
reconciliations1953745reconciliations_
reconfirmations2283085reconfirmations_
reconnection1655995reconnec__tion__
reconsecrate1694755reconsecrat____e
reconsecrated1884395reconsecrat___ed
reconsideration18112585reconsideration__
reconstitutions1763275reconstitutions_
reconstructions19124745reconstructions_
reconversions1853865reconve_r_sions_
reconvictions2054875reconvic__tions_
recuperations1746085rec_upe_rations_
redintegrations17143255redintegrations_
regenerations1447145regen_e_rations_
reinsertions1245285re_inse_r_tions_
reintegrations15164785re_integrations_
remonstration15117125remons_tration__
remunerations1556205remun_e_rations_
reoperations14410065re_o_pe_rations_
concentrations1877076__concentrations_
concretions1549296__con__cretions_
condemnations1845406__condemnations_
condensations1646276__condensations_
confections18411396__confec__tions_
confederations20104606__confederations_
congelations1549736__conge_lations_
conjurations2148496__con_jurations_
connections15410706__connec__tions_
conscriptions1955006__cons_criptions_
consecrates1548396__consecrat__es_
consecrative1957316__consecrati__ve
consecrator1546386__consecrat_o__r
consecratory1954546__consecrat_o_ry
consecution1547316__consec_ution__
conservation1749406__conservation__
conservational1955346__conservational
conservationist2084026__conservationist
considerations1764846__considerations_
consignations16105936__consignations_
consociation1648196__consociation__
consociational1853556__consociational
consolations1449746__cons_olations_
conspiration1648386__conspiration__
conspirational1853966__conspirational
constellations1654406__constellations_
consternations16116046__consternations_
constipations1747686__constipations_
consultations1546936__consultations_
consummations1955156__consummations_
contestations1547746__contestations_
convections18411496__convec__tions_
conversations1847456__conversations_
convocations1947366__convoc_ations_
cooperations1659196__coope_rations_
decelerations1646426dec_ele_rations_
decerebrations1993746dec_erebrations_
decompensations22103046decompensations_
deconcentration20103626deconcentration__
decongestions1753566deconge__stions_
deconsecrate17114176deconsecrat____e
deconsecrated19113856deconsecrat___ed
deconstructions20124366deconstructions_
decorations14312886deco____rations_
decortications1966786decortic_ations_
defenestrations1993306defenestrations_
degenerations1546356degen_e_rations_
demonstration16126286demons_tration__
demonstrational1862636demons_trational
desecration14410076de___secration__
eviscerations1882706_e_viscerations_
execrations2048926_e___xecrations_
exenterations2054486_exente_rations_
exoneration1847656_exon_e_ration__
fenestrations1695406fe__nestrations_
generations12311426ge__n_e_rations_
incinerations1545686incin_e_rations_
mensurations1445716me__ns_urations_
neurosecretions1771406neurosecretions_
penetrations1448856pe__n_etrations_
preconceptions2253886precon__ceptions_
preconvictions2353356preconvic__tions_
preponderation19103226preponde_ration__
reannexations2052836re_anne_xations_
reassertions1253646re_asse_r_tions_
recalibrations1853696rec_alibrations_
recanalizations2657466recanalizations_
recantations1448876recan___tations_
reciprocations20203386reciproc_ations_
recodifications23165456recodifications_
recollection1654856recollec__tion__
recolonizations26165766recolonizations_
recombinations2095596reco_mbinations_
recommendation2183226recommendation__
recompilations2054956reco_mpilations_
recomputations20104106reco_mputations_
reconcentrating2063346reconcentrati_n_g
reconception1855656recon__ception__
reconciliation1854126reconciliation__
reconditions1546826recon___ditions_
reconfiguration2162056reconfiguration__
reconfirmation2153226reconfirmation__
reconnecting1745356reconnec__ti_n_g
reconstitution1663566reconstitution__
reconstruction1894776reconstruction__
reconversion1754026reconve_r_sion__
reconverting1876406reconve_r_ti_n_g
reconviction1955086reconvic__tion__
recordations1548646reco___rdations_
recreations13412256rec__re__ations_
rectifications2148916rectific_ations_
recuperation1656726rec_upe_ration__
redecorations1645086re___decorations_
redintegration16153646redintegration__
reforestations1754466refo_restations_
refrigerations1863776refrige_rations_
regeneration1348196regen_e_ration__
registrations1446906re_gis_trations_
reinfections1745326re_infec__tions_
reinfestations1793886re_infestations_
reinjections2144406re_injec__tions_
reinnervations1753446re_innervations_
reinsertion1145446re_inse_r_tion__
reinspections1753106re_inspec__tions_
reintegration14175376re_integration__
reiterations12410876re__ite_rations_
relocations13311146relo___c_ations_
remonetizations2655776remonetizations_
remonstrating1695556remons_trati_n_g
remonstrators1583566remons_trat_ors_
remuneration1446936remun_e_ration__
renaturations1355966re__naturations_
renunciations1554856re__nunciations_
reoperation13410906re_o_pe_ration__
reorientations1465216re_orientations_
representations17153896representations_
resections121513036re___sec__tions_
reservations1588586re___servations_
respirations14410306re___spirations_
restorations12410966re___storations_
reverberations19113586reverbe_rations_
revocations16410316revo___c_ations_
venerations14411316ve__n_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 Filter178691658740.326548131.9
2DLD Change Limit658741675.41012176.3
3Display Results1671670.1401192.9
 (SQL Overall)1786911675.87630410.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.