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

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

140 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
constitutionals176187(None) 
constitutional1663091constitutional_
constitutions1554862constitution__s
constitution1455263constitution___
institutional1353503_institutional_
conditionals1554974con_di__tionals
conspirational1853964conspirational_
constipations1747684constipation__s
constituting1554654constituti_n__g
constitutively2262294constituti_vely
constructional1854764constructional_
institutionally1872134_institutionally
institutions1244734_institution__s
reconstitutions1763274reconstitution__s
substitutional1662044substitutional_
conditional1447115con_di__tional_
connotational1554155con_notational_
consecutions1647055cons_ecution__s
conservational1955345conservational_
consociational1853555consociational_
conspirations1747725conspiration__s
constipation1648565constipation___
constituently1872135constitu__ently
constituents1483355constitu__en_ts
constitutes1376165constitut____es
constitutive1754105constituti___ve
constrictions1747785constriction__s
constructions1747715construction__s
consultations1546935consultation__s
continuations1547145con_tinuation__s
contractional1756065con_tractional_
contributions1754745contribution__s
destitutions1385255_destitution__s
institution1145295_institution___
invitationals1652745_in_vitationals
prostitutions1554255prostitution__s
reconstitution1663565reconstitution___
restitutions1275705_restitution__s
substitutionary2071095substitutionary
substitutions1553285substitution__s
antinational1297486_an_tinational_
antirational1278496_an_tirational_
biconditionals1961456bicon_di__tionals
castigations1547206c_astigation__s
citational1266466c____itational_
cogitations1448906co__gitation__s
cognitional1454276co_gni__tional_
cohabitations2053456cohabitation__s
coitional1148696co___i__tional_
combinational1984086co_mbinational_
comminutions1894316co_mminution__s
computational1994576co_mputational_
conceptional1856916con__ceptional_
condensational1753656condensational_
conditionable1863446con_di__tionable
conditionally1954796con_di__tionally
conditioners1563926con_di__tioners
conditions13410106con_di__tion__s
confessionals18154176con__fessionals
configurational2162206con_figurational_
confirmational21153396confirmational_
conflictions1945226confli_ction__s
conformational21153716conformational_
confrontational2071596confrontational_
confusional1654246con___fusional_
confutations1767796con_futation__s
congregational1863436congregational_
conjugational2353696con_jugational_
conjunctional2454166con_junctional_
connectional1646726con__nectional_
conniptions1546036con_ni_ption__s
connotations1447286con_notation__s
conscientious17102266conscientio__us
conscientiously2271386conscientiously
conscriptions1955006conscription__s
consecrations1749216consecration__s
consecution1547316cons_ecution___
conservations1849096conservation__s
consignations16105936consignation__s
consociations1747516consociation__s
consolations1449746cons_olation__s
consolidations1754746consolidation__s
conspiration1648386conspiration___
constellations1654406constellation__s
consternations16116046consternation__s
constipating1775396constipati_n__g
constituencies1871806constitu_encies
constituency1982136constitu__en_cy
constituent1394946constitu__en__t
constitute1276706constitut_____e
constituted1475056constitut____ed
constriction1648266constriction___
construals1245216const_ru____als
construction1648086construction___
constructionist1984036constructionist
consuetudinary2011626consuetudi_nary
consultation1447476consultation___
consummations1955156consummation__s
consumptions1845146cons_umption__s
contentions13412096con_t_ention__s
contestations1547736contestation__s
continuation1448196con_tinuation___
continuingly1853066con_tinu_i_ngly
contortions1348686con_t_ortion__s
contractionary2162716con_tractionary
contractions16410406con_traction__s
contraptions1647646con_traption__s
contribution1655096contribution___
contritions13410916con_t_rition__s
contusions1246996con___tusion__s
convectional1947046con__vectional_
conventional1757166con__ventional_
conversational1954166conversational_
convictions1848046con_vi_ction__s
convocational2054476con_vocational_
convolutions1745196con_volution__s
destitution1255546_destitution___
distributional1762966_distributional_
inspirational1554416_inspirational_
instigations1348246_instigation__s
instituting1244806_instituti_n__g
institutors1153216_institut_o__rs
instructional1555096_instructional_
invitational1554906_in_vitational_
longitudinal1461156lon_gitudi_nal_
monetizations2467646monetization__s
motivational1753916mo__tivational_
multinationals1662226_multinationals
nonfictional1754856non_fi_ctional_
nonnationals1294896non___nationals
nonsensational1463276nonsensational_
nonsolutions1254176nons_olution__s
nonstationary1672136nons__tationary
positional1247906po_s_i__tional_
postulational1553916po_stulational_
prostitution1454606prostitution___
reconstituting1763236reconstituti_n__g
restitution1175976_restitution___
situational1144586___s_ituational_
substitution1453326substitution___

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 Filter178691950240.373479064.3
2DLD Change Limit950241407.69012356.8
3Display Results1401400.0931505.4
 (SQL Overall)1786911408.15621909.1
 
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.