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

147 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
compositional197404(None) 
composition1746792composition__
compositionally2462282compositionally
compositions1846252composition_s
oppositional1683832_oppositional
appositional1683943_appositional
compensational2073523compensational
compositing1846263compositi_n_g
computational1994573computational
depositional1554623_depositional
dispositional1653743dispositional
expositional2153943_expositional
ovipositional1862453ovipositional
positional1247903___positional
postpositional1862653postpositional
prepositional1755193prepositional
propositional1755243propositional
suppositional1763063suppositional
cognitional1454264co__gnitional
coitional1148694c___o_itional
collocational1753054collocational
combinational1984074combinational
competition1755774competition__
competitions1845534competition_s
complexional2551964comp_lexional
compositor1644634composit_o__r
compositors1754384composit_o_rs
composting17178044compos_ti_n_g
compressional1954254compressional
conditional1447104co__nditional
connotational1554154connotational
consociational1853544consociational
convocational2054474convocational
decomposition2053074decomposition__
decompositions2152814decomposition_s
imposition1446534_imposition__
impositions1546034_imposition_s
opposition1445484_opposition__
oppositions1575124_opposition_s
recomposition1953414recomposition__
recompositions2053174recomposition_s
accommodational2471555accommodational
acquisitional2461805acquisitional
apparitional1652765_apparitional
apposition1446595_apposition__
appositions1546155_apposition_s
coeducational1853295coeducational
collisional1353335co__llisional
combustion1644565combus_tion__
combustions1744525combus_tion_s
comitial1248695com___iti__al
commotion1576985commo__tion__
commotions1686845commo__tion_s
communicational2383065communicational
compaction1846755comp_action__
compactions1946535comp_action_s
compassion1645985compas_sion__
compassionate1963095compas_sionate
compassions1745765compas_sion_s
compensation18126505compensation__
compensations19136185compensation_s
compilation1749315compilation__
compilations1848675compilation_s
completion1647305comp_letion__
completions1746905comp_letion_s
componential1863075componenti__al
comporting17199165compo_rti_n_g
composing16179845compos__i_n_g
composite15410155composit____e
composited1756005composit___ed
compositely2053665composit__ely
composites1648905composit___es
compunction19115905compunction__
compunctions20145695compunction_s
computation1748715computation__
computationally2462495computationally
computations1848125computation_s
conceptional1856905co_nceptional
concessional16195395conces_sional
condensational1753645condensational
conditionals1554965co__nditionals
confessional17175465confes_sional
conformational21153705conformational
confusional1654245confus__ional
conjugational2353695conjugational
conjunctional2454155conjunctional
connectional1646715co_nnectional
conspirational1853955conspirational
contractional1756055contractional
convectional1947035co_nvectional
conventional1757155co_nventional
conversational1954155conversational
corporation151210655corporation__
corporations16129485corporation_s
correctional1675315co_rrectional
correlational15113675correlational
deposition13107835_deposition__
depositions14117685_deposition_s
disposition1446685disposition__
dispositions1546475disposition_s
emotional1146665_em_o__tional
exposition1947165_exposition__
expositions2046845_exposition_s
imbibitional1861695_imbibitional
impolitical1753325_impoliti_cal
inquisitional2272825inquisitional
juxtapositional3181035juxtapositional
malposition1553965malposition__
malpositions1653675malposition_s
misposition1555685misposition__
mispositioned1862195mispositioned
mispositions1655305misposition_s
motional1058675__m_o__tional
nonpolitical1654575nonpoliti_cal
nonvocational1853705nonvocational
operational1347515_o_perational
oppositionist17143815_oppositionist
optional1047645_o_p___tional
oviposition1653595oviposition__
ovipositions1753565oviposition_s
pomposities1765715pompositi__es
populational1654415po_pulational
position10912195___position__
positionally1754925___positionally
positioned1396005___positioned
positions11811505___position_s
postposition1654795postposition__
postpositions1753965postposition_s
preposition15108585preposition__
prepositionally2262515prepositionally
prepositions16108305preposition_s
promotional1555635prom_o__tional
proportional1655815propo_rtional
proposition1588745proposition__
propositioned1853915propositioned
propositions16108315proposition_s
reimposition1653965reimposition__
reimpositions1753615reimposition_s
repetitional1453725_repetitional
reposition121010145_reposition__
repositioned1554225_repositioned
repositions131110165_reposition_s
supposition1555205supposition__
suppositions1654895supposition_s
transitional1256225_transitional
transpositional17112335transpositional
volitional1345415___volitional

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 Filter1786911247900.1431249587.4
2DLD Change Limit1247901479.32613380.9
3Display Results1471470.0931580.6
 (SQL Overall)1786911479.56218687.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.