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

221 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
bestrew124800(None) 
beshrew1554391beshrew
bestrewn1343321bestrewn
bestrews1335601bestrews
bestrow1237241bestrow
bedstraw1443252bedstraw
beshrews1643162beshrews
bested94922752best_ed
bestow1149462best_ow
bestrewed1594162bestrewed
bestrid1039972bestrid
bestrown1345192bestrown
bestrows1337042bestrows
bistre83815022bistre_
bistred103311852bistred
bistres94017212bistres
kestrel1137112kestrel
strew89220652__strew
baste74829983bast_e_
basted95227233bast_ed
baster85333593bast_er
basters94930303basters
bastes85330383bast_es
bearer85323913be_arer
beastie92412433beastie_
beasties102514653beasties
beaten84617063beat_en
beater84729393beat_er
beaters94925033beaters
bedew114513033be__dew
bedsore1057803bedsore_
bedsores1157633bedsores
bedstraws1542403bedstraws
beetle8311673beetle_
beetled1038213beetled
beetler938033beetler
beetles9312083beetles
before11410153before_
befret11315963be_fret
belted94020633belt_ed
belter84720963belt_er
belters93819413belters
bemire103312803bemire_
bemired123410633bemired
bemires113212833bemires
beret74946363be__ret
berthed13259123berthed
bescreen1244303bescreen
beseem1069083bes_eem
beses75830723bes__es
beset76739133bes__et
besetter10137973besetter
beshrewed1882723beshrewed
beside95114613beside_
besides104814533besides
besnow1145713bes_now
besotted1135843besotted
bespread1344183bespread
besprent1248033besprent
best66355323best___
bestead10389113bestead
bestial9311643bestial
besting104923923besting
bestir8311163best_ir
bestirred1243803bestirred
bestirs9311133bestirs
bestowed14156613bestowed
bestower13126203bestower
bestows1248863bestows
bestrewing1643773bestrewing
bestride1138613bestride
bestrides1237913bestrides
bestrode1147133bestrode
bestrowed1585163bestrowed
bests75932613best__s
bestud9439303best_ud
bestuds10326753bestuds
betel74419903be_t_el
bethel1169643be_thel
betray111511443be_tray
betted94721163be_tted
better84723703be_tter
bettered113011833bettered
betters94422093betters
beware11313713beware_
bewared13310113bewared
bewares12313373bewares
bister84922763bist_er
bistered112913323bistered
bisters93922603bisters
bistro8339943bistr_o
bistros92810983bistros
brew95023563b___rew
busted95123153bust_ed
buster84726493bust_er
busters94724123busters
bustier93916153bustier
bustle84015483bustle_
bustled104011513bustled
bustler94012563bustler
bustles93816323bustles
bystreet1345023bystreet
centre84316643centre_
centred103411683centred
centres93817123centres
costrel9310363costrel
desire7415303desire_
desired9311983desired
desirer8310783desirer
desires81316133desires
destrier9311823destrier
destroy1138153destroy
entree61817883_entree
eschew1436333_eschew
escrow1135913_escrow
esteem838813_esteem
ester54727713_est_er
esters64627733_esters
estral64716513_estral
estray95713333_estray
estreat7314813_estreat
estrin6315923_estrin
estrum81810513_estrum
estrus61912113_estrus
fester94723513fest_er
festered122512103festered
festers104121393festers
gastrea847223gastrea
geste65920693gest_e_
gestes75721393gest_es
gesture839243gesture_
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
jested144416503jest_ed
jester134319153jest_er
jesters144118193jesters
kestrels1235813kestrels
lustre64011683lustre_
lustred8359053lustred
lustres73013233lustres
mestee84523883mest_ee
mestees94617753mestees
metre74821303me_tre_
metred95315143me_tred
metres85121563me_tres
misdrew1335833misdrew
misgrew1335523misgrew
misthrew16124763misthrew
nested74720063nest_ed
nester64124183nest_er
nesters74422783nesters
nestle63013953nestle_
nestled8349903nestled
nestler73510443nestler
nestles73015463nestles
oestrin7312233oestrin
oestrum9177783oestrum
oestrus7169573oestrus
overstrew1546483overstrew
pester84827593pest_er
pestered112814953pestered
pesterer102412703pesterer
pesters93827093pesters
pestier94317403pestier
pestle83215843pestle_
pestled102711433pestled
pestles93217693pestles
petrel83111533pe_trel
peytrel1264253peytrel
redrew10309503re_drew
regrew10388563re_grew
resew84519503res__ew
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restore75822973restore_
restored96417193restored
restorer84813723restorer
restores85222983restores
restress82511773restress
screw109318533__screw
sestet6826203sest_et
setscrew1341963setscrew
shrew119720163__shrew
stew77525463__st_ew
straw813321293__straw
strep77120853__strep
strewn96710003__strewn
strews96817093__strews
strow88920573__strow
testae64216253testae_
tested74421523test_ed
testee64323303test_ee
testees74215913testees
tester64227153test_er
testers74124543testers
testes65125823test_es
testier74015643testier
unscrew1245463unscrew
vested104217353vest_ed
vestee94319153vest_ee
vestees103513163vestees
vestral104111013vestral
vestries11314043vestries
vestry1238623vestr_y
vesture10310373vesture_
vestured1237463vestured
vestures11311033vestures
wastrel1037553wastrel
wester94222893west_er
westered122511863westered
western102911093western
westers105221963westers
yester93417983yest_er
yestern10338633yestern
yestreen1144593yestreen
zested164214043zest_ed
zester153617793zest_er
zesters163517293zesters
zestier163010223zestier

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272216.45320769.7
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.68526730.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.