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

174 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
confrontation185322(None) 
confrontations1962781confrontations
confrontational2071592confrontational
condonation1448853con_don_ation
conformation1947323conf_ormation
confutation1668723conf__utation
connotation1347983con_no_tation
coronation12412073co__ron_ation
corotation12410973co__ro_tation
coarctation1595074co_ar_ctation
concentration1758014con_centration
condemnation1746044condemn_ation
condensation1546784con_densation
condonations1548004con_don_ations
confabulation2063304confabulation
confederation1995254confederation
configuration1954134configuration
confirmation1946184conf_irmation
confiscation1945534conf_iscation
conflagration1953014conflagration
conflation15412084conf___lation
conformations2046724conf_ormations
confrontal1553784confronta___l
confrontals1652664confronta__ls
confronting1744864confron__ting
confutations1767794conf__utations
conglobation1754254conglo_bation
congregation16226764congr_egation
connation11314264con___n_ation
connotations1447284con_no_tations
consignation15136314consign_ation
consociation1648194con_sociation
consolation13410984con_so_lation
consultation1447474con_sultation
contestation1448664con_testation
continuation1448194con_tinuation
conurbation1547464conur__bation
convocation1847884con_vo_cation
coronations13410704co__ron_ations
corotations1349774co__ro_tations
annotation1047755_an_no_tation
autorotation1255015autoro_tation
canonization2347925can__onization
carbonation1545855c_arbon_ation
carnation11312945c__ar_n_ation
cementation1559705c__ementation
chlorination1756245chlorin_ation
coadaptation1751965co_adaptation
coaptation1448345co___aptation
coarctations16114495co_ar_ctations
cofunction1745255co_f_un_ction
cogitation13410085co___gitation
cognation12310755co___gn_ation
cohabitation1953935co_habitation
collocation1547175co_llo_cation
colonisation14176765co__lonisation
colonization232010235co__lonization
coloration12913185co__lo_ration
colorization231711195color_ization
columniation1665425co_lumniation
combination17108805co_mbin_ation
commendation1946515co_mmendation
commination171111645co_mmin_ation
commutation1748005co__mmutation
compensation18126505co_mpensation
computation1748715co__mputation
conation101420885c____on_ation
concatenation1764095concatenation
concentrations1877075con_centrations
conciliation1648235con_ciliation
concoction1348235con_co__ction
concretion1449295concr___etion
concretization2754375concretization
condemnations1845405condemn_ations
condensations1646275con_densations
confabulations2162805confabulations
confection17411185conf___ection
confederations20104605confederations
configurations2063705configurations
confirmations2055675conf_irmations
confiscations2044955conf_iscations
conflagrations2052725conflagrations
conflations16411145conf___lations
confliction1845235conf__liction
conformational21153715conf_ormational
confront13411605confron__t___
confronted1644195confron__t_ed
confronter1544365confron__t_er
confronters1643855confron__ters
confronts1447065confron__t__s
confutative1955445conf__utative
congelation14410345con__gelation
conglobations1853945conglo_bations
conglomeration1963005conglomeration
congratulation1782825congratulation
congregations17186415congr_egations
conjugation2146625con__jugation
conjunction2245625con_jun_ction
conjuration2049515con__juration
connations12312945con___n_ations
connection14410535con___nection
conniption1446275con___niption
connotational1554155con_no_tational
connotative1665385con_no_tative
consecration1649785con_secration
conservation1749405con_servation
consideration1655525consideration
consignations16105935consign_ations
consociations1747515con_sociations
consolations1449745con_so_lations
consolidation1655155consolidation
conspiration1648385con_spiration
constellation1554805constellation
consternation15106365consternation
constipation1648565con_stipation
constitution1455265con_stitution
consultations1546935con_sultations
consummation1855295con_summation
contagion1246995c____ontagion
contamination1766955contamination
contemplation1985265contemplation
contention12412225con_ten__tion
contestations1547745con_testations
continuations1547155con_tinuations
contortion1248665con_to__rtion
contraception1953755contraception
contraction15411245contr__action
contradiction1854565contradiction
contraption1548105contr__aption
contravention18103875contravention
contribution1655095contr_ibution
contrition12411425contr___ition
conurbations1646665conur__bations
convention15410565con_ven__tion
conversation1747805con_versation
convocations1947365con_vo_cations
convolution1645125con_vo_lution
coordination1595585co_ordination
coproduction1954745co_production
coronating13410175co__ron_ating
corotating1349325co__ro_tating
corporation151210655co__rporation
correlation1358555co__rrelation
corroboration1782825co_rroboration
corrugation1445995co__rrugation
coruscation1545695co__ruscation
covariation1646775covar__iation
crenation11412925c___ren_ation
cunctation1476915cun___ctation
cybernation1843915cyber_n_ation
denotation11311085den__o_tation
documentation18144725documentation
encrustation14103395_encrustation
floatation1344685___floatation
flotation1267815___flo_tation
fomentation1647715fo__mentation
forestation1447005fo__restation
incantation1347055_in_cantation
incrustation14104435_incrustation
indentation1248375_in_dentation
infestation1447045_inf_estation
information16147715_inf_ormation
intonation10410265_in_ton_ation
nonimportation1862225nonimportation
nonrotating1246305non_ro_tating
notation81414605__n__o_tation
orientation1147575_o_rientation
ornamentation1573615ornamentation
ostentation1146975_o_stentation
ozonation1845675_o__zon_ation
pronation11415705___pron_ation
rotation81615455____ro_tation
sulfonation1444265sulf_on_ation
workstation1852305wo__rkstation

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.423422437.4
2DLD Change Limit1247901748.89014037.1
3Display Results1741740.1101581.8
 (SQL Overall)1786911749.42318963.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.