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

167 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
validly143557(None) 
vapidly1635061vapidly
acidly125211792_acidly
aridly105513702_aridly
avidly13548782_avidly
baldly12479832bal_dly
gelidly1234752gelidly
invalidly1642762invalidly
pallidly1444062pallidly
rabidly1336252rabidly
rapidly1336522rapidly
solidly1137352solidly
vainly1258502va_inly
valid94618392valid__
validity1545992validity
variedly1544752variedly
vividly1744232vividly
acidy117214903_acid_y
acridly13396533acridly
agedly1136463_agedly
alible8311973_alible
alidad838883_alidad
alienly1037503_alienly
ally76935643_al__ly
badly114918763ba__dly
baldy115518933bal_d_y
balkily16266693balkily
bally105530103bal__ly
balmily14216463balmily
bawdily1635803bawdily
bifidly1684233bifidly
blandly1336043blandly
blindly1335743_blindly
boldly12399423bol_dly
cagily12411563cagi_ly
calicle113111433calicle
calmly1337613cal_mly
candidly1545213candidly
childly1644803childly
coldly12459953col_dly
daily95922333da_i_ly
dally95324743dal__ly
dandily12279633dandily
datedly1236023datedly
daylily1434983dayli_ly
dazedly2134063dazedly
easily9313023easi_ly
fadedly1535453fadedly
fairly125610013fa_irly
fallibly1644393fallibly
falsely1336013falsely
family143311703fami_ly
fetidly1435013fetidly
fluidly1434813fluidly
gaily95020973ga_i_ly
gainly1049323ga_inly
gallfly1433523gallfly
gally95026173gal__ly
gamily123712183gami_ly
gaudily1236523gaudily
gladly11497933_gladly
glibly1236293_glibly
gravidly1653743gravidly
halid94424983halid__
halide103417993halid_e
halides113416663halides
halidom1386443halidom
halids104016133halid_s
handily143610873handily
hardily143310273hardily
hardly135112833ha_rdly
hazily2179063hazi_ly
holiday1436143holiday
holily123612953holi_ly
humidly1643973humidly
idly85617333___idly
jadedly1934013jadedly
lacily11612763laci_ly
lairdly1134913lairdly
lazily1859713lazi_ly
lily76730193__li_ly
lividly1434783lividly
lucidly13125213lucidly
luridly1196283luridly
madly115218133ma__dly
mainly11411493ma_inly
malady1237863malad_y
malignly1444683malignly
manlily1238743manli_ly
mazedly2234433mazedly
mazily20610393mazi_ly
mildly12318243mil_dly
nakedly1534403nakedly
oilily93111723oili_ly
ovality1377593ovali_ty
ovally12278443oval__ly
palely11311933pal_ely
pally105727123pal__ly
placidly1644163placidly
plainly1236473plainly
racily11715173raci_ly
rally84725903ral__ly
rancidly1444433rancidly
rigidly1235533rigidly
sadly94519123sa__dly
salably121610743salably
salify12311373sali_fy
sally85129713sal__ly
saltily10310543saltily
slily85820033_sli_ly
slimly11408903_slimly
squalidly2242323squalidly
staidly1136683staidly
stolidly1243833stolidly
tacitly1236223tacitly
tally84526863tal__ly
tardily11269583tardily
tepidly1334413tepidly
timidly1334593timidly
tumidly1333743tumidly
uglily1036193ugli_ly
vagally1435833vagally
vagile10310543vagi_le
vaguely1443693vaguely
vail75432553va_i_l_
vails85825933va_i_ls
vakil1259793vaki_l_
vakils1337593vaki_ls
valency1565463valency
valiancy1674823valiancy
valiant10314623valiant
valiantly1544193valiantly
validate1239003validate
valine94623093vali_ne
valines104520213valines
valise92917643vali_se
valises103516263valises
valley124311603val_ley
valuably1644713valuably
valval12398863valval_
valvula1343253valvula
valvule1343663valvule
vanilla10238743vanilla
vanity12311933vani_ty
vapid115614283vapid__
vapidity1745193vapidity
variably1637433variably
variety1337743variety
variola1068893variola
variole10711593variole
vastly12508723va_stly
veiledly1543153veiledly
verily122616053veri_ly
vexedly2143463vexedly
vilely1239443vil_ely
vilify1536773vili_fy
viscidly1753303viscidly
visibly1535043visibly
volubly1543553volubly
waddly14478723wa_ddly
wally114625093wal__ly
warily122915093wari_ly
wavily15219483wavi_ly
waxily19218413waxi_ly
wildly13328123wil_dly
wilily123310763wili_ly
zanily18310183zani_ly

Search took 8 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.406440125.6
2DLD Change Limit1340271676.84319586.0
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.31224438.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.