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

67 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
astonish114845(None) 
stonish10410651_stonish
actorish1349432actorish
admonish1446032admonish
astonied978982astonied
astonies8815092astonies
astonished1443402astonished
astonishes1344532astonishes
tonish93415902__tonish
abolish12311503a_bolish
actinism12119883actinism
adonis7314063a_donis_
agonise83112693a_gonise
agonist82615403a_gonist
altoist7313393alto_ist
arsonist8412013arsonist
aslosh966233aslo__sh
aspish114810333as__pish
asterisk1248673asterisk
asterism10413253asterism
astonishing1553363astonishing
astony9510523aston__y
astonying1345233astonying
astounds964233astounds_
atomise93013823a_tomise
atomism112610963a_tomism
atomist92915763a_tomist
atones65225773a_tones_
atonia63816513a_toni_a
atonias73315993a_tonias
atonic83420473a_toni_c
atonics93613713a_tonics
atonies75320953a_tonies
atoning83514873a_toning
baboonish1653193baboonish
cartoonish1563623cartoonish
cronish12310863_cronish
daltonism1245573daltonism
dronish1138913_dronish
jargonish2043983jargonish
lemonish1347323lemonish
monish114217593__monish
moonish123311043_moonish
ostosis71310123ostosis_
parsonish1446323parsonish
satanism1039673satanism
satanist8313373satanist
satoris7317253satoris_
slowish1337633_slowish
sottish10129443_sottish
standish1238543_standish
stockish17186043_stockish
stonefish1544063_stonefish
stones65130033_stones_
stonier72013793_stonier
stoniest8413543_stoniest
stonily1049433_stonily
stoning83717443_stoning
stonished1345593_stonished
stonishes1247363_stonishes
stoutish1145903_stoutish
strongish1344923_strongish
stylish13197443_stylish
swinish1347203_swinish
tonnish10149093__tonnish
townish13167933__townish
toyish122911123__toyish

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit146162677.89018525.0
3Display Results67670.0164187.5
 (SQL Overall)178691678.32921454.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.