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

114 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
astound84550(None) 
astounds964231astounds
stound7399901_stound
abound9239862a_bound
aground9216182aground
around72712412a_round
astony9510522asto_ny
astounded1143222astounded
eastbound1252332eastbound
sound64420022_s_ound
stounds8377822_stounds
swound10377632_swound
abounds10217083a_bounds
abscond1244503absco_nd
account11109043account
adnoun757033adnoun_
adnouns835453adnouns
airbound1144123airbound
almond91410433almo_nd
aloud65018073a_lou_d
amount8414483a_mount
ascend9429733as_cend
astern64815813astern_
astheny1345293astheny
astonied978983astonied
astounding1244153astounding
astute6310763ast_ute
aswoon947013aswoon_
atone56527983a_to_ne
atoned75417543a_toned
atony87218853a_to_ny
attend7258973a_ttend
attorn6310793attorn_
attorned955363attorned
attorns738443attorns
attune637983a_ttune
attuned835173a_ttuned
autoed7712823auto_ed
autoing8314043autoing
bound84819583__bound
cofound1335513cofound
disbound1245853disbound
enwound11134813enwound
expound1744373expound
found94917843__found
ground82310273_ground
hound95016483__hound
impound1235393impound
inbound10115773inbound
inwound11134973inwound
mastoid10711233masto_id
misbound1344933misbound
missound1145113missound
mound83918313__mound
obtund945583obt_und
orotund844063orotund
osmund933803os_mund
outbound1146583outbound
outfound1245763outfound
pastored1139973pastored
potbound1344033potbound
pound84417863__pound
rebound1058583rebound
redound968173redound
refound1157413refound
resound869263resound
rewound1156433rewound
rotund737293rot_und
round64318433__round
secund937103_secund
should1038033_should
sounds74616183_s_ounds
stand65923283_st_and
stoked114718293_stoked
stoled74521593_stoled
stolid74213183_stolid
stone55431183_sto_ne
stoned75923143_stoned
stony85818643_sto_ny
stood65517713_sto_od
stoped94721013_stoped
stored75524213_stored
stounded10276213_stounded
stoup75517073_stou_p
stoups85313273_stoups
stour54916743_stou_r
stoure64814943_stoure
stours65015633_stours
stoury9529943_stoury
stout57434053_stou_t
stouts65019003_stouts
stowed105817203_stowed
strand74514823_strand
stroud7310383_strou_d
strung75213023_strung
strunt64918913_strunt
stud56220093_st_u_d
stun45623453_st_un_
stung65417153_st_ung
stunk94616293_st_unk
stuns54719493_st_uns
stunt55328173_st_unt
swoun84811493_swoun_
swounds11405643_swounds
swouned11366663_swouned
swouns9358243_swouns
unbound10158393unbound
unfound11127393unfound
unround8138503unround
unsound8158433unsound
unwound11126613unwound
upbound12134813upbound
westbound1541993westbound
wound94414213__wound

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 Limit1340271146.72019944.5
3Display Results1141140.0432651.2
 (SQL Overall)1786911147.16924925.5
 
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.