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

147 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
acridly1339653(None) 
acidly125211791ac_idly
aridly105513701a_ridly
acidy117214892ac_id_y
acrid86920102acrid__
acrider1038622acrider
acridity1446912acridity
aerily93017012aeri_ly
airily93014822airi_ly
avidly13548782a_vidly
luridly1196282luridly
sacredly1444472sacredly
abridge1135693abridge
acarid95017073acarid__
acaridan1165233acaridan
acarids105312243acarid_s
accidia1246993accidia
accidie1247733accidie
achingly1736623achingly
acid77533393ac_id__
acidic113612133ac_idic
acidify1645243ac_idify
acidity1338593ac_idity
acids87121003ac_id_s
acred87126353acred__
acridest1138143acridest
acridine1139553acridine
acrimony1543563acrimony
actively1647063actively
actorly1246423actorly
acuity1139373acui_ty
acutely1246123acutely
addedly1344293addedly
adroitly1243363adroitly
aerial64625713aerial_
aerially11911913aerially
aerials74017553aerials
aerify122810113aeri_fy
agedly1136463a_gedly
angrily1137723angri_ly
anticly12410053anticly
archly1437353a_rchly
ariary94114203a_riary
arid57642713a_rid__
arider74717743a_rider
aridity11510113a_ridity
ariel55228973a_riel_
ariels65119373a_riels
aril45843023a_ri_l_
arils58732203a_ri_ls
artily92814713a_rtily
atrial65418943atrial_
audibly13216043audibly
aurally10310543aurally
auricle9139813auricle
bifidly1684233bifidly
bridle94115463_bridle
buirdly1334213buirdly
cagily12411563cagi_ly
candidly1545213candidly
cariole9818343cariole
chicly16429203_chicly
childly1644803_childly
chilly144113223_chilly
coldly12459953_coldly
cradle93313163_cradle
crawly144610763_crawly
crikey15317783_crikey
crimpy15489393_crimpy
crinkly16387523_crinkly
crisply14426523_crisply
crispy13478563_crispy
cruddy1334193_cruddy
crudely1336273_crudely
cuddly13388413_cuddly
drily95816523_dri_ly
eerily92913563eeri_ly
fervidly1863323fervidly
fetidly1435013fetidly
flaccidly2041773flaccidly
floridly1554593floridly
fluidly1434813fluidly
frilly124111443_frilly
gelidly1234753gelidly
gorily10612503gori_ly
grimly12459933_grimly
grisly104310583_grisly
hardily143310273hardily
hardly135112833har_dly
horridly15114793horridly
humidly1643973humidly
icily101211693ic_i_ly
ickily1535753icki_ly
idly85617323___idly
lacily11612763lac_i_ly
lairdly1134913lair_dly
lividly1434783lividly
lordly1038753lor_dly
lucidly13125213lucidly
morbidly1643833morbidly
pallidly1444063pallidly
placidly1644163plac_idly
primly13439623_primly
putridly1443493putridly
rabidly1336253rabidly
racily11715173rac_i_ly
rancidly1444433rancidly
rapidly1336523rapidly
redly94217203__redly
ridgy104110643__ridgy
ridley10169543__ridley
rigidly1235533rigidly
sacristy1345103sacristy
scarily12311703scari_ly
scrawly15197193scrawly
scribbly17143623scribbly
scrimpy16486133scrimpy
shrilly13318563shrilly
solidly1137353solidly
sordidly1344663sordidly
staidly1136683staidly
tacitly1236223tac_itly
tackily1637503tacki_ly
tardily11269583tardily
tepidly1334413tepidly
thirdly1444633thirdly
timidly1334593timidly
tiredly1136803tiredly
torpidly1483653torpidly
torridly1284473torridly
trigly103810943_trigly
trimly114410893_trimly
triply114211023_triply
tumidly1333743tumidly
turbidly1443683turbidly
turgidly1343353turgidly
validly1435573validly
vapidly1635063vapidly
variedly1544753variedly
verily122616053veri_ly
vividly1744233vividly
wackily1936053wacki_ly
warily122915093wari_ly
weirdly14274493weirdly
wirily123310783wiri_ly
wordily1437853wordily
worldly1433993worldly

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.436409841.7
2DLD Change Limit1340271477.17318684.9
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.65523343.0
 
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.