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

72 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
asterisk124869(None) 
asterisks1346831asterisks
asterism10413271asterism
asteria7316202asteri_a
asterias8317042asterias
asterisked1542912asterisked
asterisms11511082asterisms
asters65631602aster_s_
actorish1349453actorish
afters94717073after_s_
altering91917123altering
alterity1149853alterity
alters64924223alter_s_
anterior8611073anterior
apteria9312923apteri_a
apterium1249153apterium
arterial8313653arterial
arteries8321513arteries
ascaris93613323ascaris_
ascesis938373ascesis_
askers105915403asker_s_
askesis1136123askesis_
asperity1347223asperity
aspers86220313asper_s_
asperse94210663asper_se
asserts74311793asserts_
aster55434893aster___
asterisking1652973asterisking
astern64815813aster__n
asternal858323asternal
asteroid9511213asteroid
asteroids1048753asteroids
astonish1148473astonish
astrict9614793ast_rict
astride8311973ast_ride
austerest948653austerest
austerity1245813austerity
autecism1247073autecism
auteurism1144623auteurism
auteurist946793auteurist
basters94930313baster_s_
casteism1247073caste_ism
casters94729903caster_s_
easters75125683easter_s_
esterase849483esterase
esterify1445623esterify
esters64627733ester_s_
gasters85624303gaster_s_
laserdisk1451653las_erdisk
lasters75627693laster_s_
lutefisk1542693lutefisk
masteries111018513masteries
mastering122315313mastering
masters94628923master_s_
pastelist1149633pastelist
pasterns104112623pasterns_
pasters94531733paster_s_
pasteurise1244123pasteurise
rasters74629023raster_s_
satirise8310683satirise
satirist8313503satirist
satoris7317253satoris_
steres63929533_steres_
steric8317063_steri_c
sterile7316603_sterile
sterns64616763_sterns_
strick124813203_st_rick
tasters74225643taster_s_
wasterie111211593wasteri_e
wasteries121115363wasteries
wasters104026593waster_s_
waterish14310543waterish

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 Filter1786911461620.423422437.4
2DLD Change Limit146162726.67021913.3
3Display Results72720.0461565.2
 (SQL Overall)178691727.13925030.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.