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

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

95 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
vividly174423(None) 
lividly1434781lividly
avidly13548782_avidly
bifidly1684232bifidly
civilly1535482civilly
rigidly1235532rigidly
timidly1334592timidly
validly1435572validly
vapidly1635062vapidly
viscidly1753302viscidly
visibly1535042visibly
vivid125112312vivid__
vivider14265622vivider
vivify1834702vivi_fy
acidly125211793_acidly
acridly13396533acridly
airily93014823airi_ly
aridly105513703_aridly
bivinyl1542733bivinyl
civil103411933civi_l_
diddly12389573di_ddly
divide113410893divid_e
divided13378593divided
dividedly1842813dividedly
divider12278953divider
divides123211453divides
divinely1544993divinely
evilly1236593_evilly
fervidly1863323fervidly
fetidly1435013fetidly
fiddly14328483fi_ddly
fixedly2133913fixedly
fluidly1434813fluidly
frigidly1643123frigidly
gelidly1234753gelidly
giddily1335073giddily
gravidly1653743gravidly
humidly1643973humidly
icily101211693_ici_ly
idly85617323___idly
kindly14358843ki_ndly
licitly12276673licitly
limpidly1643153limpidly
liquidly2143283liquidly
lively123310813liv_ely
livid96714423livid__
lividity1545083lividity
livingly1535633livingly
lucidly13125213lucidly
luridly1196283luridly
mildly12318243mi_ldly
mixedly2033983mixedly
oilily93111723oili_ly
piddly13319143pi_ddly
privily15207623privi_ly
rabidly1336253rabidly
rapidly1336523rapidly
risibly1235643risibly
solidly1137353solidly
staidly1136683staidly
tepidly1334413tepidly
tiddly11308783ti_ddly
tidily102811393tidi_ly
tinily94014433tini_ly
tiredly1136803tiredly
tumidly1333743tumidly
vainly1258503v_ainly
variedly1544753variedly
veiledly1543153veiledly
verily122616053veri_ly
vexedly2143463vexedly
viably14199833vi_ably
vicarly1536463vicarly
vigil94313003vigi_l_
vigils104210193vigi_ls
vilely1239443vi_lely
vilify1536773vili_fy
vincibly1843583vincibly
vinify1536923vini_fy
virally1339653virally
virid94116043virid__
viridity1545903viridity
virile9313433viri_le
virilely1444053virilely
visible1236923visible
vitally1339673vitally
vivary1536983viv_ary
vividest1545203vividest
vivific1843363vivific
vixenly2043193vixenly
wavily15219483wavi_ly
wildly13328123wi_ldly
wilily123310763wili_ly
windily1437943windily
wirily123310783wiri_ly

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit134027956.09621986.1
3Display Results95950.0303166.7
 (SQL Overall)178691956.52927368.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.