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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
vapidly163506(None) 
rapidly1336521rapidly
validly1435571validly
acidly125211792_acidly
aridly105513702_aridly
avidly13548782_avidly
rabidly1336252rabidly
tepidly1334412tepidly
vainly1258502va_inly
vapid115614282vapid__
vapidity1745192vapidity
variedly1544752variedly
vividly1744232vividly
acidy117214893_acid_y
acridly13396533acridly
agedly1136463_agedly
apiary113910383_apiary
apishly1535663_apishly
apply125111393_ap_ply
aptly105111813_ap_tly
badly114918763ba__dly
baldly12479833ba_ldly
bawdily1635803bawdily
bifidly1684233bifidly
cagily12411563cagi_ly
campily1638273campi_ly
candidly1545213candidly
capably1639253capably
daily95922333da_i_ly
dandily12279633dandily
datedly1236023datedly
dazedly2134063dazedly
dopily123510463dopi_ly
easily9313023easi_ly
fadedly1535453fadedly
fairly125610013fa_irly
family143311703fami_ly
fetidly1435013fetidly
fluidly1434813fluidly
gaily95020973ga_i_ly
gainly1049323ga_inly
gamily123712183gami_ly
gapingly1536183gapingly
gaudily1236523gaudily
gelidly1234753gelidly
gravidly1653743gravidly
handily143610873handily
haply135915063hap__ly
happily1745763happily
hardily143310273hardily
hardly135112833ha_rdly
hazily2179063hazi_ly
humidly1643973humidly
idly85617323___idly
invalidly1642763invalidly
jadedly1934013jadedly
japingly2135763japingly
lacily11612763laci_ly
lairdly1134913lairdly
lapidary1454093lapidary
lapides103012043lapides
lapidify1742803lapidify
lapilli945643lapilli
lazily1859713lazi_ly
limpidly1643153limpidly
lividly1434783lividly
lucidly13125213lucidly
luridly1196283luridly
madly115218133ma__dly
mainly11411493ma_inly
mazedly2234433mazedly
mazily20610393mazi_ly
nakedly1534403nakedly
pallidly1444063pallidly
papally1437973papally
papilla11127913papilla
piddly13319143__piddly
pily96132733__pi_ly
placidly1644163placidly
racily11715173raci_ly
rancidly1444433rancidly
rapid86422033rapid__
rapider1067903rapider
rapidity1446273rapidity
rapids94913893rapid_s
raptly11338913rap_tly
rigidly1235533rigidly
ropily113312443ropi_ly
sadly94519123sa__dly
sapid84720933sapid__
sapidity1446433sapidity
sappily1437163sappily
soapily1237963soapi_ly
solidly1137353solidly
spindly13257383_spindly
staidly1136683staidly
stupidly1442633stupidly
tacitly1236223tacitly
tardily11269583tardily
timidly1334593timidly
torpidly1483653torpidly
tumidly1333743tumidly
vagally1435833vagally
vagile10310543vagi_le
vaguely1443693vaguely
vail75432553va_i_l_
vails85825933va_i_ls
vakil1259793vaki_l_
vakils1337593vaki_ls
valid94618393valid__
validity1545993validity
vampishly2243113vampishly
vanilla10238743vanilla
vanity12311933vani_ty
vapory14398763vap_ory
vapoury15284803vapoury
variably1637433variably
variety1337743variety
variola1068893variola
variole10711593variole
vastly12508723va_stly
verily122616053veri_ly
vexedly2143463vexedly
viscidly1753303viscidly
visibly1535043visibly
waddly14478723wa_ddly
warily122915093wari_ly
waspily1535513waspi_ly
wavily15219483wavi_ly
waxily19218413waxi_ly
zanily18310183zani_ly

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 Filter1786911340270.440406115.9
2DLD Change Limit1340271317.87317023.6
3Display Results1311310.0462847.8
 (SQL Overall)1786911318.35921377.1
 
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.