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

116 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
sterical1031125(None) 
clerical1248232clerical
hysterical1854442hysterical
icterical1347212icterical
metrical12311592metrical
satirical1146882satirical
satyrical1445032satyrical
scenical1247132scenical
serial64625862s_eri_al
spherical1645802spherical
statical1039422statical
steric8317062steric__
sterically15410492sterically
sternal73411912ster_nal
steroidal1045472steroidal
stoical9310282st_oical
aerial64625713_aeri_al
arterial8313633arteri_al
ascetical1346283ascetical
aspherical1754453aspherical
asteria7316183asteri_a_
asterias8317013asteri_as
asternal858323aster_nal
asteroidal1154123asteroidal
atomical1248903atomical
atrial65418943at_ri_al
atypical1544683atypical
cercal10314123_cer_cal
cervical1546853_cervical
chemical1748393chemical
clericals1345353clericals
detrital946573detrital
epical10413393__epical
erica7316543__erica_
ericas8315463__ericas
esoterica1144273esoterica_
eternal72910893eter_nal
ethical1238443et_hical
ethnical1346363ethnical
ferial94621253_feri_al
generical1247003generical
helical12311153_helical
heroical13410023_heroical
historical1545923historical
iatrical1049273iatrical
irenical1048553irenical
lexical1637363_lexical
lubrical12116093lubrical
lyrical1236493_lyrical
material10314103materi_al
medical12312513_medical
metical11315363_metical
numerical1345973numerical
obstetrical1552353obstetrical
poetical12311533poetical
retrial7615553retri_al
rubrical1296093rubrical
satanical1145413satanical
sceptical1545343sceptical
scribal1137963s_cribal
seminal91213413s_eminal
septical1259363septical
seral56336383s_er__al
serials73919743s_eri_als
sericin9312843s_ericin
serosal7311153s_erosal
serumal938783s_erumal
serval93913413s_er_val
sferics1236133sferic_s
silvical1345223silvical
skeptical1743963skeptical
special11310303speci_al
staminal1046983staminal
steal56125473ste___al
stearic939423stearic__
stelic8313083stelic__
stencil946893ste_ncil
sterigma1144113sterigma
sterigmas1243563sterigmas
sterilant947283sterilant
sterile7316603steri_le
sterilely1244633sterilely
sterna63712763ster_na_
sternway1443153sternway
sterol6613333ster__ol
stibial946583stibi_al
stratal72710603st_ratal
stria55723213st_ri_a_
striae65422273st_ri_ae
strick124813203st_ric_k
strickle1467793st_rickle
stricks134310693st_ricks
strict84821043st_ric_t
strictly1345813st_rictly
strigil837263st_rigil
stromal93010593st_romal
styptical1643963styptical
surgical1146253surgical
syndical1445373syndical
telial65815363_teli_al
tercel83612993_ter_cel
tergal72912833_ter_gal
terminal1039733_terminal
tertial7313863_tertial
theriacal1443553theriacal
thetical1349123thetical
tical76021493_t__ical
topical1139953_topical
toxical1637643_toxical
trial54926353_t_ri_al
tribal8611133_t_ribal
trinal6516963_t_rinal
turrical1046203turrical
typical1436343_typical
vertical13410433_vertical
vesical12159813_vesical

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.436409841.7
2DLD Change Limit1461621167.12620511.1
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.60823487.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.