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

136 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
conspirational185396(None) 
conspiration1648382conspiration__
conspirations1747722conspiration_s
inspirational1554412_inspirational
aspirational1455003__aspirational
confirmational21153393con_firmational
conservational1955343conservational
consociational1853543consociational
conspiratorial1881503conspiratorial
constitutional1663093constitutional
nonoperational1663773nonoperational
transpirational1773103transpirational
antirational1278484_an_tirational
combinational1984084co_mbinational
computational1994574co_mputational
condensational1753654condensational
conditional1447114con_di__tional
configurational2162204configurational
conformational21153714conformational
congregational1863434congregational
conjugational2353694con_jugational
connotational1554154con_notational
consecration1649784consecration__
consecrations1749214consecration_s
conspirator1555654conspirat_o__r
conspirators1655534conspirat_o_rs
constipation1648564constipation__
constipations1747684constipation_s
constitutionals1761874constitutionals
constructional1854764constructional
contractional1756064con__tractional
conversational1954164conversational
convocational2054474con_vocational
inspiration1348374_inspiration__
inspirationally2072544_inspirationally
inspirations1447304_inspiration_s
nonrational11109124non___rational
nonsensational1463274nonsensational
operational1347524_o__perational
antinational1297475_an_tinational
aspiration1249995__aspiration__
aspirations1348995__aspiration_s
citational1266465c____itational
civilizational2871675civilizational
coeducational1853295co_educational
cognitional1454275co_gni__tional
coitional1148695co___i__tional
collocational1753055co_llocational
communicational2383075communicational
compensational2073525compensational
compilation1749315co_mpilation__
compilations1848685co_mpilation_s
compositional1974055co_mpositional
conceptional1856915con__ceptional
conditionals1554975con_di__tionals
confirmation1946185con_firmation__
confirmations2055675con_firmation_s
confrontational2071595confrontational
conjunctional2454165con_junctional
conjuration2049515con_juration__
conjurations2148495con_juration_s
connectional1646725con__nectional
conscription1855335conscription__
conscriptions1955005conscription_s
consecrating1747945consecrati_n_g
conservation1749405conservation__
conservations1849095conservation_s
consideration1655525consideration__
considerations1764845consideration_s
consignation15136315consignation__
consignations16105935consignation_s
consociation1648195consociation__
consociations1747515consociation_s
consolation13410985cons_olation__
consolations1449745cons_olation_s
consolidation1655155consolidation__
consolidations1754745consolidation_s
conspiracies1852895conspiraci__es
conspiring1546555conspir__i_n_g
consternation15106365consternation__
consternations16116045consternation_s
constipating1775395constipati_n_g
constitution1455265constitution__
constitutions1554865constitution_s
constriction1648265constriction__
constrictions1747785constriction_s
consultation1447475consultation__
consultations1546935consultation_s
consummation1855295consummation__
consummations1955155consummation_s
convectional1947045con__vectional
conventional1757165con__ventional
conversional1755145con_ver_sional
cooperation15410025co_operation__
cooperations1659195co_operation_s
corporation151210655co_rporation__
corporations16129485co_rporation_s
correlational15113675co_rrelational
cuspidation1643495c_uspidation__
cuspidations1743345c_uspidation_s
demonstrational1862635demons_trational
denominational1752545denominational
generational1354825gen__erational
inclinational1553935_inclinational
indicational1545755_in_dicational
inscriptional17173515_inscriptional
insertional1147465_ins_er_tional
institutional1353505_institutional
invitational1554905_in_vitational
motivational1753915mo__tivational
narrational1145445__n_arrational
navigational1653295__navigational
nondirectional1763085non_directional
noneducational1762525noneducational
nonfictional1754855non_fi_ctional
nonnational11107835non___national
nonspatial1255625nonsp__ati__al
nonvocational1853705non_vocational
observational1853185_observational
occupational1883005occup__ational
oscillational1552225_o_scillational
perspiration1656835perspiration__
perspirations1786175perspiration_s
populational1654415po__pulational
positional1247905po_s_i__tional
postulational1553915po_stulational
preoperational1853245preoperational
respiration13511195_respiration__
respirations14410305_respiration_s
sensational1146385sens___ational
subrational1345495___subrational
suspiration1346545_suspiration__
suspirations1445855_suspiration_s
transpiration1555425transpiration__
transpirations1654725transpiration_s
unsensational1353665_unsensational

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.360496363.9
2DLD Change Limit950241367.34312940.8
3Display Results1361360.0931462.4
 (SQL Overall)1786911367.79622920.9
 
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.