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

168 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
debrided133658(None) 
debride1138591debride_
debrides1268721debrides
derided102914251de_rided
debited113311622deb_ited
debrief1337622debri_ef
debriefed1642142debriefed
debruised1343012debruised
decided124312422de_cided
decried112612862decri_ed
degraded12288322degraded
deprived1546462deprived
deride84420032de_ride_
derider93214972de_rider
derides93420852de_rides
derived123912762de_rived
detruded1134882detruded
abided105313313_ab_ided
abraded1138643_abraded
abridged1343903_abridged
aeried74221873ae_ri_ed
bearded114212133bear_ded
becrimed1565523becrimed
begirded1334173begirded
begrimed1475213begrimed
berimed124912283be_rimed
berried103714053berri_ed
betided114810203be_tided
bided95424973__b_ided
birded104414303__birded
braided114013213__braided
bribed115312843__bribed
bride86425543__bride_
brides94423513__brides
bridged12339033__bridged
bridled113611143__bridled
brinded115112053__brinded
brined95118413__brined
deaired9411533de_aired
dearie73319813deari_e_
dearies83526273deari_es
debagged1433723debagged
debarked16175833debarked
debarred12165643debarred
debased113310583deb_ased
debated113916083deb_ated
debeaked1634613debeaked
debearded1443373debearded
deboned113411633deb_oned
debriding1446483debriding
debriefer1541923debriefer
debriefs1433533debriefs
debris93311493debri__s
debruise1143913debruise_
debruises1243633debruises
debugged1433223debugged
debunked1633193debunked
debuted11379333deb_uted
deceived1535893deceived
decide104116873de_cide_
decider114213183de_cider
decides114217653de_cides
declined123910883declined
decoded123212393de_coded
decreed112710263decr_eed
decrier102713563decri_er
decries103319813decri_es
deeded94615543de__eded
deerweed1344193deerweed
defended1437223defended
defied115016383de_fi_ed
defiled124013103de_filed
defined123813823de_fined
defrauded1542823defrauded
defrayed1635403defrayed
defunded1435163defunded
degrade10229903degrade_
degrader11247913degrader
degrades11269923degrades
degreed10258883degr_eed
deiced104214483de__iced
deicide1149403deicide_
deicides1249303deicides
deified123112413deifi_ed
deleaded1148333deleaded
delimed11310723de_limed
deluded10158763de_luded
demanded13348513demanded
demerited1339073demerited
demised113613683de_mised
demoded123611123de_moded
denied84318633de_ni_ed
denimed1159233de_nimed
dentiled1039743dentiled
denuded10167663de_nuded
deorbited1343983deorbited
depended1337983depended
depraved1535543depraved
deprive1338303deprive_
depriver1446293depriver
deprives1438393deprives
depside1138413depside_
depsides1238503depsides
derailed102410403derailed
derated93623503de_rated
derbies103016053derbi_es
deriders102411853de_riders
derive103817043de_rive_
deriver114213913de_river
derives114017813de_rives
derries83124623derri_es
derrises93012783derrises
desanded11227453desanded
described1544953described
descried1248083descri_ed
desired9311983de_sired
despised1236933despised
despited1248323despited
destined103312453destined
detailed10319873detailed
detained103111643detained
detrained1158913detrained
detrude936083detrude_
detrudes1036203detrudes
deveined1336673deveined
deviled124112183de_viled
devised123712563de_vised
devoiced15276063devoiced
divided13378593d_ivided
dried75321383d__ri_ed
elided84814673_e_lided
eroded84313593_e_roded
excided1836203_excided
febrile1237153febrile_
ferried113411533ferri_ed
grided95117043__grided
hebraized2443963hebraized
herded114215643he_r_ded
herried113514473herri_ed
merited10313853me_rited
nitrided10276753nitrided
periled10316323pe_riled
prided103618033__prided
rebaited11410543rebaited
rebodied1237253rebodied
reboiled11349393reboiled
rebred95816353rebr__ed
rebreed104611073rebr_eed
rebuilded1342743rebuilded
reburied1137913reburi_ed
redried93714903redri_ed
refried113513883refri_ed
regraded113410763regraded
repriced132610543repriced
reprised112012213reprised
resided95217703re_sided
retried84419163retri_ed
serifed11811463se_rifed
serried82513973serri_ed
subsided1257663subsided
unbraided1336133unbraided
unbridged1453923unbridged
unbridled1344973unbridled
upbraided1542963upbraided
wearied112911823weari_ed
weirded1234513weir_ded
zebrine1836463zebrine_
zebrines1935883zebrines

Search took 9 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.453394461.4
2DLD Change Limit1461621687.79618748.3
3Display Results1681680.0762210.5
 (SQL Overall)1786911688.32521464.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.