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

215 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
sternal7341191(None) 
asternal858321asternal
eternal72910891eternal
sterna63712761sterna_
cisternal11325742cisternal
eternals8238952eternals
external1577222external
internal8414082internal
maternal1047802maternal
paternal1038332paternal
seral56336382s_er_al
serial64625862s_erial
serval93913412s_erval
steal56125472ste__al
sterical10311252sterical
stern55319122stern__
sterner7411912sterner
sternly1037852sternly
sterns64616762stern_s
sternum947732sternum
sternway1443152sternway
sterol6613332ster_ol
supernal1039872supernal
tarnal63716502_tarnal
tergal72912832_tergal
vernal93514212_vernal
adrenal838263adrenal
aerial64625713_aerial
antennal856353antennal
apteral9311523apter_al
arterial8313633arterial
asteria7316183asteria_
asterias8317013asterias
astern64815813astern__
astral66919283ast_r_al
atonal6514023at_onal
atrial65418943at_rial
carnal83919213_carnal
cercal10314123_cercal
cereal8315833_cereal
cisterna10376363cisterna_
cisternae11265093cisternae
coeternal1144303coeternal
dermal93614343_dermal
diurnal844883diurnal
enteral73516443enter_al
estral64716513est_r_al
estrual7367933est_rual
eternally1247493eternally
eterne6311723etern_e
ethereal1146783ethereal
externals1666623externals
feral85424653_fer_al
ferial94621253_ferial
fraternal1243873fraternal
herbal112513493_herbal
hernial10310433_hernial
hibernal1344403hibernal
infernal1186823infernal
internals9712723internals
interval11710463interval
iterant7317783iterant
journal1484963journal
kernel104010593_kernel
lateral7313573later_al
lienal63912783lie_nal
literal7613273liter_al
material10314103material
osteal6312963oste__al
penal75228373_pe_nal
pleonal937243pleonal
preanal9310713preanal
prerenal1049083prerenal
pteryla1243303pteryla
regnal74812933_regnal
renal55929503_re_nal
retinal75318353retinal
retral64419743retr_al
retrial7615553retrial
sacral83414413sacr_al
scena74815783sce_na_
scenas84114703sce_nas
scleral937863scler_al
seal45654373s_e__al
seconal9310073seconal
seminal91213413seminal
sendal73314993s_endal
senna54617983s_enna_
sennas64214233s_ennas
sepal77723003s_e_pal
septal84513383s_eptal
sera46141393s_er_a_
serac75925203s_er_ac
serai56830163s_er_ai
serail64222673s_erail
serdab937833s_erdab
serials73919743s_erials
serosal7311153s_erosal
serumal938783s_erumal
servals103410743s_ervals
setal56430903s_e_tal
several1039533sever_al
sexual1338413s_exual
sheal84927703she__al
sherpa1138093sherpa_
sherpas1238093sherpas
sidereal946053sidereal
sienna647193sienna_
siennas736123siennas
sierra637313sierra_
sierran737193sierran
sierras737863sierras
signal73711483s_ignal
special11310303special
spheral1238423spher_al
spinal84915313s_pinal
spiral83715343spir_al
sporal82915453spor_al
staminal1046983staminal
stanol6310723st_anol
statal61613223st_atal
stead65520273ste__ad
steak95219803ste__ak
steals64020063ste__als
steam76322933ste__am
steel55721993ste__el
stein54620543stein__
steins64818343stein_s
stela54019043ste_la_
stelae63716483ste_lae
stelai63912563ste_lai
stelar64013863ste_lar
stella63612973stella_
stellar72610433stellar
stellas72813043stellas
stemma10328133stemma_
stemmas11256973stemmas
stench114111163ste_nch
stencil946893stencil
stengah1144563stengah
steno54716863ste_n_o
stenos63915773ste_nos
stent55634513ste_n_t
stents65019453ste_nts
stere55328543ster__e
stereo65317913ster_eo
stereos74314973stereos
steres63929533ster_es
steric8317063ster_ic
sterile7316603sterile
sterlet71318473sterlet
sternest8314433sternest
sternite8310543sternite
sternson844843sternson
sternums1045783sternums
sternward1343123sternward
sternways1542593sternways
steroid81314863steroid
steroidal1045473steroidal
sterols7313443sterols
stertor7310093stertor
stewpan1234193stewpan
stibial946583stibial
stigmal10245923stigmal
stoical9310283stoical
stomal85213313st_omal
storax1389783stor_ax
strand74514823st_rand
strang75718313st_rang
strap77925263st_r_ap
stratal72710603stratal
straw813321293st_r_aw
stray88525573st_r_ay
streak104613623st_reak
stream84717293st_ream
streel64214023st_reel
stria55723213st_ria_
striae65422273st_riae
stroll6311603st_roll
stromal93010593stromal
styrax1675243styr_ax
sural55931263s_ur_al
surreal739233surreal
sutural7310223sutur_al
tarsal63315273_tarsal
teal45546503_te__al
tectal83713253_tectal
telial65815363_telial
tenail64516113_te_nail
tepal76319583_te_pal
terai53525483_ter_ai
tercel83612993_tercel
terga63315643_terga_
terminal1039733_terminal
tern46134803_tern__
ternary1038343_ternary
ternate7415483_ternate
terne56426153_tern_e
ternes65422903_ternes
terns55226873_tern_s
terra54419663_terra_
terrae62915213_terrae
terras63516973_terras
tertial7313863_tertial
tetanal738023_tetanal
thenal92712423_thenal
thermal125010973thermal
tonal53724303_t_onal
trenail7410813_trenail
trial54926353_t_rial
trinal6516963_trinal
veinal93812963_veinal
venal85523213_ve_nal
verbal112513663_verbal
versal93013753_versal

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272156.79619721.5
3Display Results2152150.0802687.5
 (SQL Overall)1786912157.29924481.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.