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

147 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
deconsecrated1911385(None) 
deconsecrate17114171deconsecrate_
deconsecrates1894041deconsecrates
reconsecrated1884391reconsecrated
consecrated1646912__consecrated
reconsecrate1694752reconsecrate_
reconsecrates1784422reconsecrates
unconsecrated1853302unconsecrated
consecrate1448433__consecrate_
consecrates1548393__consecrates
deconcentrated2093003deconcentrated
deconsecrating2053633deconsecrating
deconsecration1954783deconsecration
demonstrated16134893demons_trated
desecrated1447953de___secrated
consecrator1546384__consecrator
consociated1645214__consociated
decelerated1545924dec_ele_rated
decerebrated1853314dec_erebrated
decompensated21122894decompensated
deconcentrate1873474deconcentrate_
deconcentrates1993144deconcentrates
decongested1663074deconge__sted
deconsecrations2064514deconsecrations
deconstructed1953704deconstructed
decorated13312204deco____rated
decorticated18144164decortic_ated
defenestrated1862144defenestrated
degenerated1445744degen_e_rated
demonstrate14145914demons_trate_
demonstrates15155604demons_trates
desecrate1249084de___secrate_
desecrater1346984de___secrater
desecrates1348844de___secrates
exonerated18106004_exon_e_rated
obsecrated1543734___obsecrated
reconcentrated1983344reconcentrated
reconnected1665104reconnec__ted
reconsecrating1954194reconsecrating
reconsecration1885564reconsecration
reconverted1745654reconve_r_ted
remonstrated15145574remons_trated
concentrated17116735__concentrated
concerted14312115__conce_r_ted
concreted1439415__con__creted
confected1739075__confec__ted
confederated1953995__confederated
connected1438755__connec__ted
conscribed1743965__cons_cribed
conscripted1853435__cons_cripted
consecrating1747945__consecrating
consecration1649785__consecration
consecrative1957315__consecrative
consecrators1656055__consecrators
consecratory1954545__consecratory
consented12311945__conse__nted
conserved1538855__conse_r_ved
consociate1446855__consociate_
consociates1546545__consociates
consorted1239775__cons_or_ted
constellated15113575__constellated
consternated1554115__consternated
constipated1645465__constipated
consummated1853495__consummated
convected1738785__convec__ted
converted15311565__conve_r_ted
cooperated1567335__coope_rated
deaerated11311115de___ae_rated
decaffeinated2361125decaffeinated
decelerate1347505dec_ele_rate_
decelerates1446795dec_ele_rates
decentered1445325decente_r__ed
decerebrate1664015dec_erebrate_
decerebrates1753595dec_erebrates
decocted1437685deco___c__ted
decollated14136285deco___llated
decompensate19123635decompensate_
decompensates20113195decompensates
decontaminated20122715decontaminated
decorate11315195deco____rate_
decorates12314745deco____rates
decorticate16134635decortic_ate_
decorticates17124335decortic_ates
decussated1442895dec_us__sated
defecated1637495de___fec_ated
defenestrate1662645defenestrate_
defenestrates1762465defenestrates
degenerate1246835degen_e_rate_
degenerates1346455degen_e_rates
delectated1446725de___lectated
deliberated1545635de_libe_rated
delineated1246245delin_e__ated
demonstrator1573925demons_trator
denervated1545115de__n_ervated
denigrated1366975de__n_igrated
denitrated1298035de__n_itrated
deprecated1646675de__prec_ated
depreciated1764365de__preciated
desecraters1444815de___secraters
desecrator1346005de___secrator
deserted101012205de___se_r_ted
desiccated1644995de___siccated
desiderated1444945de_side_rated
detonated1138215deton____ated
detoxicated2253495deto_xic_ated
deuterated1247535de__ute_rated
disconcerted1854345disconce_r_ted
disconnected1853715disconnec__ted
disintegrated1662835disintegrated
eviscerated1752525_e_viscerated
execrated1938355_e___xecrated
exenterated1964795_exente_rated
exonerate16107735_exon_e_rate_
exonerates17107345_exon_e_rates
fenestrated1554245fe__nestrated
generated11310205ge__n_e_rated
incinerated1445035incin_e_rated
obsecrate1344635___obsecrate_
obsecrates1444585___obsecrates
penetrated1347305pe__n_etrated
preconcerted1953865preconce_r_ted
preponderated19233405preponde_rated
recollected1643855recollec__ted
reconcentrate1793895reconcentrate_
reconcentrates1893485reconcentrates
reconducted1744285reconduc__ted
reconferred1783665reconfe_r_red
reconsecrations1995105reconsecrations
reconsolidated18132135reconsolidated
reconstituted1653455reconstituted
reconstructed1854265reconstructed
reconsulted1454245recons__ulted
recontacted1654715recontac__ted
reconvicted1944275reconvic__ted
recuperated1645175rec_upe_rated
redintegrated1662885redintegrated
regenerated1346905regen_e_rated
reinserted1146685re_inse_r_ted
reintegrated1474495re_integrated
remonstrate13146405remons_trate_
remonstrates14146055remons_trates
remunerated1475355remun_e_rated
reoperated1348155re_o_pe_rated
unconnected1644315unconnec__ted
unconsummated2062005unconsummated
unconverted1744775unconve_r_ted
venerated1339955ve__n_e_rated

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 Filter1786911247900.1561145455.1
2DLD Change Limit1247901479.28013447.2
3Display Results1471470.0801837.5
 (SQL Overall)1786911479.51618778.0
 
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.