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

199 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
concatenation176409(None) 
concatenations1873721concatenations
concatenating1853262concatenating
catenation1249523___catenation
concatenate1554403concatenat__e
concatenated1753523concatenat_ed
concatenates1654533concatenat_es
consternation15106363con_sternation
contamination1766953contamination
contention12412223con__ten_tion
cancelation1547774canc__elation
catenations1348364___catenations
concelebration20133564concelebration
concentration1758014concentration
conception16410454conc__e_ption
conciliation1648234conc_iliation
concretion1449294conc_re__tion
concretization2754374concretization
condemnation1746044con_demnation
condensation1546784con__densation
condonation1448854con__donation
confabulation2063304confabulation
confederation1995254confederation
confutation1668724confut__ation
congelation14410344con__gelation
conglutination1762784conglutination
congratulation1782824congratulation
congregation16226764con_gregation
connation11314264con____nation
connotation1347984connot__ation
consideration1655524consideration
consignation15136314con_signation
constellation1554794con_stellation
consternations16116044con_sternations
constipation1648564con_stipation
contaminations1886104contaminations
contentions13412094con__ten_tions
contestation1448664con__testation
continuation1448194con__tinuation
contravention18103874contraven_tion
convention15410564con__ven_tion
cunctation1476914cunc_t__ation
incarnation1347464_inca_rnation
cachinnation1972425c_achinnation
calcination1548905calc__ination
canalization23411165can_alization
cancelations1657095canc__elations
cancellation1655015canc_ellation
carnation11312945___ca_rnation
caseation1199515___case_ation
catenating1348685___catenating
centenarian1364685cen__tenarian
cicatrization2675415c_icatrization
coacervation1964275coac_ervation
coadaptation1751965coada_ptation
coagulation1447275co__agulation
coaptation1448345co__a_ptation
coarctation1595075co__arctation
cocainization2655955co_cainization
cocultivation2053055cocultivation
cogeneration1546445co_generation
cogitation13410085co_git__ation
cognation12310755co____gnation
cohabitation1953935co_habitation
collaboration1763005collaboration
combination17108805co__mbination
commendation1946515co__mmendation
commination171111645co__mmination
commiseration1964045commiseration
commutation1748005commut__ation
compensation18126505co__mpensation
complexation25144245co_mplexation
computation1748715comput__ation
conation101420885co_____nation
concanavalin1991125concanavali_n
concelebrations21103165concelebrations
concentrations1877075concentrations
conceptions17410595conc__e_ptions
concertino14910845conc__e_rtino
concession14148135conc__e_ssion
conciliations1747205conc_iliations
concoction1348235conc___oction
concretions1549295conc_re__tions
concretizations2854035concretizations
condemnations1845405con_demnations
condensations1646275con__densations
condonations1548005con__donations
confabulations2162805confabulations
confection17411185con__fe_ction
confederations20104605confederations
configuration1954135configuration
confirmation1946185con_firmation
confiscation1945535con_fiscation
conflagration1953015conflagration
conflation15412085con___flation
conformation1947325con_formation
confrontation1853225confrontation
confutations1767795confut__ations
congelations1549735con__gelations
congestion1349045con__ge_stion
conglobation1754255con_globation
conglomeration1963005conglomeration
conglutinations1862545conglutinations
congratulations1882785congratulations
congregations17186415con_gregations
conjugation2146625con__jugation
conjunction2245625con__junction
conjuration2049515con__juration
connations12312945con____nations
connection14410535con__ne_ction
connotations1447285connot__ations
consecration1649785con_secration
consecution1547305con__secution
conservation1749405con_servation
considerations1764845considerations
consignations16105935con_signations
consociation1648195con_sociation
consolation13410985con__solation
consolidation1655155consolidation
conspiration1648385con_spiration
constellations1654405con_stellations
consternating1654975con_sternating
constipations1747685con_stipations
constitution1455265con_stitution
constriction1648265con_striction
construction1648085con_struction
consultation1447475con_sultation
consummation1855295con_summation
contagion1246995con__t__agion
contaminating1854915contaminating
contaminative2054375contaminative
contaminator1654995contaminat_or
contemplation1985265contemplation
contenting13313325con__ten_ting
contentious1347015con__ten_tious
contestations1547735con__testations
continuations1547145con__tinuations
contortion1248665con__t_ortion
contraception1953755contrace_ption
contraction15411245con__traction
contraption1548105con__traption
contraventions19103575contraven_tions
contrition12411415con__t_rition
conurbation1547465con__urbation
convection17411125con__ve_ction
conventions16410535con__ven_tions
conversation1747805con_versation
convocation1847885con__vocation
cooperation15410025co__operation
coordination1595585co_ordination
coronation12412075co___ronation
corotation12410975co_rot__ation
correlation1358555co__rrelation
counteraction1755385co_unteraction
covariation1646775co_va_riation
crenation11412925___c_renation
cunctations1576155cunc_t__ations
decontamination2083255decontamination
denaturation1345885den_aturation
documentation18144725do_cumentation
dogmatization2655985dogmatization
focalization2649665fo_calization
inactivation1745095_inactivation
inattention1152725_inatten_tion
incantation1347055_inca_ntation
incarceration1753565_incarceration
incardination1655035_incardination
incarnations1446665_inca_rnations
incineration1446295_incineration
incitation12312225_incit__ation
inclination1349735_inc_lination
infatuation1444935_infat_uation
intention9412015_in__ten_tion
intonation10410265_in__tonation
invagination1645645_invagination
localization23410435lo_calization
miscegenation1863135miscegenation
monetization2358125mon_etization
natation81513935__n_at__ation
nonagenarian1362845non_agenarian
noncelebration18113315noncelebration
nonconnection1784415nonconnection
noncooperation1863705noncooperation
noncorrelation16113085noncorrelation
noncultivation19183065noncultivation
obliteration1453895_obliteration
ornamentation1573615_ornamentation
ostentation1146965_o__stentation
oxygenation2252875_o_xygenation
patination12312575___patination
pectination15410335_pec_tination
punctation1486055punc_t__ation
punctuation1543485punc_t_uation
recontamination1983545recontamination
reincarnation1563175reinca_rnation
renaturation1256755ren_aturation
scatteration1452925__scatteration
vocalization2649995vo_calization
vociferation2053185vo_ciferation

Search took 9 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.390458182.1
2DLD Change Limit1247901998.36014927.0
3Display Results1991990.1261579.4
 (SQL Overall)1786911998.87620131.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.