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

156 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
streamers1122807(None) 
screamers13236261screamers
steamers103410871st_eamers
streakers13218131streakers
streamer10239511streamer_
creamers124111312_creamers
dreamers11369002_dreamers
reamers94221082__reamers
screamer12267882screamer_
seamers94719432s__eamers
spreaders1236502spreaders
stealers83412202st_ealers
steamer93313092st_eamer_
stemmers12378442st_emmers
strafers11379912str_afers
strayers113510142str_ayers
streaker12229482streaker_
streambeds1541632streambeds
streamed11258902streame_d
streamier1155762streamier_
streamlets1243072streamlets
streams94713372stream__s
streekers13195802streekers
strewers11409062stre_wers
strummers1333692strummers
surnamers1143802surnamers
treaders93311842_treaders
treaters83615842_treaters
bereavers1446123bereavers
breakers143810973_breakers
creamer113714093_creamer_
creamery15385983_creamery
creasers103612833_creasers
dreamer104110843_dreamer_
framers125113823_fr_amers
gleamers11306563_gleamers
greasers93410253_greasers
phreakers1834673phreakers
preavers13910263_preavers
readers83823773__readers
reamer84325213__reamer_
reapers93520453__reapers
rearers74323563__rearers
reavers108320743__reavers
retreaters1047543retreaters
roamers93713463__roamers
schemers1576713sche_mers
scrapers125510533scr_apers
screamed13277603screame_d
screams114810623scream__s
screeners1136733screeners
screwers13358063scre_wers
sealers74323553s__ealers
seamer84223613s__eamer_
seaters74028943s__eaters
seemers93814333s__eemers
serenaders11204663serenaders
shearers113911323s_hearers
shredders1463713shredders
smearers10308623s_mearers
sneakers12308643s_neakers
speakers14299453s_peakers
spearers103711143s_pearers
sprayers13367053spr_ayers
spreader1137483spreader_
squeakers2284113squeakers
squealers1894453squealers
stagers84116673st__agers
stamens93411483st__amens
stammers123611523st_ammers
stampers124211603st__ampers
starers74522313st__arers
stargazers2041803stargazers
staters73922343st__aters
stayers103813633st__ayers
steadiers1035083st_eadiers
stealer72913973st_ealer_
steamed103712143st_eame_d
steamered1244913st_eamered
steamier1048303st_eamier_
steams84916903st_eam__s
steepers103011373st_eepers
steerers82511353st_eerers
steers63820983st_e__ers
stemmer113210183st_emmer_
stemmery15334693st_emmery
steppers12289283st_eppers
strafer103912463str_afer_
strafes104516003str_afe_s
strainers9510383strainers
strakes114218073str_ake_s
stranders10389933stranders
strangers104112163strangers
strappers1346743strappers
strayer104312503str_ayer_
streaked13228453streake_d
streakier1334843streakier_
streaks114411273strea__ks
stream84717293stream___
streambed1483333streambed
streamiest1245113streamiest
streaming12239653streaming
streamings13185163streamings
streamlet1146043streamlet
streamliners1451623streamliners
streamy12509483stream__y
streeker12206643streeker_
streeks11378713stre__eks
streels73811343stre__els
streets73312613stre__ets
stresses81112493stresse_s
stressors955793stressors
stretchers1545173stretchers
streusels942933streusels
strewer104310413stre_wer_
strewment1445683strewment
strewments1544183strewments
striates83417083striate_s
striders94412123str_iders
strikers123611293str_ikers
stringers104210643stringers
stripers103911593str_ipers
strippers1355773strippers
strivers113911843str_ivers
strokers123910903str_okers
strollers937543strollers
stroppers1356713stroppers
stroyers11388923str_oyers
strummer1234783strummer_
strutters955693strutters
surfacers1444323surfacers
surnamer1044883surnamer_
surnames1037273surname_s
swearers11328583s_wearers
sweaters113811063s_weaters
tamers84224033_t__amers
tearers75218233_t_earers
teasers75317243_t_easers
teemers95012903_t_eemers
termers95414503_t_ermers
tetramers1146463tetr_amers
theaters114211903_theaters
threaders1365743threaders
threapers1444773threapers
tracers94917843_tr_acers
traders84316953_tr_aders
tramels93812493_tr_amels
trampers123210393_tr_ampers
treader84113833_treader_
treadlers1045893_treadlers
treater74219833_treater_
trekkers1133803_trekkers
tremors93711233_tre_mors
trimers94615143_tr_imers
trimmers12288913_trimmers
wreakers15328423_wreakers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411566.36023371.2
3Display Results1561560.0632476.2
 (SQL Overall)1786911566.84626101.5
 
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.