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

362 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
stelai6391256(None) 
stela54019041stela_
stelae63716481stelae
stelar64013861stelar
selah8319612s_elah
serai56830162s_erai
stalag7310022stalag
stead65520272ste_ad
steak95219802ste_ak
steal56125472ste_al
steals64020062steals
steam76322932ste_am
stele55026842stel_e
steles63725662steles
stelic8313082stelic
stella63612972stella
stellar72610432stellar
stellas72813042stellas
stoai55417872st_oai
stylar9358112stylar
styli83911172styl_i
tela45532972_tela_
telae54323292_telae
telia55821142_telia
teloi54217382_teloi
terai53525482_terai
abelia83114403abelia
akela9311343akela_
akelas10311193akelas
assegai843353assegai
asteria7316183asteria
astylar10265063astylar
atelic8313703atelic
atlas55821583at_las
belay105021523_belay
byelaw1444253byelaw
celli76717693_celli
chela103916803chela_
chelae113614603chelae
chelas113817203chelas
delay94820633_delay
deli55631293_del_i
duelli767003duelli
elain55324703__elain
elan46734243__elan
elhi7612403__elhi
gelati73814533_gelati
jetlag1434523jetlag
nielli636303nielli
obeli73711933obel_i
obelia8329453obelia
ocelli836843ocelli
osteal6312963oste_al
petsai838083petsai
prelaw1139103prelaw
relaid75518443_relaid
relax124817803_relax
relay84424673_relay
salad65321833s_alad
salal55425703s_alal
salami8313103s_alami
salmi7815863s_almi
scalar83612433scalar
scena74815783scena_
scenas84114703scenas
sea36161293s_e_a_
seal45654373s_e_al
seals54839693s_eals
seam66645973s_e_am
sear47353843s_e_ar
seas45755273s_e_as
seat47575563s_e_at
sedan65620423s_edan
seel45042983seel__
seeled73922093seeled
seels55632823seel_s
seely84522633seel_y
seesaw935973seesaw
segni63712483s_egni
sei36048933s_e__i
sel38253323s_el__
selahs9313213s_elahs
self75138293s_el_f
selfs85220243s_elfs
selkie102811693s_elkie
sell45840613s_el_l
selle54428313s_elle
sells55134433s_ells
sels46345983s_el_s
selva83014273s_elva
selvas93812913s_elvas
semi65127223s_e_mi
sengi64016513s_engi
senti56226703s_enti
sepal77723003s_epal
sepia75318673s_epia
sera46141393s_era_
serac75925203s_erac
serail64222673s_erail
serais64326133s_erais
seral56336383s_eral
seta45637313s_eta_
setae56026223s_etae
setal56430903s_etal
sewan85921293s_ewan
sewar85421103s_ewar
shea76031573she_a_
sheaf115424123she_af
sheal84927703she_al
sheals94420643sheals
shear85424833she_ar
sheas86331793she_as
sheila969843sheila_
sheilas1059403sheilas
shelf115221113shel_f
shell84424123shel_l
shellac1236693shellac
shells94319523shells
shelly124414473shelly
shelta93111793shelta
sheltas10279673sheltas
sheltie10109913sheltie
shelty124011553shelty
shelve124012763shelve
shelvy15377863shelvy
sigla64515203sigla_
sigloi737743sigloi
sileni63312143sileni
skean94415623ske_an
skell94915833skel_l
skells105013783skells
skelm114211293skel_m
skelms12368023skelms
skelp114211423skel_p
skelpit1344943skelpit
skelps12407923skelps
slab67133763s__lab
slag55934353s__lag
slain54923573s__lain
slam67737973s__lam
slap66434043s__lap
slat46959023s__lat
slaw77930713s__law
slay76436383s__lay
smalti84111193smalti
smear74416393sme_ar
smell74916233smel_l
smells83914743smells
smelly114110363smelly
smelt74726783smel_t
smelts85412773smelts
smilax1535393smilax
sneak96016173sne_ak
sneap75514823sne_ap
snell54517303snel_l
snells64614203snells
sola45541863s_ola_
solan55328153s_olan
solar55927343s_olar
soldi65717203s_oldi
solei55624343s_olei
soli46637013s_ol_i
speak114618673spe_ak
spean74620513spe_an
spear75821063spe_ar
spelean937123spelean
spell75020303spel_l
spells84617683spells
spelt75430193spel_t
spelts84614643spelts
speltz174010123speltz
splat76129343s_plat
splay105816043s_play
stab67329933st__ab
stadia7312143stadia
stag57332003st__ag
staid66722083st__aid
staig65519643st__aig
stain55727943st__ain
stair54719943st__air
stalags838643stalags
stale55637103stal_e
staled74728103staled
staler64025823staler
stales65538293stales
stalk94518003stal_k
stalks104614553stalks
stalky13499303stalky
stall54722353stal_l
stalls64019933stalls
stapelia1044673stapelia
star48037763st__ar
stat47352693st__at
statal61613223statal
staw78627693st__aw
stay78333723st__ay
steads74116223steads
steady103510203steady
steaks104415853steaks
stealage946583stealage
stealer72913983stealer
stealing93416603stealing
stealth1096453stealth
steams84916903steams
steamy115112373steamy
stearic939423stearic
stearin7312003stearin
steed66024943ste_ed
steeds73814883steeds
steek95418003ste_ek
steeks103613703steeks
steel55721993ste_el
steeled83513223steeled
steelie7310213steelie
steels64117983steels
steely93612573steely
steep76020703ste_ep
steeps85215193steeps
steer55423863ste_er
steers63820983steers
steeve93710903steeve
stein54620543ste_in
steins64818343steins
stelene7310253stelene
stellate8310503stellate
stellify1443883stellify
stellite839533stellite
stem610628253ste__m
stemma10328133stemma
stemmas11256973stemmas
stemmy13417033stemmy
stems75219953ste_ms
stench114111163stench
stencil946893stencil
stengah1144563stengah
steno54716863ste_no
stenos63915773stenos
stent55634513ste_nt
stents65019453stents
step67126293ste__p
steppe10319873steppe
steps76619883ste_ps
stere55328543ste_re
stereo65317913stereo
steres63929533steres
steric8317063steric
sterlet71318473sterlet
stern55319123ste_rn
sterna63712763sterna
sternal73411913sternal
sterns64616763sterns
steroid81314863steroid
sterol6613333sterol
stet45947323ste__t
stets55423913ste_ts
stew77525463ste__w
steward1138063steward
stewed104814243stewed
stewpan1234193stewpan
stews85519143ste_ws
stewy116112063ste_wy
stey76224413ste__y
sthenia1058503sthenia
stile54931573stil_e
stiles64328773stiles
still54922083stil_l
stills64118573stills
stilly93714093stilly
stilt54831983stil_t
stilts67915313stilts
stoa45425913st_oa_
stoae55024263st_oae
stoas55126023st_oas
stoat57135953st_oat
stole54928813stol_e
stoled74521593stoled
stolen64315063stolen
stoles63927673stoles
stolid74213183stolid
stolon64112073stolon
stoma75918273stoma_
stomal85213313stomal
stomas84816323stomas
storax1389783storax
strain64919573st_rain
strait64025893st_rait
strap77925263st_rap
strati63518903strati
straw813321293st_raw
stray88525573st_ray
streak104613623streak
stream84717293stream
stretti747913stretti
stria55723213stria_
striae65422273striae
stull54916273stul_l
stulls63912983stulls
stupa74112313stupa_
stupas83910883stupas
stylate10179773stylate
style85519363styl_e
styled105613103styled
styler94013303styler
styles94418653styles
stylet94018573stylet
styloid1137553styloid
stylus9397463stylus
styrax1675243styrax
sulci7615053s_ulci
svelte9319753svelte
swear85316853swe_ar
sweat85628403swe_at
swell84815983swel_l
swells93913983swells
syli74318983s_yl_i
syllabi1244983syllabi
tala45938053_tala_
talar56225383_talar
talas55935893_talas
tali46837163_tal_i
tea37353323_te_a_
teak85930843_te_ak
teal45546503_te_al
teals56234133_teals
team66238653_te_am
tear45242883_te_ar
teas45851493_te_as
teat45963633_te_at
tel35647903_tel__
telco7511873_telco
tele45040873_tel_e
teles54536003_teles
telex125214823_telex
telial65815363_telial
telic76019823_telic
tell44934703_tel_l
tells55828943_tells
telly84920823_telly
telos55424523_telos
tels46841693_tel_s
tempi94912203_tempi
tenail64516113_tenail
tenia55324483_tenia
tepa66021683_tepa_
tepal76319583_tepal
tepas76521683_tepas
terais64023513_terais
tesla55612603_tesla_
teslas64212173_teslas
tetri52716453_tetri
texas126514933_texas
tilak91011553_tilak
tola45236333_tola_
tolan55124013_tolan
tolar55524113_tolar
tolas54532773_tolas
tuladi765723_tuladi
tutelar735373tutelar
uteri51012983ute_ri
vela75725543_vela_
velar85817633_velar
virelai1045593virelai

Search took 7 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 Filter1786911127160.420425454.8
2DLD Change Limit1127163625.48620546.1
3Display Results3623620.1103290.9
 (SQL Overall)1786913626.01629702.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.