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 “bestrode” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
bestrode114714(None) 
bestride1138611bestride
bestrid1039972bestrid_
bestrides1237912bestrides
bestrow1237252bestro_w
bestrowed1585172bestrowed
bestrown1345202bestrown
bestrows1337042bestrows
cestode1037962cest_ode
estrone7413952_estrone
oestrone849972oestrone
restrove1138962restrove
strode75215972__strode
tetrode839342te_trode
astride8311973_astride
beetroot1047253beetroot
beshroud1443803beshroud
beshrouded1751833beshrouded
beshrouds1543063beshrouds
beside95114613bes__ide
besmoke15416623bes_moke
bespoke15468113bes_poke
bestead10389123bestead_
besteaded1345073besteaded
besteads11307123besteads
bested94922763best_ed_
bestirred1243813bestirred
bestow1149463best_o_w
bestowed14156623best_owed
bestower13126213best_ower
bestows1248863best_ows
bestrew1248003bestr_ew
bestrewed1594193bestrewed
bestrewn1343333bestrewn
bestrews1335603bestrews
bestridden1451753bestridden
bestud9439303best_ud_
bestudded1442543bestudded
bestuds10326753best_uds
betide95115973be_t_ide
betroth1247543be_troth
biostrome1344603biostrome
bistre83815023bistr__e
bistred103311853bistred_
bistro8339943bistro__
bistroic1246383bistroic
bistros92810983bistro_s
boltrope1243903boltrope
cestodes1138203cest_odes
destroy1138153destro_y
destroyed1445083destroyed
destroyer1344553destroyer
destroys1236693destroys
detrude936083de_trude
dextrose1645363dextrose
electrode1247033electrode
erode64520993_e__rode
estrogen946573_estrogen
estrones8313323_estrones
estrous7712533_estrous
extrude1545013_extrude
instroke1245583instroke
keystroke1552283keystroke
oestrogen1044443oestrogen
oestrones949773oestrones
oestrous869923oestrous
outrode82313423_outrode
outstrode1065423outstrode
overstrode1445223overstrode
pentode1039893pent_ode
pesthole1347553pesthole
postcode1346323postcode
restoke116113903rest_oke
restore75822983rest_ore
restored96417193restored
restrike1239673restrike
restrive11310923restrive
restroom1047573restroom
sarode75317513__sarode
stride75420963__stride
strobe84513813__strobe
stroke105116173__stroke
strove95014793__strove
tetrodes939093te_trodes
trode65322853___trode
upstroke1443993upstroke

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 Limit146162867.39019778.3
3Display Results86860.0461869.6
 (SQL Overall)178691867.85922737.1
 
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.