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

243 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
streamed1125890(None) 
screamed13277591screamed
steamed103712141st_eamed
streaked13228451streaked
streambed1483331streambed
streamer10239501streamer
breamed124011592_breamed
creamed123913712_creamed
dreamed114310632_dreamed
estreated1039552estreated
reamed94326122__reamed
screaked15246972screaked
screamer12267872screamer
seamed94823882s__eamed
steaded92811672st_eaded
steamer93313092st_eamer
stemmed12278152st_emmed
strafed114413332str_afed
straked125415342str_aked
strawed114813612str_awed
strayed114513282str_ayed
streaker12229472streaker
stream84717282stream__
streambeds1541632streambeds
streamers11228062streamers
streamier1155762streamier
streamlet1146042streamlet
streams94713372stream_s
streamy12509482stream_y
streeked13246152streeked
streeled9267862streeled
stressed9128542stressed
strewed115811332stre_wed
striated93414152striated
strummed1344472strummed
surnamed1135112surnamed
teamed95418592_t_eamed
treaded95014282_treaded
treated83618702_treated
beamed115720733__beamed
bereaved1446403bereaved
breaded115014063_breaded
creaked143413233_creaked
creamer113714083_creamer
creased104315583_creased
created104323443_created
dreaded103612023_dreaded
dreamer104110843_dreamer
entreated10310973entreated
esteemed1144473est_eemed
estrayed1236393estr_ayed
firearmed1544043firearmed
forearmed1544863forearmed
forenamed1545163forenamed
framed125116523_fr_amed
freaked15399703_freaked
gleamed11327933_gleamed
greased93812393_greased
greaved12408913_greaved
intreated10312663intreated
itemed936603it_e_med
iterated91213823iterated
mistreated1348423mistreated
outbeamed1445363outbeamed
outdreamed1443383outdreamed
phreaked1834493phreaked
preaged11612333_preaged
prearmed1397993_prearmed
premed114617753_pre_med
reamer84325213__reamer
reaped94122453__reaped
reared75930013__reared
rearmed103912823__rearmed
reaved104523923__reaved
redreamed1345023redreamed
renamed103114523__renamed
reteamed1138013reteamed
retreaded1137053retreaded
retreated10312623retreated
roamed95215093__roamed
salaamed1134623salaamed
schemed1577753sche_med
scrammed1555003scrammed
scraped124313133scr_aped
scream104814243scream__
screamers13236253screamers
screams114810613scream_s
screed95718923scre__ed
screeded1235633screeded
screened1137403screened
screwed135710653scre_wed
scrummed1554313scrummed
seabed95017693s__eabed
sealed74328363s__ealed
seamen84518563s__eamen
seamer84223613s__eamer
seared75232843s__eared
seated75131053s__eated
seemed95117613s__eemed
serenaded11215933serenaded
seriated92717023seriated
serrated92513433serrated
shamed125120213s__hamed
sheafed14388973s_heafed
sheared114516003s_heared
sheaved143411633s_heaved
shredded1444063shredded
shrewed14589843shre_wed
sleaved113611133s_leaved
smeared104510623s_meared
sneaked12329693s_neaked
sneaped10338813s_neaped
speaned103411523s_peaned
speared104314423s_peared
sprayed13398903spr_ayed
spread9312533sprea__d
spreader1137473spreader
squeaked2283903squeaked
squealed1885353squealed
staged84521563st__aged
staked114621943st__aked
staled74728103st__aled
stamen84115943st__amen
stamped124812813st__amped
staned74824643st__aned
stared75429873st__ared
stargazed2043073stargazed
stated75427833st__ated
staved103918053st__aved
stayed104817273st__ayed
stead65520273st_ea__d
steadied1036563st_eadied
stealer72913973st_ealer
steam76322933st_eam__
steamered1244913st_eamered
steamers103410873st_eamers
steamier1048303st_eamier
steams84916903st_eam_s
steamy115112373st_eam_y
steed66024943st_e__ed
steeked124010473st_eeked
steeled83513213st_eeled
steeped103412283st_eeped
steepled1135893steepled
steered83615253st_eered
steeved113610133st_eeved
stemmer113210183st_emmer
stepped123210053st_epped
stereoed937883stereoed
stetted82610403st_etted
stewed104814243st_e_wed
storeyed1234643store_yed
stormed1039043st_ormed
strafe95215983str_afe_
strafer103912463str_afer
strafes104516003str_afes
strained9412253strained
strake104017393str_ake_
strakes114218073str_akes
strand74514823str_a_nd
stranded102710813stranded
strapped1357823strapped
stravaged1444193stravaged
strayer104312503str_ayer
streak104613623strea__k
streakers13218123streakers
streakier1334843streakier
streaks114411273strea_ks
streaky14447813strea_ky
streamiest1245113streamiest
streaming12239653streaming
streamlets1243073streamlets
streamlined1452253streamlined
streamside1352103streamside
streek104111413stre__ek
streeker12206633streeker
streel64214023stre__el
street64125773stre__et
stresses81112493stresses
stretched1546213stretched
strette7310763strette_
streusel843933streusel
strewer104310403stre_wer
strewment1445673strewment
striae65422273stria_e_
striate74218953striate_
striates83417083striates
stringed102911873stringed
striped105214363str_iped
stripped1357093stripped
strived114713663str_ived
stroked124613623str_oked
strolled937813strolled
stropped1367343stropped
strowed115312143str_owed
stroyed114110863str_oyed
strumae9368093strumae_
strummer1234783strummer
strunted957243strunted
strutted946343strutted
stummed12348553st_ummed
surbased1136613surbased
surceased1264843surceased
surfaced1436063surfaced
surname937603surname_
surnamer1044883surnamer
surnames1037273surnames
surtaxed1644133surtaxed
sweated113411543s_weated
tamed85528513_t__amed
teared75722153_t_eared
teased74721153_t_eased
teated74924023_t_eated
teemed95114873_t_eemed
termed94816703_t_ermed
themed125912583_the_med
threaded1366323threaded
threaped1454863threaped
threated1259203threated
traced94821583_tr_aced
traded85717683_tr_aded
tramel84113713_tr_amel
trammed123810713_trammed
tramped124312433_tr_amped
tread64821703_trea__d
treader84113833_treader
treadled1067123_treadled
treater74219833_treater
trebled1038483_trebled
treed65626733_tre__ed
trekked1134343_trekked
trended94011763_trended
tressed83714253_tressed
triaged92810443_triaged
trimmed12348933_trimmed
troaked12438253_troaked
tweaked1534403_tweaked
undreamed1336973undreamed
unseamed111210663unseamed
untreaded1137983untreaded
untreated10312903untreated
upreared1137073upreared
wreaked15369023_wreaked

Search took 9 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 Filter1786911461620.313570897.8
2DLD Change Limit1461622438.43617326.0
3Display Results2432430.1861306.5
 (SQL Overall)1786912438.93519999.0
 
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.