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

128 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
bestrows133704(None) 
bestows1248861best_ows
bestrews1335601bestrews
bestrow1237251bestrow_
bestrown1345201bestrown
bedstraws1542402bedstraws
beshrews1643162beshrews
besnows1245152bes_nows
bestow1149462best_ow_
bestrew1248002bestrew_
bestrewn1343332bestrewn
bestrode1147142bestrode
bestrowed1585172bestrowed
bistros92810982bistro_s
destroys1236692destroys
escrows1235802_escrows
estrous7712532_estrous
oestrous869922oestrous
strows96718272__strows
anestrous946603anestrous
barrows123411683b_arrows
bastions10411693bastions
becrowd1555173be_crowd
becrowds1683773be_crowds
bedstraw1443253bedstraw_
beetroot1047253beetroot
beetroots1144013beetroots
bellows124313303be_llows
belows114614183be__lows
benthons1337973benthons
benthos1238373bentho_s
bentos86218303bent_o_s
beshadows1842513beshadows
beshrew1554393beshrew_
beshroud1443803beshroud
beshrouds1543063beshrouds
besnow1145713bes_now_
besoms105712733bes__oms
besots86415453bes__ots
besteads11307123besteads
bestirs9311133best_irs
bestowal1344513best_owal
bestowals1443223best_owals
bestowed14156623best_owed
bestower13126213best_ower
bestowers14135333best_owers
bestrewed1594193bestrewed
bestrid1039973bestr_id
bestride1138613bestride
bestrides1237913bestrides
bestrowing1644373bestrowing
bests75932613best___s
bestuds10326753best_uds
betatrons1145083betatrons
betons84919553be_t_ons
betrays12127823be_trays
betroth1247543be_troth
betroths1345633be_troths
bettors93312473be_ttors
bevatrons1443713bevatrons
biotrons1037233biotrons
bistorts10118813bistorts
bistres94017213bistr_es
bistro8339943bistro__
bistroic1246383bistroic
borrows12349253b_orrows
bostons9312903bost_ons
brows105425983b___rows
burrows12399093b_urrows
cabestros1343873cabestro_s
cestos84718093cest_o_s
cistrons102710623cistrons
desirous947783desirous
destroy1138153destro_y
dextrous1646593dextrous
diestrous1046603diestrous
escrow1135913_escrow_
estops84011223_est_ops
estrays10529403_estrays
estrins7315853_estrins
estriols856253_estriols
estrone7413953_estrone
estrones8313323_estrones
estrums9208603_estrums
estrus61912113_estr_us
festoons1136443festoons
kestrels1235813kestrels
lustrous877803lustrous
maestros1046163maestro_s
mesotrons1145513mesotrons
metros84217803me_tro_s
misgrows1444963misgrows
mistbows1543993mistbows
misthrows17114213misthrows
nestors73614973nest_ors
neutrons838293neutrons
oestrins8312673oestrins
oestriols944333oestriols
oestrone849973oestrone
oestrones949773oestrones
oestrums10156473oestrums
oestrus7169583oestr_us
outrows10311403_outrows
pestos84719083pest_o_s
petrols92913083pe_trols
petrous92714423pe_trous
regrows11269153re_grows
reshows132510453res_hows
resows93915353res__ows
restores85222993restores
restress82511773restress
restroom1047573restroom
restrooms1146033restrooms
restrove1138963restrove
retros63820193re_tro_s
serows96016393__serows
stows86622703__st_ows
straws98718673__straws
strews96817103__strews
strops86220383__strops
strow88920573__strow_
strown96812093__strown
stroys95914603__stroys
testcross1142543testcross
testons7313563test_ons
testoons837323testoons
trows88826183___trows
vestries11314053vestries

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621287.33019940.2
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.79922912.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.