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

154 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
bedside115684(None) 
bedsides1246531bedsides
beside95114611be_side
bedlike14369532bedlike
bedrid1039942bedrid_
bedsit9312842bedsi_t
bedsits1037562bedsits
bedsore1057802bedsore
bedtime1236972bedtime
besides104814532be_sides
betide95115972be_tide
depside1138402depside
reside74224932re_side
seaside839692seaside
aedile73716653aed_ile
aedine73218393aed_ine
aside65122083__aside
backside17108143backside
baddie104114033baddi_e
bankside15115653bankside
beachside1743063beachside
beadlike15137253beadlike
beanie83618593beani_e
beastie92412433beastie
becrime1387053becrime
bedded115114073bed__ded
bedder104215793bed__der
bedding124114483bedding
bedewed1437153bedewed
bedim10313833bed_i_m
bedims1149593bed_ims
bedizen1935943bed_izen
bedmate1239433bedmate
bedrape1277693bedrape
bedridden1441683bedridden
bedrivel1444083bedrivel
beds75937783beds___
bedsheet1446683bedsheet
bedsores1157633bedsores
bedtick1645233bedtick
bedtimes1336593bedtimes
beduin939713bedui_n
beduins1039123beduins
bedunce1235683bedunce
beehive1554033beehive
beelike13379783beelike
beeline93314723beeline
begrime1276553begrime
beguile1056933beguile
beguine1068503beguine
beige81515383be__ige
belie75630383be_li_e
belied95022163be_lied
belike124616283be_like
belive115415303be_live
bellied104314073bellied
bemire103312803be_mire
bendwise1443413bendwise
benzine1839343benzine
berime105317333be_rime
berline93716853berline
berried103714043berried
besiege1035413be_siege
beslime1146833beslime
besmile1137463besmile
bested94922753be_sted
bestride1138613bestride
betaine9413783betaine
betided114810203be_tided
betides104915263be_tides
betime105914833be_time
betise85616273be_tise
bide76041503b___ide
biocide1237323biocide
blindside1342753blindside
bodice11711423bod_ice
bodied103814583bod_ied
bolide9515563b_olide
boride9415903b_oride
bride86425533b__ride
broadside1343603broadside
bromide12269583bromide
buddied12388003buddied
budgie104310343budgi_e
budlike14257873budlike
busied95117223b_usied
dayside1236173dayside
debride1138593debride
decide104116873de_cide
deicide1149403deicide
depsides1238503depsides
deride84420033de_ride
desire7415303de_sire
eddied9248323_eddied
edile64819493_ed_ile
eide55832243_e__ide
elide64922643_e_lide
ensile62616473_ensile
eosine64519413_eosine
excide1638423_excide
farside1138603farside
felsite1039083felsite
hessite1038993hessite
hydride15257503hydride
inside7613453_inside
iodide84812933iod_ide
landside10147443landside
mediae94217413med_iae
medicide1447713medicide
midsize1946393midsize
mudslide1243593mudslide
nearside944913nearside
newsie9138213newsi_e
offside1453693offside
onside7511803_onside
outside82414193outside
overside122013933overside
pensile92713543pensile
pensive122610393pensive
pepsine11310603pepsine
peptide122910683peptide
pesade9311103pe_sade
preside10715613preside
redecide12127183redecide
rediae74221993red_iae
redid74922393red_id_
redivide1355933redivide
redline84218833redline
redried93714893redried
redrive112410563redrive
resid64124093re_sid_
resided95217703re_sided
resider84615803re_sider
resides84523283re_sides
resids74219153re_sids
residue8689863re_sidue
resile64627673re_sile
resite64128453re_site
resize154117723re_size
roadside1044893roadside
seasides938743seasides
sedile73517233sed_ile
sessile739523sessile
side55444493___side
subside10410453subside
tensile72612733tensile
tensive10269913tensive
topside1037733topside
upside9289803_upside
versine102515173versine
wayside1435183wayside
weakside1642843weakside
website1235323website
wedgie11428373wedgi_e

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.436409841.7
2DLD Change Limit1340271546.84319586.0
3Display Results1541540.0463347.8
 (SQL Overall)1786911547.32524394.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.