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

237 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
stelene731025(None) 
scalene9310772scalene
serene63522352s_erene
setline7313922setline
steelie7310212steelie
steeve93710902ste_eve
stelae63716482stel_ae
stele55026842stel__e
steles63725662stele_s
stilbene1043612stilbene
stolen64315062stolen_
styrene10116692styrene
amylene12106883amylene
athlete1068083athlete
beeline93314723beeline
butylene1344403butylene
dateline9810353dateline
delete73620703_delete
eterne6311723ete_rne
ethene93312923et_hene
ethylene1444233ethylene
feline94820143_feline
gelee63626983_gele_e
ketene106613003_ketene
melee73729103_mele_e
melena81110473_melena
musteline1146973musteline
myeline1238253myeline
relend76116453_relend
relent64431853_relent
releve95116403_releve
reline65434353_reline
retene69224273_retene
saline65132703s_aline
sateen63815013sate_en_
sateens73710753sate_ens
scaleni936883scaleni
scene77220573s__cene
secede93311993s_ecede
seeled73922093seele_d
seeling83522003seeling
seen46943123s_e_en_
seine55732873s_e_ine
select82621173s_elect
selenate81712533s_elenate
selenic9410663s_elenic
selenide9158873s_elenide
selenite81713113s_elenite
selkie102811693s_elkie
selle54428313s_el_le
sememe10129983s_ememe
semen75724103s_emen_
semens84616973s_emens
sene46848053s___ene
serener73415763s_erener
serenes73222903s_erenes
serine65432673s_erine
setlines8312743setlines
settee63721023sette_e
seven84118313s_even_
sevens93813663s_evens
severe94016083s_evere
shebeen1234553shebeen
sheen85023313she_en_
sheened113511703she_ened
sheeney13398933she_eney
sheenie10159493she_enie
sheens95116993she_ens
sheeny124912193she_eny
sheeve123412843she_eve
sheltie10109913sheltie
shelve124012763shel_ve
sideline91011093sideline
siemens938413siemens
silane62718053s_ilane
silence9310213s_ilence
sileni63312143s_ileni
silent64125843s_ilent
skeane104611373ske_ane
skeen94817403ske_en_
skeens103912913ske_ens
skene96118123s__kene
sklent103614353s_klent
skyline1436793skyline
sleeve93411593sle_eve
sneeze15318523sne_eze
spelean937123spelean
spelunk1343203spelunk
sphene113412403s_phene
spleen8310263spleen_
spleens937103spleens
spleeny1234563spleeny
splent84720193s_plent
spline86020533s_pline
squalene1745613squalene
stale55637103stal__e
staled74728103stale_d
stalely1039213stalely
staleness9310783staleness
staler64025823stale_r
stales65538293stale_s
stalest73720173stalest
staling83925423staling
stamen84115943stamen_
stamened1137633stamened
stamens93411483stamens
stane55933003st__ane
stanine73417073stanine
stealage946583stealage
stealer72913983steale_r
stealers83412213stealers
stealing93416603stealing
stearine8311903stearine
steed66024943ste_e_d
steeds73814883ste_eds
steek95418003ste_e_k
steeked124010473ste_eked
steeks103613703ste_eks
steel55721993ste_e_l
steeled83513223steeled
steelier839193steelier
steelies8312553steelies
steeling93615143steeling
steels64117983ste_els
steely93612573ste_ely
steep76020703ste_e_p
steeped103412283ste_eped
steepen9348653ste_epen
steepened1244073steepened
steepens10277113steepens
steeper93812773ste_eper
steeple937323steeple
steeps85215193ste_eps
steer55423863ste_e_r
steered83615253ste_ered
steerer73113633ste_erer
steers63820983ste_ers
steeved113610133ste_eved
steeves103410903ste_eves
stein54620543ste_in_
steins64818343ste_ins
stela54019043stel__a
stelai63912563stel_ai
stelar64013863stel_ar
stelic8313083stel_ic
stella63612973stel_la
stellar72610433stellar
stellas72813043stellas
stellate8310503stellate
stellite839533stellite
stemless1036653stemless
stemlike1436723stemlike
steno54716863st__eno
stent55634513st__ent
steplike1436733steplike
steppe10319873ste_ppe
stere55328543st__ere
stereo65317913stere_o
stereoed937883stereoed
stereos74314973stereos
steres63929533stere_s
sterile7316603sterile
sterlet71318473sterle_t
sterlets8169273sterlets
sterling93615553sterling
stern55319123ste_rn_
sterna63712763ste_rna
sterner7411913sterner
sterns64616763ste_rns
stewed104814243stewe_d
stewing113412493stewing
stibine938663stibine
stilbenes1143933stilbenes
stile54931573stil__e
stiles64328773stile_s
stipend10386553stipend
stole54928813stol__e
stoled74521593stole_d
stoles63927673stole_s
stollen747593stollen_
stollens835293stollens
stolon64112073stolon_
stolons73410243stolons
stone55431183st__one
student848343student
stylate10179773stylate
style85519363styl__e
styled105613103style_d
styler94013303style_r
stylers10359353stylers
styles94418653style_s
stylet94018573style_t
stylets10369213stylets
styling112910653styling
stylise10208953stylise
stylite10219613stylite
stylize19177453stylize
styrenes11116623styrenes
subline9316893subline
subvene1238493subvene
sullen62914293sullen_
sullener857243sullener
svelte9319753svel_te
sweeney13387003swe_eney
sweeny12358843swe_eny
sweven1235983sweven_
swevens1334613swevens
talent6323323_talent
teen45938203_te_en_
teener64717503_te_ener
teens56227483_te_ens
teeny85417883_te_eny
telae54323293_tel_ae
tele45040873_tel__e
teledu737303_teledu
telega736773_telega
telemen9310173_telemen
teles54536003_tele_s
teleses7313123_teleses
telex125214823_tele_x
telexed1536323_telexed
telexes1438353_telexes
telnet6518833_telnet
telome8311923_telome
tepee74724213_tepe_e
terete6319333_terete
terne56426153_te_rne
terpene92310863_terpene
terrene72411033_terrene
terylene1144153_terylene
tolane64316583_tolane
toluene736463_toluene
triene64316383_triene
ukelele1142993ukelele
uterine7315193uterine
venene92912523_venene
xylene1645793_xylene

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.406440125.6
2DLD Change Limit1340272376.73619897.1
3Display Results2372370.0763118.4
 (SQL Overall)1786912377.21824756.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.