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

117 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
consociational185355(None) 
consociation1648192consociation__
consociations1747512consociation_s
convocational2054472convoc_ational
associational1552933_associational
collocational1753053colloc_ational
conformational21153713conformational
connotational1554153conno_tational
conservational1955343conservational
consociating1755573consociati_n_g
conspirational1853963conspirational
nonvocational1853703nonvoc_ational
coeducational1853294coeduc_ational
compositional1974054composi_tional
conceptional1856914con__ceptional
condensational1753654condensational
conditional1447114con__di_tional
confirmational21153394confirmational
confrontational2071594confrontational
congregational1863434congregational
conjugational2353694con_jugational
connectional1646724connec__tional
consecration1649784consecration__
consecrations1749214consecration_s
consolation13410984conso_lation__
consolations1449744conso_lation_s
consolidation1655154consolidation__
consolidations1754744consolidation_s
constitutional1663094constitutional
constructional1854764constructional
convectional1947044convec__tional
conversational1954164conversational
convocation1847884convoc_ation__
convocations1947364convoc_ation_s
invocational1754414_invoc_ational
nonsensational1463274nonsensational
pronunciational1971624pronunciational
association1346155_association__
associations1445755_association_s
avocational1645185__avoc_ational
cognitional1454275co__gni_tional
coitional1148695c___o_i_tional
collocation1547175colloc_ation__
collocations1646405colloc_ation_s
combinational1984085co_mbinational
communicational2383075communicational
compensational2073525compensational
computational1994575co_mputational
concessional16195395con__cessional
conciliation1648235conciliation__
conciliations1747205conciliation_s
concoction1348235concoc__tion__
concoctions1448255concoc__tion_s
conditionals1554975con__di_tionals
condonation1448855condo_nation__
condonations1548005condo_nation_s
configurational2162205configurational
conformation1947325conformation__
conformations2046725conformation_s
conjunctional2454165con_junctional
connotation1347985conno_tation__
connotations1447285conno_tation_s
conscription1855335conscription__
conscriptions1955005conscription_s
consecrating1747945consecrati_n_g
consecution1547315consec_ution__
consecutions1647055consec_ution_s
conservation1749405conservation__
conservations1849095conservation_s
consignation15136315consignation__
consignations16105935consignation_s
consociate1446855consociat____e
consociated1645215consociat___ed
consociates1546545consociat___es
consolidating1753285consolidati_n_g
conspiration1648385conspiration__
conspirations1747725conspiration_s
constipation1648565constipation__
constipations1747685constipation_s
constitutionals1761875constitutionals
constriction1648265constriction__
constrictions1747785constriction_s
consultation1447475consultation__
consultations1546935consultation_s
consummation1855295consummation__
consummations1955155consummation_s
contractional1756065con_tractional
conventional1757165con__ventional
correctional1675325correc__tional
correlational15113675co_rrelational
denominational1752545den_ominational
dissociation1556645dissociation__
dissociations1656015dissociation_s
indicational1545755_indic_ational
informational1854345_informational
innovational1553835_inno_vational
inscriptional17173515_inscriptional
inspirational1554415_inspirational
intonational1256005_into_national
locational1246595___loc_ational
noneducational1762525noneducational
nonfictional1754855non__fictional
nonnational11107835__n_onnational
nonoccupational2171245nonoccupational
nonoperational1663775nonoperational
nonrational11109125__n_onrational
notational1048125__n_o_tational
observational1853185_observational
oppositional1683845_opposi_tional
oscillational1552235_o_s_cillational
positional1247905po_s__i_tional
postulational1553915po_stulational
prevocational2054015prevoc_ational
sensational1146385sens___ational
speciational1654315__speciational
unsensational1353665_unsensational
vocational1546955___voc_ational

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.346516448.0
2DLD Change Limit950241176.96613641.1
3Display Results1171170.0801462.5
 (SQL Overall)1786911177.39224173.6
 
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.