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

106 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
bestrides123791(None) 
bestride1138611bestride_
besides104814532bes__ides
bestrid1039972bestrid__
bestridden1451742bestridden
bestrode1147132bestrode_
betides104915262be_t_ides
restrikes1339412restrikes
restrives12310662restrives
strides84520392__strides
vestries11314052vestri_es
astride8311973_astride_
bastardies1365143bastardies
bastiles10313353bast_iles
beasties102514653beast_i_es
becrimes1467073be_crimes
bedsides1246533be_dsides
bedtimes1336593bedt_imes
begrimes1376513be_grimes
belfries1336983belfri_es
beltlines1135963beltlines
berimes115216643be__rimes
berries94423553be_rri_es
beside95114613bes__ide_
beslimes1246953bes_limes
besmiles1237393bes_miles
besteaded1345043besteaded
besteads11307113bestead_s
bestiaries1245973bestiari_es
bestirred1243803bestirred
bestirs9311133best_i_rs
bestrew1248003bestr__ew
bestrewed1594163bestrewed
bestrews1335603bestr_ews
bestriding1446003bestriding
bestrowed1585163bestrowed
bestrows1337043bestr_ows
bestudded1442533bestudded
bestuds10326753best_ud_s
betaines10313293be_taines
betide95115973be_t_ide_
betided114810203be_t_ided
betimes115114413be_t_imes
betises94816123be_t_ises
bistres94017213bistr__es
borides10515153b__orides
bourrides1244823bourrides
brides94423513b___rides
bustlines11207353bustlines
cestodes1138203cest_odes
cestoids11308273cestoid_s
debrides1268723de_brides
derides93420853de__rides
describes1446003describes
descries11311923descri_es
destines93619663dest_ines
destrier9311823destri_er
destriers1038143destriers
detrudes1036203de_trudes
deuterides1245253deuterides
dextrines1798313dextrines
entries71523163_entri_es
eserines8413743_eserines
estrins7315853_estri_ns
estriols856253_estriols
estrones8313323_estrones
estruses838483_estruses
extrudes1645243_extrudes
gentrices1258913gentrices
gentries91315263gentri_es
nitrides92910703_nitrides
oestrins8312673oestri_ns
oestriols944333oestriols
oestrones949773oestrones
oestruses946403oestruses
outrides92414993_outrides
outstrides1154743outstrides
overstrides1545873overstrides
pastries101517423pastri_es
peltries10313023peltri_es
peptides132610263pept_ides
pesticides1546723pesticides
postrider1246653postrider
postriders1344853postriders
rectrices1338873rectrices
resides84523283res__ides
restricts1138823restricts
restrike1239673restrike_
restrings10159293restrings
restrive11310923restrive_
restriven1246233restriven
restudies10156033restudies
retries74129073re_tri_es
sentries81318053sentri_es
sestines82717243sest_ines
stride75420963__stride_
strider84315723__strider
striders94412123__striders
strifes104716583__strifes
strikes114719093__strikes
stripes95320573__stripes
strives104119373__strives
tectrices1346253tectrices
tetrodes939093te_trodes
vestiges1238243vest_iges
wastries111212883wastri_es

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.406440125.6
2DLD Change Limit1486411066.48322927.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.93525766.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.