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

311 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
drowners1242827(None) 
crowners133710751crowners
downers113912771d_owners
droners84114381dro_ners
drowner11369801drowner_
frowners14377931frowners
browner124911642browner_
browsers13449202browsers
crooners103911392crooners
crowders14398812crowders
crowers124614902crow_ers
crowner124012602crowner_
crownets13407672crownets
dowers104523292d_ow_ers
downer104414922d_owner_
dowsers115013532d_owsers
drainers92811252drainers
drawers113610072draw_ers
drawlers12307312drawlers
droner74717672dro_ner_
drones75023432dro_ne_s
droppers13318602droppers
drovers115212642dro_vers
drownds12346152drown_ds
drowned12419902drowne_d
drowns105612332drown__s
drowses114610232drowse_s
frowner13429682frowner_
groaners9248502groaners
growers113612722grow_ers
growlers12327092growlers
ironers74813552iro_ners
owners94210702__owners
prawners1346002prawners
prowlers13328932prowlers
rowers94924572_row_ers
trowsers11428002trowsers
adorners9196623adorners
arousers84810983arousers
atoners75013953ato_ners
avowers1336333avow_ers
blowers124313593blow_ers
boners84825433_bo_ners
bowers115523703_bow_ers
bowlers123715783_bowlers
bowyers15438733_bowyers
branners104010923branners
brawlers13408643brawlers
brewers123811063brew_ers
briners94315633br_iners
broiders114211193broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610243brooders
brothers133410833brothers
browless1346653browless
browned134710973browne_d
brownest1398893brownest
brownier13226913brownier_
brownies13189613brownies
brownness1444343brownness
browns116415633brown__s
browser124911143browser_
browses124712693browse_s
chowders17387543chowders
cloners94514823clo_ners
clowders14357473clowders
clownery1633313clownery
coiners93620753_coiners
conners94023113_conners
corners94723313_corners
coroners104016223coroners
cowers114625533_cow_ers
crawlers13309013crawlers
croakers14288523croakers
crofters13358903crofters
crones84729243cro_ne_s
crooner93714043crooner_
croppers143311483croppers
crosiers103312063crosiers
crossers103912703crossers
crowbars1544443crowbars
crowder13389863crowder_
crower114117563crow_er_
crowned133912433crowne_d
crownet123714113crowne_t
crownless1443423crownless
crowns115615113crown__s
crozers184111083cro_zers
croziers19287003croziers
damners104112113d_amners
darkeners1435153darkeners
darners83815773d_arners
deboners11268113deboners
definers124211193definers
dehorners1344743dehorners
diners75525953d__iners
dinners83915443d_inners
diopters1137693diopters
diviners12308353diviners
dobbers123513253d_obbers
dockers143715003d_ockers
dodders105511793d_odders
dodgers105213823d_odgers
doers65225713d_o__ers
doffers14359853d_offers
doggers104413433d_oggers
donees74519493d_o_nees
donnees84210363d_onnees
donnerd9427813d_onnerd
donnert82815533d_onnert
donors75115793d_o_nors
doodlers10338843doodlers
doozers17419293d_oozers
dopers95522483d_o_pers
dormers104313923d_ormers
dorpers104113173d_orpers
dorsers83516303d_orsers
dosers75723633d_o_sers
dossers84516233d_ossers
doters74423913d_o_ters
dotters83715973d_otters
dousers84817273d_ousers
dowagers1334893d_owagers
dowels104813343d_ow_els
dower95027703d_ow_er_
dowery134311663d_ow_ery
downed115314783d_owne_d
downier11299703d_ownier_
downless1236363d_ownless
downs94918573d_own__s
dowser104716083d_owser_
dowses105718303d_owse_s
dozers164815423d_o_zers
drabness1135803drabness
drafters12338533drafters
draggers11357393draggers
dragnets10136563dragnets
drainer83012843drainer_
drapers105313353dr_apers
drawbars1483103drawbars
drawees11378363draw_ees
drawer104711363draw_er_
drawler11338593drawler_
dreamers11369003dreamers
dredgers11256093dredgers
dressers9359863dressers
driers74516733dr__iers
drifters12417913drifters
drillers9429723drillers
drinkers13277823drinkers
drippers13327943drippers
drivers114412793dr_ivers
drogues9398393drogue_s
droller84110283droller_
drollery12314793drollery
drollness1043623drollness
drone65324983dro_ne__
droned84616863dro_ne_d
drongos935493dro_ngos
droplets1136063droplets
dropper12329873dropper_
drosera836203dro_sera
droseras935883dro_seras
drosses84513823drosse_s
drover104614593dro_ver_
droves105116673dro_ve_s
drown95515823drown___
drownd11478313drown__d
drownded14334433drownded
drowning13298363drowning
drowse105010553drowse__
drowsed12448743drowse_d
drowsier1284903drowsier_
drowsiness1443643drowsiness
drubbers13386033drubbers
drudgers11326853drudgers
drummers13316163drummers
druthers1275793druthers
dryers10449273dr__yers
dryness11114783dr_yness
eloiners8128153eloiners
fawners13388493_fawners
flowers133413173flow_ers
fowlers133411203_fowlers
frothers14279813frothers
frowned14348833frowne_d
frowns126011393frown__s
glowers113412093glow_ers
goners74420173_go_ners
grainers93012073grainers
grinners9288043grinners
groaner82510133groaner_
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
gropers104813853gro_pers
grossers94410973grossers
grounders1156783grounders
groupers11358643groupers
grousers93810733grousers
grouters95910083grouters
grower104614933grow_er_
growler11318973growler_
grownups1441503grownups
groynes1137823groyne_s
honers94324973_ho_ners
howlers133312353_howlers
ironer64216453iro_ner_
irones64724013iro_ne_s
ironness836953ironness
joiners144211573_joiners
knowers1436353know_ers
kroner104612573kro_ner_
loaners73913623_loaners
loners64225813_lo_ners
loriners839963loriners
lowers94624923_low_ers
lowness1037813_lowness
moaners92813553_moaners
mooners94015343_mooners
mowers113219403_mow_ers
nonowners1245123nonowners
nowness1037033_nowness
owner84613313__owner_
pawners124311073_pawners
plowers123812243plow_ers
powders134111553_powders
powers113822323_pow_ers
powters124015663_powters
prawner1246803prawner_
preeners102712813preeners
probers113514583pro_bers
prodders1237463prodders
profaners14256213profaners
proffers16126593proffers
proggers12258163proggers
proofers13118363proofers
propers113619033pro_pers
prosers94219643pro_sers
prospers123012263prospers
provers123817793pro_vers
prower114218123prow_er_
prowess1237903prow_ess
prowler123310013prowler_
pruners93710723pr_uners
rawness1038153_rawness
roamers93713463_roamers
roarers73812743_roarers
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_ro_gers
rolfers104011813_rolfers
rollers73117473_rollers
rompers113412243_rompers
ronnels7318613_ronnels
roofers105013903_roofers
roomers95416413_roomers
roosers74217883_roosers
rooters74522933_rooters
ropers84325903_ro_pers
rosters73727543_rosters
rotters74421393_rotters
rounders92613693_rounders
rousers75220143_rousers
routers74822873_routers
rovers95423523_ro_vers
rowels94515453_row_els
rowens94515303_row_ens
rower85430493_row_er_
rozzers1535633_rozzers
ruiners74213023_ruiners
runners74212453_runners
scorners10228493scorners
scowders14276233scowders
scowlers13257373scowlers
showers134612683show_ers
slowness1135013slowness
sooners73916643_sooners
sorners73416873_sorners
sowers94923443_sow_ers
spawners13396493spawners
stoners74817953sto_ners
swooners11336863swooners
throwers14106033throw_ers
toners64128003_to_ners
tonners73816403_tonners
towers94423673_tow_ers
townees10269783_townees
trainers83114643trainers
trawlers113310203trawlers
troffers14125433troffers
trollers83211213trollers
trones65629283tro_ne_s
troopers10289443troopers
trotters83310243trotters
trouncers1134803trouncers
troupers10359443troupers
trousers83910633trousers
trovers103713323tro_vers
trowelers12105263trowelers
trowels10358363trow_els
uptowners1441933uptowners
vowers124317183_vow_ers
wonners104312813_wonners
wowsers13488763_wowsers
wrongers12327773wrongers
yawners13367183_yawners
yowlers13328923_yowlers
zoners155115993_zo_ners

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.436409841.7
2DLD Change Limit1461623116.45322650.2
3Display Results3113110.1262468.3
 (SQL Overall)1786913117.01525472.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.