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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

182 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
consecrates154839(None) 
consecrate1448431consecrate_
consecrated1646911consecrated
consecrator1546382consecrator
consecrators1656052consecrators
consociates1546542consociates
deconsecrates1894042deconsecrates
obsecrates1444582_obsecrates
reconsecrates1784422reconsecrates
concentrates16118213concentrates
concretes13411473con__cretes
condensates1445313condensates
conepates13912283con_e_pates
confederates1854623confederates
conscribes1645193cons_cribes
consecrating1747943consecrating
consecration1649783consecration
consecrations1749213consecrations
consecrative1957313consecrative
consecratory1954543consecratory
conserves14311193conse_r_ves
consociate1446853consociate_
consociated1645213consociated
constellates14174233constellates
consternates1455053consternates
constipates1546353constipates
consulates12711103cons_ulates
consummates1754203consummates
cooperates1469613coope_rates
deconsecrate17114173deconsecrate_
deconsecrated19113853deconsecrated
desecrates1348843_desecrates
nonsecrets1285293nonsecret_s
obsecrate1344643_obsecrate_
obsecrated1543733_obsecrated
reconsecrate1694753reconsecrate_
reconsecrated1884393reconsecrated
unconsecrated1853303unconsecrated
canebrakes1843554can_ebrakes
caseates10313714c_ase__ates
caseinates1247444c_aseinates
casemates1349524c_ase_mates
castrates11312674c_as_trates
celebrates1447674c_elebrates
cerates95428254c___e_rates
cerebrates1447914c_erebrates
coacervates1883594coacervates
cocreates132611884co___creates
coequates2045854co__equates
collocates1448124colloc_ates
colocates13312854co_loc_ates
commemorates1753574commemorates
commentates17107614commentates
commiserates1853604commise_rates
compensates1745724compensates
concaves1538914con__c_aves
concelebrates19113584concelebrates
concentrate15118354concentrate_
concentrated17116734concentrated
concerted14312114conce_r_ted
concertos132711134conce_r_tos
concerts123016064conce_r_t_s
conciliates1546884conciliates
conclaves1646544con__claves
concrete12411084con__crete_
concreted1439414con__creted
condensate1345544condensate_
conelrads1244264con_elra_ds
conepate12712534con_e_pate_
conepatls1385344con_e_patls
confected1739074confec__ted
confects153110874confec__t_s
confederate1754834confederate_
confederated1953994confederated
conferees14610624confe_r_ees
conferrals1545404conferra_ls
conferrees1546104confe_rrees
confiscates1854044confiscates
conflates14311134con__flates
congeries12316404conge_r_ies
conglobates1653324conglobates
congrats11311434con__grat_s
congregates1545504congregates
conjectures22134894conjectures
conjugates2044694con_jugates
connected1438754connec__ted
connecter1349054connec__ter
connecters1448014connec__ters
connectives1847504connectives
connects123010564connec__t_s
conscribe1545924cons_cribe_
conscribed1743964cons_cribed
conscripted1853434cons_cripted
conscripts1644594cons_cripts
consensuses1353134consensuses
consented12311944conse__nted
consenter11312494conse__nter
consenters12410844conse__nters
consents102715894conse__nt_s
conservatism19104954conservatism
conservatives2195194conservatives
conservatizes27114454conservatizes
conservator1656374conservator
conservators1755974conservators
conserve1339934conse_r_ve_
conserved1538854conse_r_ved
conserver1448724conse_r_ver
conservers1547684conse_rvers
considerate1455474considerate_
consolidates1563864consolidates
consorted1239774cons_or_ted
consorts101512344cons_or_t_s
conspectus1653034conspec__tus
conspectuses1852374conspectuses
conspiracies1852894conspiracies
conspirator1555654conspirator
conspirators1655534conspirators
conspires1358484conspir__es
constellate13114564constellate_
constellated15113574constellated
consternate1355124consternate_
consternated1554114consternated
constipate1446394constipate_
constipated1645464constipated
constitutes1376164constitutes
constrains1249724cons_trains
construes11410134cons_tr_ues
consulate11612234cons_ulate_
consummate1654264consummate_
consummated1853494consummated
contemplates1855284contemplates
convected1738784convec__ted
convects153410994convec__t_s
converges1538384conve_r_ges
converses14311164conve_r_ses
converted15311564conve_r_ted
converter14311014conve_r_ter
converters1539634conve_r_ters
converts133213554conve_r_t_s
cooperages1565584coope_rages
cooperate13710144coope_rate_
cooperated1567334coope_rated
copemates1549484co_pe_mates
copperases1644894coppe_rases
corelates11314864co_re_lates
corncrakes1843284co_rncrakes
corporates14410734co_rporates
correlates1248674corre_lates
corselettes1352994corselettes
corsetries1249654corsetr_ies
coruscates1445684corusc_ates
cosecants1346534co_sec_ants
coverages1538834co_ve_rages
desecrate1249084_desecrate_
desecrated1447954_desecrated
desecrater1346984_desecrater
desecraters1444814_desecraters
eviscerates1652854eviscerates
execrates1839564__execrates
exonerates17107344exon_e_rates
generates10312714gen_e_rates
horseraces1546044horse_races
housecoats15134354housecoat_s
housemates1546134house_mates
integrates111010784_integrates
moderates12710754mo_de_rates
monocrats1348534mon_ocrat_s
nonsecret11118924nonsecr__et
nonsecretor1352904nonsecretor
nonsecretors1452724nonsecretors
nonseptate1255244nonseptate_
operates10515414_o_pe_rates
overrates12414624_o_verrates
penetrates1248724pen_etrates
recrates102420374___recrates
secretes10410474___secretes
serrates82617024___serrates
sonicates11410384son_ic_ates
tolerates9312124to_le_rates
uncrates10314564_un__crates
underrates11410564_underrates
venerates12312264ven_e_rates

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191828.50017508.1
3Display Results1821820.0931957.0
 (SQL Overall)1786911829.01319825.9
 
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.