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

123 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
drownded1433443(None) 
drowned12419901drown_ed
browned134710972brown_ed
crowded14418802crow_ded
crowned133912442crown_ed
downed115314782d_own_ed
droned84616862dro_n_ed
drownd11478312drown__d
drownds12346152drownd_s
drowner11369802drown_er
drowsed12448752drow_sed
fronded12388862fro_nded
frowned14348832frown_ed
grounded1136572grounded
rounded93013502_rounded
abounded1234903abounded
arointed939003arointed
aroynted1244523aroynted
bonded104719953_bo_nded
bounded113613763_bounded
branded114414103br_anded
brinded115112053br_inded
brocaded1436353brocaded
bronzed19308213bro_nzed
brooded113510933bro_oded
browed125216403brow__ed
browner124911643brown_er
brownie12178433brownie_
brownier13226913brownier
brownies13189613brownies
browsed134511243brow_sed
clowned13447733clown_ed
crooned103813353croon_ed
crowder13389863crow_der
crowed124717313crow__ed
crowner124012603crown_er
crownet123714113crown_et
dawned113912093d_awn_ed
decrowned1663663decrown_ed
defended1437223defended
defunded1435163defunded
demanded13348513demanded
depended1337983depended
desanded11227453desanded
disowned1336433disown_ed
donned85015743d_o_nned
dowed104632613d_ow__ed
doweled12269773d_oweled
dowered122811553d_owered
downer104414923d_own_er
downier11299703d_ownier
dowsed115015013d_ow_sed
drained93713253drain_ed
drawled12368343draw_led
dreaded103612023dr_eaded
drolled93810223dro_lled
drone65324983dro_n_e_
droner74717673dro_n_er
drones75023433dro_n_es
drooled9369203dro_oled
drooped11368433dro_oped
dropped13329293dro_pped
dropsied1234973dropsied
drouked1335543dro_uked
droved114611643dro__ved
drown95515823drown___
drownding1564123drownding
drowners12428273drowners
drowning13298363drowning
drowns105612333drown__s
drowse105010553drow_se_
drowses114610233drow_ses
drowsier1284913drowsier
eroded84313593ero__ded
fonded115717043_fo_nded
founded124011423_founded
friended1335033friended
fronted114011273fro_nted
frounced1434493frounced
frowner13429683frown_er
frowsted1534323frowsted
gowned114410133_gown_ed
grinded104210633gr_inded
groaned9259973groan_ed
groined92710813groin_ed
grounder1047613grounder
growled12278173grow_led
hounded123311033_hounded
ironed74916013iro_n_ed
ironweed1244053ironweed
mounded113711983_mounded
owned95113233__own_ed
poinded11358973_poinded
ponded105218773_po_nded
pounded114112803_pounded
prawned1346743prawn_ed
preowned1435213preown_ed
prodded1257733pro_dded
pronged113912393pro_nged
propended1546163propended
protended1336803protended
provided1536843provided
prowled13309913prow_led
rended84524103_r_ended
rewinded13277673_rewinded
rinded84418983_r_inded
rodded93713703_ro_dded
rondel73212643_ro_ndel
roundel8308853_roundel
rounder83514613_rounder
rowed94034323_row__ed
roweled11269863_roweled
sounded93214463_sounded
stounded10276213stounded
swounded13314563swounded
trended94011763tr_ended
trounced1135033trounced
trowed104714653trow__ed
troweled12106113troweled
unowned1148813unown_ed
unrounded1135863unrounded
wounded12329763_wounded
wronged12397673wro_nged

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.440406115.9
2DLD Change Limit1461621236.62322068.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.10925135.9
 
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.