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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

161 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
confrontational2071591confrontational_
confrontation1853223confrontation___
confrontations1962783confrontation__s
conformational21153714conf_ormational_
connotational1554154con_no_tational_
condensational1753655con_densational_
configurational2162205configurational_
confirmational21153395conf_irmational_
congregational1863435congr_egational_
consociational1853555con_sociational_
convocational2054475con_vo_cational_
collocational1753056co_llo_cational_
combinational1984086co_mbin_ational_
compensational2073526co_mpensational_
computational1994576co__mputational_
condonation1448856con_don_ation___
condonations1548006con_don_ation__s
conformation1947326conf_ormation___
conformations2046726conf_ormation__s
confrontal1553786confron__t___al_
confrontals1652666confron__t___als
confronting1744866confron__ti_n__g
confutation1668726conf__utation___
confutations1767796conf__utation__s
conjugational2353696con__jugational_
conjunctional2454166con_jun_ctional_
connectional1646726con___nectional_
connotation1347986con_no_tation___
connotations1447286con_no_tation__s
conservational1955346con_servational_
conspirational1853966con_spirational_
constitutional1663096con_stitutional_
constitutionals1761876con_stitutionals
contractional1756066contr__actional_
conventional1757166con_ven__tional_
conversational1954166con_versational_
coronation12412076co__ron_ation___
coronations13410706co__ron_ation__s
corotation12410976co__ro_tation___
corotations1349776co__ro_tation__s
correlational15113676co__rrelational_
documentational2061966documentational_
incantational1553566_in_cantational_
informational1854346_inf_ormational_
intonational1256006_in_ton_ational_
irrotational1254026__irro_tational_
nonfunctional1853766nonf_un_ctional_
nonnational11107836__n__onnational_
nonnationals1294896__n__onnationals
nonrational11109126__n__onrational_
nonsensational1463276non_sensational_
nonvocational1853706non_vo_cational_
notational1048126__n__o_tational_
orientational1353806_o_rientational_
rotational1048096____ro_tational_
antinational1297487_an_tin_ational_
citational1266467c_____itational_
coarctation1595077co_ar_ctation___
coarctations16114497co_ar_ctation__s
coeducational1853297co__educational_
cognitional1454277co___gn_itional_
communicational2383077communicational_
compositional1974057co_mpo_sitional_
computationally2462497co__mputationally
concentration1758017con_centration___
concentrations1877077con_centration__s
conceptional1856917con___ceptional_
concretionary2062867concr___etionary
condemnation1746047condemn_ation___
condemnations1845407condemn_ation__s
condensation1546787con_densation___
condensations1646277con_densation__s
conditional1447117c____onditional_
conditionals1554977c____onditionals
confabulation2063307confabulation___
confabulations2162807confabulation__s
confectionary2353777conf___ectionary
confederation1995257confederation___
confederations20104607confederation__s
conferential1755397conferen__ti__al_
confessional17175467conf___essional_
confessionals18154177conf___essionals
configuration1954137configuration___
configurations2063707configuration__s
confirmation1946187conf_irmation___
confirmations2055677conf_irmation__s
confiscation1945537conf_iscation___
confiscations2044957conf_iscation__s
conflagration1953017conflagration___
conflagrations2052727conflagration__s
conflation15412087conf___lation___
conflations16411147conf___lation__s
confusional1654247conf____usional_
conglobation1754257conglo_bation___
conglobations1853947conglo_bation__s
congregation16226767congr_egation___
congregations17186417congr_egation__s
congressional1653517congr__essional_
conjugationally2862357con__jugationally
conjunctionally2972487con_jun_ctionally
connation11314267con___n_ation___
connations12312947con___n_ation__s
connotatively21102687con_no_tati_vely
consignation15136317consign_ation___
consignations16105937consign_ation__s
consociation1648197con_sociation___
consociations1747517con_sociation__s
consolation13410987con_so_lation___
consolations1449747con_so_lation__s
constructional1854767con_structional_
consultation1447477con_sultation___
consultations1546937con_sultation__s
contestation1448667con_testation___
contestations1547747con_testation__s
continuation1448197con_tinuation___
continuations1547157con_tinuation__s
contractionary2162717contr__actionary
conurbation1547467conur__bation___
conurbations1646667conur__bation__s
convectional1947047con___vectional_
conventionally2254987con_ven__tionally
convocation1847887con_vo_cation___
convocations1947367con_vo_cation__s
coronating13410177co__ron_ati_n__g
corotating1349327co__ro_tati_n__g
correctional1675327co__r_rectional_
deformational19122977_def_ormational_
denominational1752547denomin_ational_
foundational1652857___foundational_
generational1354827gener___ational_
inclinational1553937_inclin_ational_
informationally2362467_inf_ormationally
innovational1553837_in_no_vational_
international1357677_intern_ational_
internationals1454247_intern_ationals
invitational1554907_in__vitational_
invitationals1652747_in__vitationals
invocational1754417_in_vo_cational_
narrational1145447__nar__rational_
nonconventional20102597non_conventional_
noneducational1762527non_educational_
nonemotional1453787nonemo___tional_
nonfictional1754857nonf___ictional_
nonoccupational2171247nonoccupational_
nonoperational1663777non_operational_
nonprofessional2072137nonprofessional_
nonrotating1246307non_ro_tati_n__g
nonstationary1672137non___stationary
nontraditional1562637nontr_aditional_
nutational1047047__n___utational_
operational1347527_oper___ational_
orientationally1872057_o_rientationally
permutational1752697__permutational_
perorational1446397__pero_rational_
presentational1673217_presentational_
probational1547087___pro_bational_
reformational18113427_ref_ormational_
supernational1555617super_n_ational_
supranational1552997_supran_ational_
unconditional1663467_un_conditional_
unsensational1353667_un_sensational_

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 Filter178691950240.356501941.0
2DLD Change Limit950241619.42310084.3
3Display Results1611610.1261277.8
 (SQL Overall)1786911619.90518040.5
 
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.