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

170 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
confrontations196278(None) 
confrontation1853221confrontation_
confrontational2071592confrontational
condonations1548003con_don_ations
conformations2046723conf_ormations
confutations1767793conf__utations
connotations1447283con_no_tations
coronations13410703co__ron_ations
corotations1349763co__ro_tations
coarctations16114494co_ar_ctations
concentrations1877074con_centrations
condemnations1845404condemn_ations
condensations1646274con_densations
condonation1448854con_don_ation_
confabulations2162804confabulations
confederations20104604confederations
configurations2063704configurations
confirmations2055674conf_irmations
confiscations2044954conf_iscations
conflagrations2052724conflagrations
conflations16411144conf___lations
conformation1947324conf_ormation_
confrontals1652664confronta___ls
confronting1744864confron__ti_ng
confutation1668724conf__utation_
conglobations1853944conglo_bations
congregations17186414congr_egations
connations12312944con___n_ations
connotation1347984con_no_tation_
consignations16105934consign_ations
consociations1747514con_sociations
consolations1449744con_so_lations
consultations1546934con_sultations
contestations1547734con_testations
continuations1547144con_tinuations
conurbations1646664conur__bations
convocations1947364con_vo_cations
coronation12412074co__ron_ation_
corotation12410974co__ro_tation_
annotations1146885_an_no_tations
autorotations1354555autoro_tations
canonizations2447245can__onizations
carbonations1644845c_arbon_ations
carnations12311355c__ar_n_ations
cementations1659015c__ementations
chlorinations1855535chlorin_ations
coadaptations1851685co_adaptations
coaptations1547545co___aptations
coarctation1595075co_ar_ctation_
cofunctions1845015co_f_un_ctions
cogitations1448905co___gitations
cognations1339595co___gn_ations
cohabitations2053455co_habitations
collocations1646405co_llo_cations
colonisations15216175co__lonisations
colonizations24229425co__lonizations
colorations13911895co__lo_rations
colorizations241410355color_izations
columniations1764795co_lumniations
combinations1897925co_mbin_ations
commendations2055805co_mmendations
comminations18810485co_mmin_ations
commutations1847265co__mmutations
compensations19136185co_mpensations
computations1848125co__mputations
conations111318905c____on_ations
concatenations1873725concatenations
concentration1758015con_centration_
conciliations1747205con_ciliations
concoctions1448255con_co__ctions
concretions1549295concr___etions
concretizations2854035concretizations
condemnation1746045condemn_ation_
condensation1546785con_densation_
confabulation2063305confabulation_
confections18411395conf___ections
confederation1995255confederation_
configuration1954135configuration_
confirmation1946185conf_irmation_
confiscation1945535conf_iscation_
conflagration1953015conflagration_
conflation15412085conf___lation_
conflictions1945225conf__lictions
conformational21153715conf_ormational
confrontal1553785confronta____l
confronters1643835confron__t_ers
confronts1447065confron__t___s
congelations1549735con__gelations
conglobation1754255conglo_bation_
conglomerations2062735conglomerations
congratulations1882785congratulations
congregation16226765congr_egation_
conjugations2245865con__jugations
conjunctions2345385con_jun_ctions
conjurations2148495con__jurations
connation11314265con___n_ation_
connections15410705con___nections
conniptions1546035con___niptions
connotational1554155con_no_tational
consecrations1749215con_secrations
conservations1849095con_servations
considerations1764845considerations
consignation15136315consign_ation_
consociation1648195con_sociation_
consolation13410985con_so_lation_
consolidations1754745consolidations
conspirations1747725con_spirations
constellations1654405constellations
consternations16116045consternations
constipations1747685con_stipations
constitutions1554865con_stitutions
consultation1447475con_sultation_
consummations1955155con_summations
contagions1346605c____ontagions
contaminations1886105contaminations
contemplations2074735contemplations
contentions13412095con_ten__tions
contestation1448665con_testation_
continuation1448195con_tinuation_
contortions1348685con_to__rtions
contraceptions2053385contraceptions
contractions16410405contr__actions
contradictions1954145contradictions
contraptions1647645contr__aptions
contraventions19103575contraventions
contributions1754745contr_ibutions
contritions13410915contr___itions
conurbation1547465conur__bation_
conventions16410535con_ven__tions
conversations1847455con_versations
convocation1847885con_vo_cation_
convolutions1745195con_vo_lutions
coordinations1684995co_ordinations
coproductions2054495co_productions
coronating13410175co__ron_ati_ng
corotating1349325co__ro_tati_ng
corporations16129485co__rporations
correlations1447865co__rrelations
corroborations1882625co_rroborations
corrugations1565485co__rrugations
coruscations1645245co__ruscations
covariations1745985covar__iations
crenations12511695c___ren_ations
cunctations1576155cun___ctations
cybernations1943605cyber_n_ations
denotations1239855den__o_tations
documentations19144485documentations
encrustations15123085_encrustations
floatations1444105___floatations
flotations1366875___flo_tations
fomentations1746795fo__mentations
forestations1546325fo__restations
incantations1446645_in_cantations
incrustations15134285_incrustations
indentations1347885_in_dentations
infestations1546625_inf_estations
informations17127035_inf_ormations
intonations1149525_in_ton_ations
noncontagious1662555non_contagious
nonimportations1962105nonimportations
nonrotating1246305non_ro_tati_ng
notations91512975__n__o_tations
orientations1246915_o_rientations
ornamentations1673255ornamentations
ostentations1246125_o_stentations
ozonations1945145_o__zon_ations
pronations12314035___pron_ations
rotations91613845____ro_tations
sulfonations1543925sulf_on_ations
workstations1952055wo__rkstations

Search took 8 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 Filter178691950240.376475242.0
2DLD Change Limit950241706.72014140.5
3Display Results1701700.1101545.5
 (SQL Overall)1786911707.20624797.5
 
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.