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

103 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
exceptionally275352(None) 
exceptionably2972571exceptionably
exceptionable2682372exceptionable
exceptional2254442exceptiona_l_
exceptionality2872112exceptionality
exceptionalism27112893exceptionalism
extensionally2362883extensionally
unexceptionably3171883unexceptionably
affectionally2453014affectionally
bisectionally2053154bisectionally
deceptional1654774deceptiona_l_
dictionally1755984dic__tionally
educationally1963314educationally
emotionally1655304e__motionally
equationally2453824e_quationally
exception2046854exception____
exceptionalisms28162534exceptionalisms
exceptionalness2671234exceptionalness
exceptions2146864exception___s
factionally1946394fac__tionally
fictionally1956054fic__tionally
ideationally1674884_ideationally
intentionally1655984intentionally
locationally17124714loc_ationally
occupationally2362124occupationally
optionally1545944___optionally
perceptional1854904perceptiona_l_
sectionally1646824__sectionally
unexceptionable2881884unexceptionable
unexceptional2462514unexceptiona_l_
vocationally20125004voc_ationally
acceptingly2152615accepti_n_gly
actinally1448235_ac__ti_nally
actionably17105515_ac__tionably
additionally1753315_additionally
ascetically1848405asce_ti_cally
aseptically1847415_asepti_cally
avocationally21113695avocationally
conceptional1856915conceptiona_l_
conditionally1954785conditionally
conventionally2254975conventionally
devotionally1953725_devotionally
dimensionally1962355dimensionally
eccentrically1963435eccentrically
eclectically1855475eclecti_cally
eidetically1768225eide_ti_cally
electorally1654265e_lect_orally
elliptically1955125ellipti_cally
emetically17411425e_me_ti_cally
epileptically2253925epilepti_cally
erosionally1454665e__rosionally
essentially1455115essenti__ally
excavational2452765excavationa_l_
exceedingly2551935exceedi_n_gly
excepting2145875excepti_n___g
excerption2145065excerption____
excerptions2244985excerption___s
excisional1953845exc_isiona_l_
excitingly2343185exc_iti_n_gly
exclusionary2462245exclusiona_ry
exotically2249495ex__oti_cally
expeditionary2691605expeditiona_ry
extemporally2662185exte_mporally
extensional1854185extensiona_l_
extensionality2461985extensionality
externally2045545ex___ternally
extortionary2262695extortiona_ry
extortionately2471535extortionately
fractionally2055295_fractionally
frictionally2054925_frictionally
functionally2054975_functionally
generationally1883005generationally
gradationally1853265gradationally
inflectionally2262955inflectionally
intensionally1654395intensionally
intestinally1556015intesti_nally
irrationally1555245_irrationally
microtonally1953575microt_onally
mutationally1754275_mutationally
nationally1348425___nationally
notionally1347085___notionally
nutritionally16103545nutritionally
objectionably29132225objectionably
obsessionally1862385obsessionally
occasionally1952755_occasionally
operationally1854645operationally
perceptually2153065percept__ually
positionally1754925_positionally
probationally2054095probationally
processionally2163135processionally
questionably2652915_questionably
rationally1349425___rationally
regionally1445535__re_gionally
relationally1555075_relationally
semitonally1654685__semitonally
sensationally1654305sensationally
situationally1653395situationally
skeptically2245775_skepti_cally
successionally2161445successionally
traditionally1753805traditionally
unemotionally1853765unemotionally
valuationally1962525valuationally
variationally1953005variationally

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.393454684.5
2DLD Change Limit1247901039.34313356.5
3Display Results1031030.0631634.9
 (SQL Overall)1786911039.79918235.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.