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

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

47 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
collegially175341(None) 
collegial1245732collegia_l_
collegiality1863222collegiality
collegiately18101712collegiately
collegia1146063collegia___
collegian1245043collegia__n
collegians1344423collegia_ns
collegiate1345073collegia_te
colloidally1752643colloidally
colloquially2691963colloquially
colonially1546693co_lonially
congenially1755903congenially
illegally1343733_illeg_ally
celestially1654434celestially
cholerically2256154cholerically
clerically1748194c__lerically
coaxially21144574co__axially
coequally2344044co__equally
coevally1646284co__e_vally
collaterally1752824collaterally
collectable17104904collectable
collectedly1983014collectedly
collectively22114624collectively
collegium1444384collegi__um
collegiums1553324collegi_ums
collisionally1862114collisionally
collusively1953214collusively
colluvial1443854colluvia_l_
colossally1552894co_lossally
comedically2156994co_medically
commensally2054794commensally
commercially2354144commercially
congenitally1854394congenitally
conjugally2352514conjug_ally
connubially1852484connubially
convivially2252664convivially
cordially1547484co__rdially
cosmetically2147934cosmetically
ecologically2067724eco_logically
illegibly1553144_illegi_bly
illogically1746384_illogically
legally1138134___leg_ally
millesimally1961334millesimally
polemically2047644po_lemically
volleyball1851094volleyball_
volleyballs1961054volleyballs
zoologically2755644zoologically

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 Filter1786911488190.423422437.4
2DLD Change Limit148819478.11018350.1
3Display Results47470.0301566.7
 (SQL Overall)178691478.56320867.8
 
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.