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

103 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
spherics153707(None) 
spheric14510071spheric_
aspheric1547982aspheric_
sferics1236132s_ferics
sherifs13299682s_herifs
sphenic1449092sphenic_
spheres123114352spher_es
spherical1645802spherical
spherier1337782spherier
spheriest1438382spheriest
sphering142811942sphering
spheroids1545542spheroids
aperies9423203ap_eries
aphasics15257243aphasics
aphesis12610513aphesi_s
aphetic142912853aphetic_
aphonics15259523aphonics
aspherical1754453aspherical
asthenics1486403asthenics
chemics16349583_chemics
clerics1149333_clerics
enterics10312853enterics
ephebic1646513ephebic_
ephedrins1544153ephedrins
esthetics14106963esthetics
etheric12311783etheric_
euphenics16115363euphenics
fluerics1345393fluerics
generics11118793generics
herdics13249523__herdics
heroics122912003__heroics
icterics1247063icterics
inherits11310103inherits
numerics1266283numerics
peeries93623023_peeries
perils84121853_p_erils
peris75537073_p_eri_s
phobics16286703_phobics
phonics143110723_phonics
photics142810483_photics
physics17265963_physics
poetics11312073_poetics
pterins9812993_pterins
scenics1137773s_cenics
scherzos2243703scherzos
schriks16185743sch_riks
seracs84418573s__eracs
series64540973s__eries
serifs94017053s__erifs
serins64029673s__erins
sharias102516003s_harias
sharifs13279903s_harifs
sheiks132510013s_he_iks
sherds105614723s_her_ds
sherif122915243s_heri_f
sheriff16287693s_heriff
sheriffs17253923s_heriffs
sherpas1238093s_herpas
sherries111812893s_herries
sherris10168803s_herris
shris84221453s_h_ri_s
spagyrics1741523spagyrics
spareribs1353283spareribs
sparids103512123sp_arids
spastics1237503spastics
species11314133sp_ecies
specs96916673sp_e__cs
speering113116323speering
speerings12276843speerings
speers85019953speer__s
speils84116223sp_e_ils
speirs85013233sp_e_irs
speiss84311643sp_e_iss
spermic1338523sp_ermic_
sperms102512603sp_er_ms
sphenes123013163sphe_nes
sphenoids1544673sphenoids
spheral1238423spher_al
sphere113313663spher__e
sphered133512313spher_ed
sphericity2053813sphericity
spheroid1447283spheroid
spherule1343843spherule
spherules1443823spherules
sphery14318883spher__y
spiceries1349313spiceries
spics94123243sp___ics
spiering112713353spiering
spiers84421743spier__s
spirits94112623sp_irits
splenic1148663splenic_
splenius1046033splenius
sprigs94814773sp__rigs
sprits85122533sp__rits
spurries102311323spurries
steric8317063s_teric_
sthenias1178163sthenias
sthenic1268903sthenic_
suberic11312213suberic_
suberins10315093suberins
syphering18175733syphering
syphers15317273sypher__s
theriacs1336543_theriacs

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 Limit1461621037.40619735.6
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.87222699.6
 
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.