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 “concatenating” 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
concatenating185326(None) 
concatenation1764092concatenation
concatenations1873722concatenations
catenating1348683___catenating
concatenate1554403concatenat__e
concatenated1753523concatenat_ed
concatenates1654533concatenat_es
consternating1654973con_sternating
contaminating1854913contaminating
contenting13313323con__ten_ting
cocreating15310294co_c_re_ating
concealing1549304conc__e_aling
conceiting15311774conc__e_iting
concelebrating2172594concelebrating
concentrating1856434concentrating
concerting15313894conc__e_rting
conciliating1775614conc_iliating
concreting1539874conc_re__ting
confabulating21102724confabulating
confederating2054014confederating
conglutinating1862424conglutinating
congratulating1862144congratulating
congregating1754284con_gregating
consenting13313214con__sen_ting
constellating1653264con_stellating
constipating1775394con_stipating
contending1449124con__ten_ding
contesting13312214con__te_sting
conventing16311544con__ven_ting
coparenting1644614co_paren_ting
incarnating1445544_inca_rnating
antedating1277555_an__tedating
cachinnating2092105c_achinnating
caseating12311745___case_ating
catenation1249525___catenation
catenations1348365___catenations
caveating1539295___cave_ating
coagulating1545075co__agulating
coattending1543545co_atten_ding
coattesting1443455co__attesting
cocainizing2544895co_ca_inizing
cocultivating2162345cocultivating
coenacting1545875co____enacting
coextending2252915co_exten_ding
cogitating1447215co_git__ating
coinventing1744545co_inven_ting
collaborating1852585collaborating
comanaging1644325co_ma__naging
combatting1755135combat___ting
commentating1957045co__mmentating
commenting1749175co__mmen_ting
commiserating2053195commiserating
commutating1846025commut__ating
compartmenting2361685compartmen_ting
compensating1955005co__mpensating
concanavalin1991125concanavalin_
concanavalins2081185concanavalins
concaving1737355conc____aving
conceding1559345conc__e__ding
conceiving1846775conc__e_iving
concentering1755435conc__entering
concerning1548905conc__e_rning
concertina14410615conc__e_rtina
concertino14910845conc__e_rtino
concocting1448415conc___octing
concretizing2654305conc_retizing
condensing1447745con__den_sing
confecting18310555con__fe_cting
conferencing2053855conferen_cing
confiscating2053615con_fiscating
conflating16410005con___flating
confronting1744865con_fron_ting
congealing1447635con__ge_aling
congesting14410115con__ge_sting
conglobating1853165con_globating
conglomerating2062425conglomerating
conjugating2244505con__jugating
connecting15310385con__ne_cting
connoting12310025con____noting
consecrating1747945con_secrating
consociating1755575con_sociating
consolidating1753285consolidating
consternation15106365con_sternation
consternations16116045con_sternations
constituting1554655con_stituting
constricting1747025con_stricting
constructing1746755con_structing
consummating1953665con_summating
contacting15610075con__t_acting
containing13410935conta_in__ing
contamination1766955contamination
contaminations1886105contaminations
contaminative2054375contaminative
contemning1577065con__te_mning
contemplating2054125contemplating
contention12412225con__ten_tion
contentions13412095con__ten_tions
continuing1348195con__tin_uing
contorting13410105con__t_orting
contracting16610475con__tracting
contrasting1459355con__trasting
contravening1853565contraven__ing
convalescing2052015convale_scing
convecting18310435con__ve_cting
convening15311195con__ven__ing
converting16313135con__ve_rting
cooperating1648425co__operating
coordinating1653915co_ordinating
copresenting1754945copresen_ting
copycatting2151985copycat___ting
corelating13511585co___relating
coronating13410175co___ronating
corotating1349325co_rot__ating
correlating1487085co__rrelating
countenancing1853135co_untenancing
counteracting1856285co_unteracting
covenanting1743015co___venanting
decontaminating2162765decontaminating
documenting1753125do_cumen_ting
inactivating1853465_inactivating
incanting1289905_inca__n_ting
incarcerating1852585_incarcerating
incenting12912065_inc__en_ting
incinerating1554725_incinerating
infatuating1543585_infat_uating
intonating1148635_in__tonating
invaginating1753905_invaginating
lancinating1445445lanc__inating
neatening1038355__neaten__ing
nonfattening1661865nonfatten__ing
noninteracting1762665noninteracting
nonoperating1555415non_operating
nonrotating1246305nonrot__ating
obliterating1553395_obliterating
ornamenting1452565_ornamen_ting
outeating10814495_o__ute_ating
oxygenating2352355_o_xygenating
patenting1248945___paten_ting
patinating1339875___patinating
pollenating1444555po__llenating
punctuating1643105punc_t_uating
recontaminating2062765recontaminating
reincarnating1652445reinca_rnating
tomcatting1542425tomcat___ting
uncreating13310475_unc_re_ating
venenating1446015ven___enating
vociferating2182455vo_ciferating

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.1401276364.3
2DLD Change Limit1247901479.47013177.4
3Display Results1471470.0931580.6
 (SQL Overall)1786911479.70318416.1
 
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.