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

69 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
collisionally186211(None) 
collisional1353332collisiona_l_
conditionally1954783conditionally
collegially1753404collegi__ally
collision1146944collision____
collisions1246324collision___s
colloidally1752644coll_oi_dally
confessionally22103504confessionally
occasionally1952754_occasionally
positionally1754924po_sitionally
provisionally2163164provisionally
torsionally1453874to__rsionally
visionally1644794___visionally
additionally1753315_additionally
ballistically2054735ballistically
classically1844955c_lassi_cally
clinally1347235c__l__i_nally
clinically1747075c__lini_cally
clonally1346695c__l___onally
cognitional1454275cognitiona_l_
coitional1148695co__itiona_l_
collaterally1752825coll_aterally
colloquially2691955coll_oquially
collusion1146415collusion____
collusions1245975collusion___s
collusively1953215collusi__vely
colonially1546685co_l___onially
coloristically2164835coloristically
colossally1552895co_los__sally
companionably2462545companionably
compositionally2462285compositionally
conclusionary2062105conclusiona_ry
conditionable1863445conditionable
conditional1447115conditiona_l_
conditionality20113435conditionality
conditionals1554975conditiona_ls
confusional1654245confusiona_l_
congressionally2172135congressionally
conventionally2254975conventionally
convivially2252655convivi__ally
coronally1448415co____ronally
criminally1746195c__rimi_nally
dimensionally1962355dimensionally
erosionally1454665__erosionally
extensionally2362885extensionally
holistically2048115ho_listically
illusional1053405_illusiona_l_
illusionary1452615_illusiona_ry
intensionally1654395intensionally
locationally17124715lo_cationally
meridionally1852855_meridionally
millesimally1961335millesi_mally
notionally1347085no___tionally
nutritionally16103545nutritionally
obsessionally1862385obsessionally
optionally1545945_o__ptionally
originally1445225_o_rigi_nally
politically18411475po_liti_cally
polygonally2052525po_l_ygonally
polytonally1953195po_l_ytonally
processionally2163135processionally
professionally2263185professionally
relationally1555075_relationally
subliminally1951935sublimi_nally
traditionally1753805traditionally
unconditionally2172355unconditionally
valuationally1962525valuationally
vocationally20125005vo_cationally
volitional1345415vo_litiona_l_

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 Filter1786911247900.393454684.5
2DLD Change Limit124790698.06315476.9
3Display Results69690.0461500.0
 (SQL Overall)178691698.50221017.5
 
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.