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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

38 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
compositionally246228(None) 
compositional1974052compositiona_l_
computationally2462493computationally
positionally1754923___positionally
prepositionally2262513prepositionally
composition1746794composition____
compositions1846254composition___s
conditionally1954794co__nditionally
oppositional1683844_oppositiona_l_
appositional1683945_appositiona_l_
coeducationally23102355coeducationally
collisionally1862115co__llisionally
companionably2462545comp__anionably
compassionately2471865compas_sionately
compensational2073525compensationa_l_
compositely2053665composit____ely
compositing1846265compositi_n___g
computational1994575computationa_l_
confessionally22103515confes_sionally
conjugationally2862355conjugationally
conjunctionally2972485conjunctionally
conventionally2254985co_nventionally
depositional1554625_depositiona_l_
dispositional1653745dispositiona_l_
emotionally1655305_em_o__tionally
expositional2153945_expositiona_l_
impolitically2254615_impoliti_cally
nonpolitically2163665nonpoliti_cally
operationally1854645_o_perationally
optionally1545945_o_p___tionally
ovipositional1862465ovipositiona_l_
positional1247905___positiona_l_
postpositional1862655postpositiona_l_
prepositional1755195prepositiona_l_
proportionally2163495propo_rtionally
propositional1755245propositiona_l_
suppositional1763065suppositiona_l_
transitionally1763125_transitionally

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 Filter178691658740.330541487.9
2DLD Change Limit65874388.6737595.3
3Display Results38380.0301266.7
 (SQL Overall)178691389.03319782.0
 
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.