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

210 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
streamer1023951(None) 
screamer12267881screamer
steamer93313091st_eamer
streaker12229481streaker
streamed11258901streamed
streamers11228071streamers
streamier1155761streamier
creamer113714092_creamer
dreamer104110842_dreamer
reamer84325212__reamer
screamed13277602screamed
screamers13236262screamers
seamer84223612s__eamer
spreader1137482spreader
stealer72913972st_ealer
steamed103712142st_eamed
steamers103410872st_eamers
steamier1048302st_eamier
stemmer113210182st_emmer
strafer103912462str_afer
strayer104312502str_ayer
streaked13228452streaked
streakers13218132streakers
streakier1334842streakier
stream84717292stream__
streambed1483332streambed
streamlet1146042streamlet
streams94713372stream_s
streamy12509482stream_y
streeker12206642streeker
strewer104310412stre_wer
strummer1234782strummer
surnamer1044882surnamer
treader84113832_treader
treater74219832_treater
bereaver1346673bereaver
breaker133912923_breaker
breamed124011593_breamed
creamed123913713_creamed
creamers124111313_creamers
creamery15385983_creamery
creamier12319063_creamier
creaser94415743_creaser
dreamed114310633_dreamed
dreamers11369003_dreamers
dreamier11287293_dreamier
estreated1039553estreated
extremer1744653extre_mer
framer114817443_fr_amer
gleamer10328513_gleamer
greaser83913083_greaser
greater84416493_greater
phreaker1735053phreaker
preaver121011613_preaver
reader73628293__reader
realer63528593__realer
reamed94326123__reamed
reamers94221083__reamers
reaper84223143__reaper
rearer64928913__rearer
reaver94524733__reaver
retreater9310203retreater
roamer84715163__roamer
schemer1477963sche_mer
scraper114513423scr_aper
screaked15246983screaked
scream104814253scream__
screams114810623scream_s
screener1037573screener
screwer124410073scre_wer
screwier1346433screwier
sealer63928963s__ealer
seamed94823883s__eamed
seamen84518563s__eamen
seamers94719433s__eamers
seamier93114633s__eamier
searer65432023s__earer
seater64534163s__eater
seemer84418043s__eemer
serenader10216003serenader
serener73415763sere_ner
shearer104414683s_hearer
shredder1334403shredder
shrewder1534403shrewder
smearer94110403s_mearer
sneaker112910453s_neaker
speaker133311213s_peaker
spearer93913663s_pearer
sprayer12369043spr_ayer
spreaders1236503spreaders
squeaker2184883squeaker
squealer17115603squealer
stager74821343st__ager
staler64025823st__aler
stamen84115943st__amen
stammer116013343st_ammer
stamper113714403st__amper
starer64027363st__arer
stargazer1942593stargazer
stater64427563st__ater
stayer94516483st__ayer
steaded92811673st_eaded
steadier937313st_eadier
stealers83412203st_ealers
steam76322933st_eam__
steamered1244913st_eamered
steams84916903st_eam_s
steamy115112373st_eam_y
steelier839183steelier
steeper93812773st_eeper
steer55423863st_e__er
steerer73113633st_eerer
stemmed12278153st_emmed
stemmers12378443st_emmers
stemmery15334693st_emmery
stemmier1245253st_emmier
stepper113010853st_epper
sterner7411913st_erner
strafe95215983str_afe_
strafed114413333str_afed
strafers11379913str_afers
strafes104516003str_afes
strainer8512223strainer
straiter8311783straiter
strake104017393str_ake_
straked125415343str_aked
strakes114218073str_akes
strander97112063strander
stranger94715103stranger
strapper1258093strapper
strawed114813613str_awed
strawier1137493strawier
strayed114513283str_ayed
strayers113510143str_ayers
streak104613623strea__k
streaks114411273strea_ks
streaky14447813strea_ky
streambeds1541633streambeds
streamiest1245113streamiest
streaming12239653streaming
streamlets1243073streamlets
streamliner1352173streamliner
streek104111413stre__ek
streeked13246153streeked
streekers13195803streekers
streel64214023stre__el
streeled9267863streeled
street64125773stre__et
stressed9128543stressed
stresses81112493stresses
stressor875543stressor
stretcher1446293stretcher
strette7310763strette_
streusel843933streusel
strewed115811343stre_wed
strewers11409063stre_wers
strewment1445683strewment
striae65422273stria_e_
striate74218953striate_
striated93414153striated
striates83417083striates
stricter1039423stricter
strider84315723str_ider
striker113714173str_iker
stringer93812943stringer
striper94514793str_iper
stripier1058863stripier
stripper1247123stripper
striver104315203str_iver
stroker114113523str_oker
stroller848173stroller
stronger9349693stronger
stropper1247763stropper
stroyer103510783str_oyer
strumae9368093strumae_
strummed1344473strummed
strummers1333693strummers
strutter846503strutter
supremer1246483supre_mer
surfacer1345663surfacer
surname937603surname_
surnamed1135113surnamed
surnamers1143803surnamers
surnames1037273surnames
swearer10349953s_wearer
sweater103712723s_weater
tamer75230103_t__amer
teamed95418593_t_eamed
tearer64822903_t_earer
teaser65421523_t_easer
teemer85515743_t_eemer
termer85717253_t_ermer
tetramer1046813tetr_amer
theater104014253_theater
threader1256733threader
threaper1345143threaper
tracer84820233_tr_acer
trader75218763_tr_ader
tramel84113713_tr_amel
tramper113812163_tr_amper
treaded95014283_treaded
treaders93311843_treaders
treadler936863_treadler
treated83618703_treated
treaters83615843_treaters
trekker1034733_trekker
tremor84210403_tre_mor
trimer85717153_tr_imer
trimmer113610833_trimmer
wreaker143610043_wreaker

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.420425454.8
2DLD Change Limit1461622107.69019006.8
3Display Results2102100.0762763.2
 (SQL Overall)1786912108.18621828.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.