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 “thirdly” 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
thirdly144463(None) 
buirdly1334212buirdly
childly1644802childly
hardly135112832_hardly
lairdly1134912lairdly
thickly19415572thickly
thinly1238672thi_nly
third95912492third__
thirds10438602third_s
thirl85416822thir_l_
thirls95012062thir_ls
thirsty1354082thirsty
thirty12378402thir_ty
thistly1395962thistly
tiddly11308782t_iddly
tiredly1136802t_iredly
twiddly15233772twiddly
twirly12427082twir_ly
weirdly14274492weirdly
whirly15448862whir_ly
acidly125211793aci_dly
acridly13396533acridly
airily93014823_airily
aridly105513703ari_dly
avidly13548783avi_dly
bairnly1234503bairnly
blindly1335743blindly
charily15310283charily
chicly16429203chi_cly
chiefly1834103chiefly
chilly144113223chi_lly
chimbly1974593chimbly
chiral114614413chiral_
chirpily1843773chirpily
chirpy16498913chir_py
diddly12389573_diddly
direly10311563_direly
fairly125610013fair_ly
fiddly14328483_fiddly
firmly1436663_firmly
girdle82110463_girdle
girly94415293_gir_ly
hardily143310273_hardily
hardy125622063_hard_y
highly1636823_highly
hilly114422163_hi_lly
hiply134113613_hi_ply
hirple11158973_hirple
hirsle9159573_hirsle
hurdle103712793_hurdle
hurly115819293_hur_ly
idly85617323__i_dly
kindly14358843_kindly
lordly1038753_lordly
luridly1196283luridly
mildly12318243_mildly
piddly13319143_piddly
sharply15406833sharply
shily115222013shi__ly
shindy13449323shind_y
shingly143210813shingly
shinily13268933shinily
shirty124312563shir_ty
shortly13387573shortly
shrilly13318563shrilly
spindly13257383spindly
staidly1136683stai_dly
swirly12439253swir_ly
tardily11269583t_ardily
tardy94720463t_ard_y
tartly96014023t_artly
tearily10311153tearily
tepidly1334413tepidly
termly1138433t_ermly
thegnly1442613thegnly
therapy1536613therapy
thereby1534633thereby
thill85918733thi__ll
thills95515383thi_lls
thimble1435873thimble
thiol87616043thi_ol_
thiols95112763thi_ols
thionyl1343713thionyl
thir76420543thir___
thiram1139963thir_am
thirams1236823thirams
thirled11328093thirled
thirst9312253thir_st
thirstily1542693thirstily
thirsts1036243thirsts
thistle10107803thistle
thornily1444163thornily
thorny12509843thor_ny
thrall93810293th_rall
thrifty1634193thrifty
thrill94910593th_rill
thrills10398783thrills
thurl84912683thur_l_
thurls9418713thur_ls
thusly1235133th_usly
thwartly1742703thwartly
tidily102811393t_idily
tidy86822413t_i_d_y
timely113410113t_imely
timidly1334593timidly
tingly103815973t_ingly
tinily94014433t_inily
tinkly134811153t_inkly
tirl45029923t_ir_l_
tirls54519803t_ir_ls
torridly1284473torridly
towardly1543653towardly
trickly16369893trickly
trigly103810943tri_gly
trimly114410893tri_mly
trindle83311363trindle
triply114211023tri_ply
tritely1039003tritely
truly84111553t__ruly
tumidly1333743tumidly
twiddle12305483twiddle
twinkly1733913twinkly
twirl85011943twir_l_
twirls9478123twir_ls
weirdy13395463weird_y
whirl114913823whir_l_
whirls124710533whir_ls
whirry15477063whir_ry
whitely16346473whitely
wildly13328123_wildly
wirily123310783_wirily

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.420425454.8
2DLD Change Limit1340271315.69023554.8
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.15629027.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.