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
bestrewn1343331bestrewn
bestrews1335601bestrews
bestrow1237251bestrow
bedstraw1443252bedstraw
beshrews1643162beshrews
bested94922762best_ed
bestow1149462best_ow
bestrewed1594192bestrewed
bestrid1039972bestrid
bestrown1345202bestrown
bestrows1337042bestrows
bistre83815022bistre_
bistred103311852bistred
bistres94017212bistres
kestrel1137112kestrel
strew89220662__strew
baste74829983bast_e_
basted95227233bast_ed
baster85333603bast_er
basters94930313basters
bastes85330383bast_es
bearer85323913be_arer
beastie92412433beastie_
beasties102514653beasties
beaten84617063beat_en
beater84729393beat_er
beaters94925043beaters
bedew114513043be__dew
bedsore1057803bedsore_
bedsores1157633bedsores
bedstraws1542403bedstraws
beetle8311673beetle_
beetled1038223beetled
beetler938043beetler
beetles9312083beetles
before11410153before_
befret11315963be_fret
belted94020633belt_ed
belter84720963belt_er
belters93819413belters
bemire103312803bemire_
bemired123410633bemired
bemires113212833bemires
beret74946363be__ret
berthed13259123berthed
bescreen1244313bescreen
beseem1069083bes_eem
beses75830723bes__es
beset76739133bes__et
besetter10137983besetter
beshrewed1882733beshrewed
beside95114613beside_
besides104814533besides
besnow1145713bes_now
besotted1135843besotted
bespread1344183bespread
besprent1248033besprent
best66355323best___
bestead10389123bestead
bestial9311643bestial
besting104923923besting
bestir8311163best_ir
bestirred1243813bestirred
bestirs9311133bestirs
bestowed14156623bestowed
bestower13126213bestower
bestows1248863bestows
bestrewing1643773bestrewing
bestride1138613bestride
bestrides1237913bestrides
bestrode1147143bestrode
bestrowed1585183bestrowed
bests75932613best__s
bestud9439303best_ud
bestuds10326753bestuds
betel74419903be_t_el
bethel1169643be_thel
betray111511443be_tray
betted94721163be_tted
better84723703be_tter
bettered113011843bettered
betters94422093betters
beware11313713beware_
bewared13310113bewared
bewares12313373bewares
bister84922763bist_er
bistered112913333bistered
bisters93922613bisters
bistro8339943bistr_o
bistros92810983bistros
brew95023563b___rew
busted95123153bust_ed
buster84726493bust_er
busters94724133busters
bustier93916153bustier
bustle84015483bustle_
bustled104011523bustled
bustler94012573bustler
bustles93816323bustles
bystreet1345023bystreet
centre84316643centre_
centred103411683centred
centres93817123centres
costrel9310373costrel
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
festered122512113festered
festers104121393festers
gastrea847243gastrea
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
nested74720073nest_ed
nester64124183nest_er
nesters74422793nesters
nestle63013953nestle_
nestled8349913nestled
nestler73510453nestler
nestles73015463nestles
oestrin7312243oestrin
oestrum9177783oestrum
oestrus7169583oestrus
overstrew1546483overstrew
pester84827593pest_er
pestered112814973pestered
pesterer102412713pesterer
pesters93827093pesters
pestier94317403pestier
pestle83215843pestle_
pestled102711453pestled
pestles93217693pestles
petrel83111533pe_trel
peytrel1264253peytrel
redrew10309513re_drew
regrew10388563re_grew
resew84519503res__ew
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restore75822983restore_
restored96417193restored
restorer84813723restorer
restores85222993restores
restress82511773restress
screw109318543__screw
sestet6826203sest_et
setscrew1341963setscrew
shrew119720173__shrew
stew77525463__st_ew
straw813321293__straw
strep77120853__strep
strewn96710013__strewn
strews96817103__strews
strow88920573__strow
testae64216253testae_
tested74421523test_ed
testee64323303test_ee
testees74215913testees
tester64227153test_er
testers74124543testers
testes65125823test_es
testier74015643testier
unscrew1245463unscrew
vested104217353vest_ed
vestee94319153vest_ee
vestees103513173vestees
vestral104111013vestral
vestries11314053vestries
vestry1238623vestr_y
vesture10310373vesture_
vestured1237463vestured
vestures11311043vestures
wastrel1037553wastrel
wester94222893west_er
westered122511873westered
western102911103western
westers105221963westers
yester93417983yest_er
yestern10338643yestern
yestreen1144603yestreen
zested164214043zest_ed
zester153617793zest_er
zesters163517293zesters
zestier163010223zestier

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.420425454.8
2DLD Change Limit1340272217.01619103.1
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.51623774.7
 
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.