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 “aspheric” 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
aspheric154798(None) 
spheric14510071_spheric
aetheric13410162aetheric
aphetic142912852a_phetic
aspherical1754452aspherical
asthenic1378632asthenic
sphenic1449092_sphenic
spherics1537072_spherics
aesthetic1497843aesthetic
alchemic1745253alchemic
alphameric1952863alphameric
amphoteric1953593amphoteric
anaphoric1646253anaphoric
anthemic15410323anthemic
antherid12611093antherid
aphasic142810063a_phasic
aphelia1249423a_phelia
apheretic1687413a_pheretic
aphesis12610513a_phesis
aphonic142713393a_phonic
aphotic142913123a_photic
apneic1078623a_pne_ic
apteria9312913a_pteria
ascetic11310063as_cetic
asper75520433asp_er__
asperity1347223asp_erity
aspers86220313asp_er_s
asperse94210663asp_erse
asphaltic1644603asphaltic
asphyxia2342873asphyxia
aspic95114733asp___ic
aspirin937823asp_irin
asteria7316183as_teria
asthenia1167713asthenia
asthenics1486403asthenics
atmospheric2052973atmospheric
biospheric1954253biospheric
camphoric2045483camphoric
dysphoric2044023dysphoric
ephebic1646513_ephebic
esoteric1057593esoteric
esthetic13119773esthetic
etheric12311783_etheric
euphenic1557203euphenic
euphoric15107043euphoric
exospheric2453543exospheric
hyphenic2147003hyphenic
ischemic1744673ischemic
isomeric1247753isomeric
nephric1446213neph_ric
sachemic1746083sachemic
sapremic1445333sapremic
sherif122915243_s_herif
spermic1338523_sp_ermic
spheral1238423_spheral
sphere113313663_spher_e
sphered133512313_sphered
spheres123114353_spheres
spherical1645803_spherical
spherier1337783_spherier
sphering142811943_sphering
spheroid1447283_spheroid
sphery14318883_spher_y
splenic1148663_splenic
steric8317063_s_teric
sthenic1268903_sthenic
suberic11312213_suberic

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.420425454.8
2DLD Change Limit146162676.97020970.2
3Display Results67670.0302233.3
 (SQL Overall)178691677.42024082.3
 
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.