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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
coacervates188359(None) 
coacervate1763721coacervate_
acerbates1347263__acerbates
acervate1336983__acervate_
coacervation1964273coacervation
coacervations2053873coacervations
cocreates132611883co_c_reates
cooperates1469613cooper_ates
exacerbates22113063exacerbates
lacerates112413783_lacer_ates
macerates132113573_macer_ates
acerate92818914__acer_ate_
acerated113113984__acer_ated
acerbate1247534__acerbate_
acerbated1465554__acerbated
acetates102013064__ace_tates
acierates11310814__acier_ates
activates1449684__activates
aerates74627494__a_er_ates
captivates1745494c_aptivates
carates95630614c_a__r_ates
caseates10313714c_ase__ates
caseinates1247444c_aseinates
casemates1349524c_ase_mates
castrates11312684c_astr_ates
catenates11311814c_ate_nates
cerates95428254___cer_ates
clathrates1545284clathr_ates
coaevals1344564coa_e_va_ls
coagulates13137454coa_gulates
cocreate122611814co_c_reate_
cocreated142710094co_c_reated
coequates2045854co__equates
commentates17107614commentates
compensates1745724compensates
conceives1639234conceiv__es
concentrates16118214concentrates
concerted14312114concer__ted
concertizes24158584concertizes
concertos132711134concer__tos
concerts123016064concer__t_s
conciliates1546884conciliates
concordats1544194concordat_s
concretes13411474conc_r_etes
condensates1445314condensates
conepates13912284co_ne_pates
confervae1745144conferva_e_
confervas1744824conferva__s
congregates1545504congregates
consecrates1548394consecrates
conservatism19104954conservatism
conservatives2195194conservatives
conservatizes27114454conservatizes
conservator1656374conservator
conservators1755974conservators
conserves14311194conserv__es
consternates1455054consternates
cooperages1565584cooper_ages
cooperate13710144cooper_ate_
cooperated1567334cooper_ated
copemates1549484co_pe_mates
copperases1644894copper_ases
copperplates1752224copperplates
corelates11314864co_re_lates
corporates14410734corpor_ates
correlates1248674corre_lates
covariates1545784co_variates
coverages1538834co_ver_ages
cyanurates1543564cyanur_ates
cybernates1743394c_ybernates
deactivates1744394deactivates
deaerates10313644dea_er_ates
denervates1445934_denervates
enervates1248724__enervates
exacerbate21113374exacerbate_
exacerbated23122704exacerbated
faceplates1744614_faceplates
inactivates1645044inactivates
incurvates1545734_incurvates
innervates1346394_innervates
lacerate102214714_lacer_ate_
lacerated122210684_lacer_ated
macerate122314074_macer_ate_
macerated142010524_macer_ated
macerater13259524_macer_ater
maceraters14226634_macer_aters
moderates12710754mo_der_ates
operates10515414_o_per_ates
overhates15311944_o_verhates
overrates12414624_o_verrates
overvotes1538424_o_vervotes
racemates1348854_race_mates
reactivates1645614reactivates
tolerates9312124to_ler_ates
ulcerates1148854_ulcer_ates
valerates12310544_valer_ates

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.423422437.4
2DLD Change Limit148819969.40615821.7
3Display Results96960.0462087.0
 (SQL Overall)178691969.87518095.3
 
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.