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

542 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
streets7331261(None) 
streeks11378711streeks
streels73811341streels
street64125771street_
afreets1037012afreets
bystreets1442312bystreets
estreats839422estreats
greets75117422_greets
sarees65329942saree_s
screeds106210292screeds
screens95212182screens
screes85023972scree_s
sheets93918502s_heets
sirees64624582siree_s
skeets104513252s_keets
sleets64318872s_leets
sorbets93012512sorbets
sprees85620642spree_s
starets73515922starets
starlets81610082starlets
steeds73814882st_eeds
steeks103613702st_eeks
steels64117982st_eels
steeps85215192st_eeps
steers63820982st_eers
stents65019452st_ents
stereos74314972stereos
steres63929532stere_s
sterlets8169272sterlets
stets55423912st__ets
straits74916322straits
streaks114411272streaks
streams94713372streams
streek104111412stree_k
streel64214022stree_l
streps86218062str_eps
stress66616672str_ess
stretta737292stretta
strettas846422strettas
strette7310762strette
stretti747912stretti
stretto737732stretto
strettos847112strettos
strewers11409062strewers
strews96817102str_ews
strunts7429542strunts
struts65616802str_uts
stylets10369212stylets
sweets94214432s_weets
treats64821692_treats
treens65317872_treens
trees55835762_tree_s
trets55928022_tr_ets
trevets10499972_trevets
tweets94210102_tweets
afreet9315153afreet_
agrees74915323agree_s
amreeta945163amreeta
amreetas1044273amreetas
aretes64425353_aretes
armets84918353_armets
arrests73312683arrests
astricts1049463astricts
attests7278813attests
barbets114915843barbets
barrets94917103barrets
beets76131443__beets
berets85822523ber_ets
boreens9310403boreens
breeds94914883_breeds
breeks125310793_breeks
brees75632553_bree_s
brents84717273_brents
brevets12519393_brevets
burets84321263bur_ets
burnets93813263burnets
bystreet1345023bystreet_
careens94514703careens
careers95218783careers
carets85330773car_ets
carnets93918403carnets
carpets113915333carpets
cermets1139713cermets
cornets94820573cornets
corsets94819803corsets
corvets124715023corvets
creeds94714773_creeds
creeks124812923_creeks
creels84416943_creels
creeps104213623_creeps
crests85218703_crests
cruets85314953_cruets
curets84922343cur_ets
curvets12399913curvets
deets65330243__deets
directs102710263directs
drees65628523_dree_s
egrets72712243egr_ets
entreats839773entreats
entrees71813773entree_s
entremets1147143entremets
erects84116183_erects
esteems935243est_eems
esthetes1147743esthetes
estreat7314813estreat_
etwees9348793etwee_s
ferrets103111393ferrets
fleets96915063_fleets
forests104114953forests
forgets113813793forgets
freers94717303_freers
frees86131393_free_s
freest95318283_freest
frets85523403_fr_ets
gargets94614573gargets
garnets84115403garnets
garrets84413623garrets
gerents82612923gerents
gleets75315053_gleets
gorgets94711783gorgets
greats76318393_greats
greeds84314283_greeds
greens75716873_greens
grees65132473_gree_s
greet65835323_greet_
gurnets84010793gurnets
hareems12428203hareems
hirees95117293hiree_s
hornets104113553hornets
intreats8311543intreats
jereeds15326393jereeds
keets95123483__keets
kreeps12427413_kreeps
larees65323113laree_s
leets54927123__leets
markets133314033markets
meets74224613__meets
mistreats1148633mistreats
moreens939963moreens
parents93418123parents
pargets105215193pargets
preens85020113_preens
prees75937173_pree_s
presets94216423_presets
prests84021263_prests
purees84721683puree_s
reeds65430903__reeds
reefs85121663__reefs
reeks94124033__reeks
reels55333263__reels
rees45364193__ree_s
reest54938093__reest
reests64618893__reests
regreets9287853regreets
relets64025673__relets
remeets93712413remeets
rents55935183__rents
rerents73319423rerents
resets65427613__resets
rests54935873__rests
retreats8311413retreats
rets45352563__r_ets
revets94022173__revets
rewets94617213__rewets
sachets123914103sachets
sallets73719653sallets
samlets93813553samlets
sarcenets1146953sarcenets
saree55044663saree__
sarges75128593sarge_s
sarments10311963sarments
sarsenets946513sarsenets
sarsens7311393sarsens
sarsnets836783sarsnets
sateens73710753sateens
satinets8311733satinets
scarlets10178573scarlets
scents85317023s_cents
screaks13469363screaks
screams114810623screams
scree720031713scree__
screech1435223screech
screed95718933scree_d
screen85216023scree_n
screwers13358063screwers
screws115513893scr_ews
scries85226823scrie_s
scripts11509373scripts
seats54844343s__eats
secretes10410473secretes
secrets9311773secrets
sects75622893s__ects
seeds64330063s__eeds
seeks94724643s__eeks
seels55632823s__eels
seems75525023s__eems
seeps74828753s__eeps
seeress7311573seeress
seers55136383s__eers
sees45361053s__ee_s
selects91912143selects
sennets73712583sennets
septets998953septets
septs75420603s__epts
sereins73716123sereins
serenes73222903serenes
serenest82717623serenest
seres55448893ser_e_s
serest64831613serest_
sergers83815633sergers
serges74225973serge_s
series64540973serie_s
serpents102410373serpents
servers103214833servers
serves94423653serve_s
sestets7911473sestets
sets45549503s___ets
settees73513633settee_s
setts55124323s__etts
sextets1497143sextets
sexts125118383s__exts
sheens95116993s_heens
sheers94322403s_heers
sheet84836963s_heet_
sherbets1335213sherbets
shereefs1433863shereefs
shreds105613053shr_eds
shrews129313923shr_ews
shrieks14377673shrieks
shrifts1335963shrifts
signets83311503signets
silents73514493silents
sippets113310183sippets
siree55238813siree__
sirens65318153sir_ens
sires55945373sir_e_s
sirrees73410573sirrees
skeens103912913s_keens
skees95023123s_kee_s
skeet95429183s_keet_
skirrets12244013skirrets
sklents11348163sklents
skreegh15182643skreegh
skreeghs16212103skreeghs
sleeks104512463s_leeks
sleeps83913323s_leeps
sleet55639133s_leet_
sleety94112653s_leety
smeeks12428433s_meeks
smelts85412773s_melts
sneers64016173s_neers
sockets134012983sockets
soirees72411643soiree_s
solerets839693solerets
sonnets74211993sonnets
sorbents10279133sorbents
sorbet83924083sorbet_
sorels63921163sor_els
soreness8914793soreness
sores55454283sor_e_s
sorest65028003sorest_
sorites73825243sorites
sorners73416873sorners
sorrels7310723sorrels
sorters74221133sorters
sorts54536663sor__ts
soviets1087293soviets
speeds94316053s_peeds
speels85116393s_peels
speers85019953s_peers
spelts84614643s_pelts
spinets94714813spinets
spleens937103spleens
splents93912133splents
sprats85819933spr_ats
spreads1039763spreads
spree74830863spree__
sprent84522383sprent_
spriest92718653spriest
sprints94113773sprints
sprites94220333sprites
sprits85122533spr_its
sprouts949983sprouts
sprues84515763sprue_s
spryest12247813spryest
stactes91914633stactes
stades74626243stade_s
stagers84116673stagers
stages75629493stage_s
stakes103927293stake_s
stales65538293stale_s
stalest73720173stalest
stamens93411483stamens
stanes64933403stane_s
stapes85028733stape_s
starers74522313starers
stares66038753stare_s
starkers123712393starkers
starkest1239723starkest
starless81610843starless
starlet71620123starlet_
starters83714773starters
starts65423123st_arts
starvers11459643starvers
starves104614553starve_s
stases64225563stase_s
staters73922343staters
states64337083state_s
stats55933363st__ats
staves94525193stave_s
stayers103813633stayers
steads74116223st_eads
steaks104415853st_eaks
steals64020063st_eals
steams84916903st_eams
steed66024943st_ee_d
steek95418003st_ee_k
steel55721993st_ee_l
steely93612573st_eely
steep76020703st_ee_p
steepens10277113steepens
steepers103011373steepers
steepest1038123steepest
steer55423863st_ee_r
steerers82511353steerers
steeve93710903st_eeve
steeves103410903steeves
steins64818343st_eins
steles63725663st_eles
stems75219953st__ems
stenos63915773st_enos
stent55634513st_ent_
steps76619883st__eps
stere55328543stere__
stereo65317913stere_o
sterlet71318473sterlet_
sternest8314433sternest
sterns64616763st_erns
sterols7313443sterols
stet45947323st__et_
stews85519143st__ews
sties55132983st_ie_s
stiles64328773stile_s
stilts67915313st_ilts
stimes85920573stime_s
stints65119763st_ints
stipels9418953stipels
stipes84524053stipe_s
stirpes95011293stirpe_s
stirrers8266943stirrers
stivers103613543stivers
stoats65117483st_oats
stogeys11486123stogeys
stokers114515183stokers
stokes104821793stoke_s
stoles63927673stole_s
stoners74817953stoners
stones65130033stone_s
stopers94217373stopers
stopes84525893stope_s
storers75018683storers
stores65533663store_s
storeys10559653storeys
stories7324273storie_s
stots54828553st__ots
stotts64612863st_otts
stouts65019003st_outs
stovers103713733stovers
stoves93818923stove_s
strafers11379913strafers
strafes104516003strafes
strains74218153strains
strait64025893strait_
strakes114218073strakes
strands83711953strands
straps87721783str_aps
strass67117223str_ass
strata63616283str_ata
stratas73013583stratas
strath93216373str_ath
straths102711723straths
strati63518903str_ati
stratus73011733stratus
straws98718673str_aws
strayers113510143strayers
strays96417933str_ays
streak104613623str_eak
streakers13218133streakers
streaky14447813streaky
stream84717293str_eam
streamers11228073streamers
streamlets1243073streamlets
streamy12509483streamy
streeked13246153streeked
streeker12206643streeker
streekers13195803streekers
streeled9267873streeled
streetcar1152463streetcar
streetcars1252213streetcars
streetwise1352483streetwise
strength1244433strength
strengths1343553strengths
strep77120853str_e_p
stresses81112493stresses
stretch1236413stretch
streusels942933streusels
strew89220663str_e_w
strewed115811343strewed
strewer104310413strewer
strewments1544183strewments
strewn96710013str_ewn
striata7379953striata
striate74218953striate
striates83417083striates
stricks134310693stricks
strict84821043strict_
striders94412123striders
strides84520393strides
strifes104716583strifes
strikers123611293strikers
strikes114719093strikes
strings84617133strings
stripers103911593stripers
stripes95320573stripes
strips85719653str_ips
stript85222193stript_
strivers113911843strivers
strives104119373strives
strobes93813263strobes
strokers123910903strokers
strokes114316323strokes
strolls739183strolls
strops86220383str_ops
strouds837803strouds
strows96718273str_ows
stroyers11388923stroyers
stroys95914603str_oys
strudels934123strudels
strumas9419833strumas
strumpets1362893strumpets
strums84716453str_ums
strunt64918913strunt_
strut56030733str_ut_
students954683students
stunts65615253st_unts
stupes84116953stupe_s
sturts63915143st_urts
styes86316523st_ye_s
stylers10359353stylers
styles94418653style_s
stylet94018573stylet_
styrenes11116623styrenes
sublets92616703sublets
subnets92512083subnets
subrents10310293subrents
subsets92813103subsets
suets55126103s__uets
sunkets113511283sunkets
sunsets72911573sunsets
sureness8912903sureness
surest65026763surest_
surety93515013sur_ety
surfeits1146223surfeits
surfers103614133surfers
surgers83517483surgers
surges73924593surge_s
surreys10489443surreys
surveys13357573surveys
suttees74114063suttee_s
sweats94814613s_weats
sweeps114110513s_weeps
sweet85330523s_weet_
swivets13436963swivets
sycees11409653sycee_s
syndets1136113syndets
syrens94911993syr_ens
syrette1037183syrette
syrettes1136963syrettes
targets84314223targets
teats55636813_t_eats
teels55726373_t_eels
teems76019783_t_eems
teens56227483_t_eens
tees45353583_t_ee_s
teeth87315853_t_eeth
tenets65518953_tenets
tents56434213_t_ents
tercets93512443tercets
terete6319333_terete
terrets72913583terrets
tests56530193_t_ests
tets45847463_t__ets
texts125515043_t_exts
thefts12387923_thefts
threats104311673threats
threeps12687043threeps
threes97117323three_s
tracts85019073_tracts
traits65121983_traits
treads74817923_treads
treat56240353_treat_
treaty94414353_treaty
tree47745813_tree__
treed65626733_tree_d
treen55622753_tree_n
treetop945523_treetop
treetops1045463_treetops
treks96016853_tr_eks
trends75513543_trends
tres46542903_tr_e_s
tress55423163_tr_ess
tret46653533_tr_et_
trevet94818913_trevet_
trews86118893_tr_ews
treys85018213_tr_eys
triens65417543_triens
triers64321523_triers
tries55742813_trie_s
trijets14308263_trijets
trivets103911583_trivets
trots56629943_tr_ots
trouts66116633_trouts
trues54925323_true_s
truest64816193_truest
trusts64714433_trusts
trysts9448793_trysts
tureens7289873tureens
turrets73010673turrets
tweeds10498433_tweeds
tweens9489843_tweens
tweet84823983_tweet_
tyees86019453_tyee_s
unreels7258313unreels
unrests7229463unrests
urtexts1433143urtexts
varlets10411573varlets
versets103913103versets
vervets13419753vervets
weets85427723__weets
worsets105512843worsets
wrests95313083_wrests
yestreens1243533yestreens

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.390458182.1
2DLD Change Limit1340275426.78019768.0
3Display Results5425420.1862914.0
 (SQL Overall)1786915427.35624291.9
 
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.