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

392 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
streams9471337(None) 
screams114810621screams
steams84916901st_eams
streaks114411271streaks
stream84717291stream_
streamy12509481streamy
breams104815042_breams
creams104715252_creams
dreams94513982_dreams
estreats839422estreats
reams75729622__reams
scrams105216622scr_ams
screaks13469362screaks
scream104814252scream_
seams75731662s__eams
spreads1039762spreads
steads74116222st_eads
steaks104415852st_eaks
steals64020062st_eals
steam76322932st_eam_
steamy115112372st_eamy
stems75219952st_e_ms
straps87721782str_aps
strass67117222str_ass
straws98718672str_aws
strays96417932str_ays
streak104613622strea_k
streaky14447812streaky
streamed11258902streamed
streamer10239512streamer
streamers11228072streamers
streeks11378712streeks
streels73811342streels
streets73312612streets
streps86218062stre_ps
stress66616672stre_ss
strews96817102stre_ws
strumas9419832strumas
strums84716452str_ums
teams75726512_t_eams
trams75327672_tr_ams
treads74817922_treads
treats64821692_treats
airstreams1252713airstreams
areas55935773_area_s
arrears738843arrears
ashrams1236653ashr_ams
astrals75515243astr_als
atriums939043atriums
beams95328173__beams
bitstreams1451973bitstreams
boreas85421733borea_s
breads95419203_breads
breaks124816423_breaks
bream95121813_bream_
bureaus979293bureaus
cereals9313173cereals
crams96229153_cr_ams
creaks124315963_creaks
cream95721353_cream_
creamy134811363_creamy
dirams94413703dir_ams
dirhams13376313dirhams
drams86025833_dr_ams
dreads84115023_dreads
dream85120393_dream_
dreamt94615713_dreamt
dreamy12509993_dreamy
drears74614253_drears
entreats839773entreats
esteems935243est_eems
estrays10529403estr_ays
estreat7314813estrea_t
estrums9208603estr_ums
ferbams1435743ferbams
firearms1335403firearms
fleams115011943_fleams
forams115115913for_ams
forearms1336603forearms
freaks134713063_freaks
gastreas957253gastrea_s
gleams94812253_gleams
grams85327313_gr_ams
greats76318393_greats
hareems12428203hareems
harems115513823hare_ms
ihrams1137173ihr_ams
inseams9307903inseams
intreats8311543intreats
items7499613it_e_ms
jetstreams1951533jetstreams
jorams154810533jor_ams
marrams11310123marrams
midstreams1542573midstreams
mistreats1148633mistreats
onstream1045113onstream_
oreads73915773_oreads
outbeams1236063outbeams
outdreams1243553outdreams
outreads9289003outreads
phreaks1634543phreaks
praams10459643_praams
prams96125513_pr_ams
preamp1238993_preamp
preamps1336613_preamps
prearms11369173_prearms
rams65950773__r_ams
reads64835273__reads
realms84913493__realms
reals55038653__reals
ream65841613__ream_
reaps75626193__reaps
rearms85114653__rearms
rears54739653__rears
redreams1195953redreams
rems66237723__re_ms
rereads81512293rereads
reteams9339563reteams
retreads937823retreads
retreats8311413retreats
roams74919613__roams
salaams997703salaams
sarans64224433sar_ans
sarcasm1136693sarcasm
sarcasms1244983sarcasms
sardars83112903sardars
sarees65329943sare_es
sarsars73512143sarsars
satraps95011643satr_aps
scams94423973s__cams
schemas1468163schemas
scrags95713803scr_ags
scram910621623scr_am_
scraps106017243scr_aps
screak125311063screa_k
screaky16436223screaky
screamed13277603screamed
screamer12267883screamer
screamers13236263screamers
screeds106210293screeds
screens95212183screens
screes85023973scre_es
screws115513893scre_ws
scrims104615933scr_ims
scrums104614253scr_ums
seals54839693s__eals
seam66645973s__eam_
seamy105921273s__eamy
sears54744913s__ears
seas45755273s__ea_s
seats54844343s__eats
seems75525023s__eems
seracs84418573ser_acs
serais64326133ser_ais
serdabs1035323serdabs
sereins73716123sereins
serenes73222903serenes
seres55448893sere__s
serials73919743serials
seriemas1047193seriemas
serums83916303ser_ums
servals103410743servals
shams105829413s__hams
sheafs124912883s_heafs
sheals94420643s_heals
shears93820903s_hears
sheas86331793s_hea_s
shmears1277073shmears
shreds105613053shre_ds
shrews129313923shre_ws
sidearms1144093sidearms
sirdars8228213sirdars
sirees64624583sire_es
sirens65318153sire_ns
sires55945373sire__s
sirrahs10377303sirrahs
sirras63814863sirra_s
skeans104512913s_keans
skelms12368023s_kelms
slams74927903s__lams
smears84714433s_mears
sneaks104312493s_neaks
sneaps84510863s_neaps
soras55041013sor_a_s
sorels63921163sore_ls
sores55454283sore__s
spams94922193s__pams
speaks125114583s_peaks
speans85417143s_peans
spears84019473s_pears
sperms102512603s_perms
spireas94412513spirea_s
spirems11499563spire_ms
sprags95715823spr_ags
sprats85819933spr_ats
sprays115913643spr_ays
spread9312533sprea_d
sprees85620643spre_es
squeaks2034523squeaks
squeals1636513squeals
stabs76221383st__abs
stags66226743st__ags
stalags838643stalags
stamp95217363st__amp
stamps105614023st__amps
stardoms1136793stardoms
starers74522313stare_rs
stares66038753stare__s
starets73515923stare_ts
stars55836573st__ars
stats55933363st__ats
stays86022023st__ays
stead65520273st_ea_d
steady103510203st_eady
steak95219803st_ea_k
steal56125473st_ea_l
steamed103712143st_eamed
steamer93313093st_eamer
steamers103410873st_eamers
steeds73814883st_eeds
steeks103613703st_eeks
steels64117983st_eels
steeps85215193st_eeps
steers63820983st_eers
steeves103410903steeves
steins64818343st_eins
steles63725663st_eles
stem610628253st_e_m_
stemma10328133st_emma
stemmas11256973st_emmas
stemmy13417033st_emmy
stenos63915773st_enos
stents65019453st_ents
steps76619883st_e_ps
stereos74314973stereos
steres63929533st_eres
sterns64616763st_erns
sternums1045783sternums
sterols7313443sterols
stets55423913st_e_ts
stews85519143st_e_ws
sties55132983stie__s
stigmas10206643stigmas
stoas55126023st_oa_s
stoats65117483st_oats
stomas84816323stoma_s
storers75018683store_rs
stores65533663store__s
storeys10559653store_ys
storms85814633st_orms
strafe95215983str_afe
strafes104516003strafes
strain64919573str_ain
strains74218153strains
strait64025893str_ait
straits74916323straits
strake104017393str_ake
strakes114218073strakes
stramash1344573str_amash
strand74514823str_and
strands83711953strands
strang75718313str_ang
strap77925263str_a_p
strata63616283str_ata
stratas73013583stratas
strath93216373str_ath
straths102711723straths
strati63518903str_ati
stratums10266803stratums
stratus73011733stratus
straw813321293str_a_w
strawy1210312823str_awy
stray88525573str_a_y
streaked13228453streaked
streaker12229483streaker
streakers13218133streakers
streambed1483333streambed
streambeds1541633streambeds
streamier1155763streamier
streamiest1245123streamiest
streaming12239653streaming
streamings13185163streamings
streamlet1146043streamlet
streamlets1243073streamlets
streamside1352103streamside
streek104111413stre_ek
streel64214023stre_el
street64125773stre_et
strep77120853stre__p
stresses81112493stresses
stretch1236413stretch
stretta737293stretta
strettas846423strettas
strette7310763strette
stretti747913stretti
stretto737733stretto
strettos847113strettos
strew89220663stre__w
strewed115811343strewed
strewer104310413strewer
strewers11409063strewers
strewn96710013stre_wn
stria55723213stria__
striae65422273stria_e
striata7379953striata
striate74218953striate
striates83417083striates
stricks134310693stricks
strides84520393strides
strifes104716583strifes
strikes114719093strikes
strings84617133strings
stripes95320573stripes
strips85719653str_ips
strives104119373strives
strobes93813263strobes
strokes114316323strokes
strolls739183strolls
stroma84313073str_oma
stromal93010593stromal
strops86220383str_ops
strouds837803strouds
strows96718273str_ows
stroys95914603str_oys
strum75619453str_um_
struma84313273str_uma
strumae9368093strumae
strunts7429543strunts
struts65616803str_uts
stums75320083st__ums
stupas83910883stupa_s
styes86316523stye__s
styrenes11116623styrenes
sunbeams1243963sunbeams
surahs94515543sur_ahs
suras55336333sur_a_s
surname937603surname
surnames1037273surnames
surpass938283surpass
surras65919533surra_s
sutras64818593sutr_a_s
swears94114073s_wears
sweats94814613s_weats
syrens94911993syre_ns
tams67247933_t__ams
teaks94222903_t_eaks
teals56234133_t_eals
team66238653_t_eam_
tears55436463_t_ears
teas45851493_t_ea_s
teats55636813_t_eats
teems76019783_t_eems
terais64023513_terais
terms75523473_t_erms
therms115914873_therms
threads11419953threads
threaps12488643threaps
threats104311673threats
toeas55726423_toea_s
tram67034553_tr_am_
tramp96319773_tr_amp
tramps105114453_tr_amps
trans54933043_tr_ans
traps75727483_tr_aps
trass56226473_tr_ass
trays85623433_tr_ays
tread64821703_trea_d
treat56240353_trea_t
treaty94414353_treaty
treens65317873_treens
trees55835763_tre_es
treks96016853_tre_ks
trends75513543_trends
trepans92311593_trepans
tres46542903_tre__s
tress55423163_tre_ss
trets55928023_tre_ts
trews86118893_tre_ws
treys85018213_tre_ys
triacs83913223_triacs
triads74513533_triads
trials64319883_trials
trims75021473_tr_ims
troaks104410603_troaks
tweaks1335963_tweaks
unseams9338913unseams
untreads936223untreads
uprears9107493uprears
upstream1243553upstream_
ureas55826013_urea_s
wreaks134711113_wreaks
zirams17438643zir_ams

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.403443402.0
2DLD Change Limit1340273927.25018486.5
3Display Results3923920.1432741.3
 (SQL Overall)1786913927.79622920.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.