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

90 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
astheny134529(None) 
ashen87818672as_hen_
asthenia1167712asthenia
asthenic1378632asthenic
astony9510522ast_ony
abhenry1543333a_bhenry
achene11313813a_chene
aesthete1145853aesthete
aether94213673aethe_r
aethers103614943aethers
alchemy1743113alchemy
althea938193althe_a
altheas1038223altheas
anthem113410343anthe_m
anthems12309423anthems
anther93715063anthe_r
anthers103715203anthers
archery15478063archery
artery9911453art_ery
ascend9429733as_cend
ascent84519653as_cent
ashed97829773as_he_d
ashes86230613as_he_s
ashing107824093as_hing
ashmen1168173ashmen_
ashtray13805553ashtray
ashy107717353as_h__y
aspen75216093as_pen_
aspens85013353as_pens
asphyxy2541383asphyxy
assent65119953as_sent
aster55434893ast_e_r
astern64815813ast_ern
asters65631603ast_ers
asthenias1277453asthenias
asthenics1486403asthenics
asthenies1278063asthenies
asthma11126563asth_ma
asthmas12117363asthmas
astound845503astound
astray95615543ast_ray
astutely1153643astutely
atony87218853a_t_ony
attend7258973a_ttend
attent62818323a_ttent
autogeny1245233autogeny
dithery14318943dithery
earthen1039253earthen_
esthete1047433esthete
ethene93312923_ethene
fasten95114893fast_en_
fastens105511753fast_ens
hasten95718563hast_en_
hastens106214813hast_ens
isogeny11196363isogeny
lathery133911123lathery
lithely1356643lithely
mastery124214323mast_ery
masthead1435883masthead
mothery153710513mothery
pschent1437413pschent
saphena1235863saphena
sateen63815013sateen_
sateens73710753sateens
satiety1038203satiety
satiny93817983sat_iny
sheeny124912193_sheeny
shend94719973_s_hend
shent85933493_s_hent
shiny115122143_s_hiny
sithens1039383sithens
sphene113412403_sphene
sphery14318883_sphery
steely93612573_steely
steno54716863_st_eno
stent55634513_st_ent
stewy116112063_st_ewy
stey76224413_st_e_y
sthenia1058503_sthenia
sthenic1268903_sthenic
stoney96217353_stoney
stony85818643_st_ony
sweeny12358843_sweeny
teeny85417883__teeny
then78429693__then_
thens85921833__thens
thewy146311853__thewy
they107223753__the_y
wastery134610993wast_ery
xanthene1855553xanthene

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.1561145455.1
2DLD Change Limit134027907.08018930.4
3Display Results90900.0303000.0
 (SQL Overall)178691907.26624592.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.