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

394 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
drowner1136980(None) 
browner124911641browner
crowner124012591crowner
downer104414921d_owner
droner74717671dro_ner
drowned12419901drowned
drowners12428271drowners
frowner13429681frowner
browned134710972browned
brownier13226912brownier
browser124911142browser
crooner93714042crooner
crowder13389842crowder
crower114117552crow_er
crowned133912422crowned
crowners133710742crowners
crownet123714112crownet
dower95027702d_ow_er
downed115314782d_owned
downers113912772d_owners
downier11299702d_ownier
dowser104716082d_owser
drainer83012842drainer
drawer104711362draw_er
drawler11338592drawler
droller84110282droller
drone65324982dro_ne_
droned84616862dro_ned
droners84114382dro_ners
drones75023432dro_nes
dropper12329872dropper
drover104614592dro_ver
drown95515822drown__
drownd11478312drown_d
drownded14334432drownded
drownds12346152drownds
drowns105612332drown_s
drowse105010552drowse_
drowsed12448742drowsed
drowses114610232drowses
drowsier1284902drowsier
frowned14348832frowned
frowners14377932frowners
groaner82510132groaner
grower104614932grow_er
growler11318972growler
ironer64216452iro_ner
kroner104612572kro_ner
owner84613312__owner
prawner1246802prawner
prower114218122prow_er
prowler123310012prowler
rower85430492_row_er
adorner8246983adorner
adroiter946193adroiter
arouser74514423arouser
atoner64817193ato_ner
avower1236823avow_er
blower115316573blow_er
blowier1248943blowier
boner75133083_bo_ner
bower107328183_bow_er
bowler114217313_bowler
bowyer14368923_bowyer
branner94212373branner
brawer114216333braw_er
brawler124310233brawler
brawnier13216723brawnier
brewer114812543brew_er
briner84519043br_iner
broader103412613broader
broider103912973broider
broiler92911753broiler
broker124314243bro_ker
bronzer18348493bronzer
brooder103811623brooder
brother123311333brother
browed125216393brow_ed
brown105619533brown__
brownest1398893brownest
brownie12178433brownie
brownies13189613brownies
browns116415633brown_s
browny144510043brown_y
browse115713853browse_
browsed134511233browsed
browsers13449203browsers
browses124712693browses
chowder16387803chowder
cloner84418093clo_ner
clowder13367933clowder
clowned13447723clowned
clownery1633313clownery
coiner84323783_coiner
conner84423963_conner
corner84625623_corner
coroner94218203coroner
cower104531773_cow_er
cowier113616163_cowier
crawler123510453crawler
croaker133010683croaker
crofter12299573crofter
crone75231333cro_ne_
crones84729243cro_nes
crooker134111093crooker
crooned103813343crooned
crooners103911393crooners
cropper133312963cropper
crosier94116573crosier
crosser95015463crosser
crowbar1444263crowbar
crowded14418783crowded
crowders14398803crowders
crowed124717293crow_ed
crowers124614893crow_ers
crown105620083crown__
crownets13407673crownets
crowns115615113crown_s
crozer175112843cro_zer
crozier18369933crozier
damner95213433d_amner
darkener1335993darkener
darner74017303d_arner
dawned113912093d_awned
deboner103110483deboner
decrowned1663653decrowned
definer114413773definer
dehorner1235523dehorner
dewier104013463d_ewier
diner65632903d__iner
dinner74217163d_inner
diopter1038473diopter
disowned1336433disowned
diviner11369883diviner
dobber114015423d_obber
docker134417653d_ocker
dodder94712913d_odder
dodger95817043d_odger
doer57734703d_o__er
doffer133911353d_offer
dogger95216783d_ogger
done55747913d_o_ne_
donee66931013d_o_nee
donne65520463d_onne_
donned85015743d_onned
donnee74317063d_onnee
donnerd9427813d_onnerd
donnert82815533d_onnert
donor64418193d_o_nor
doodler93310153doodler
doomier103610123doomier
doozer163910463d_oozer
doper86128393d_o_per
dopier93515923d_opier
dorkier122810023dorkier
dormer94415903d_ormer
dorper94314573d_orper
dorser74819183d_orser
doser66228563d_o_ser
dosser74417973d_osser
doter65428623d_o_ter
dotier73917033d_otier
dotter74419343d_otter
dourer74215273d_ourer
douser75621633d_ouser
dowager1245803d_owager
dowdier12328573d_owdier
dowed104632613d_ow_ed
dowel95618193d_ow_el
dowers104523293d_ow_ers
dowery134311663d_ow_ery
dowie94721143d_owie_
down86427493d_own__
downs94918573d_own_s
downy125714553d_own_y
dowse96020813d_owse_
dowsed115015013d_owsed
dowsers115013533d_owsers
dowses105718303d_owses
dozer158419273d_o_zer
dozier163611633d_ozier
drabber12438593drabber
drafter11449423drafter
dragger10309173dragger
dragnet91211433dragnet
drained93713253drained
drainers92811253drainers
draper94315693dr_aper
drawbar13103193drawbar
drawee104413823draw_ee
drawees11378363drawees
drawers113610073draw_ers
drawled12368343drawled
drawlers12307313drawlers
drawlier12225253drawlier
drawn95614243drawn__
dreamer104110843dreamer
dredger10347443dredger
dresser83611953dresser
drier64423963dr__ier
drifter11348703drifter
driller84311883driller
drinker12349483drinker
dripper12349233dripper
driver104714493dr_iver
drogue8938333drogue_
drogues9398393drogues
drolled93810223drolled
drollery12314793drollery
drongo836793dro_ngo
drooled9369203drooled
droolier936073droolier
drooped11368433drooped
droopier1145573droopier
droplet10312113droplet
dropped13329283dropped
droppers13318603droppers
drosera836203dro_sera
drosses84513823drosses
drossier956313drossier
drouked1335543drouked
drove95518063dro_ve_
droved114611643dro_ved
drovers115212643dro_vers
droves105116673dro_ves
drowning13298363drowning
drowsy13487903drow_sy
drubber12357863drubber
drudger10328323drudger
drummer12407503drummer
drunker12326633drunker
dryer95111463dr__yer
dunner73913823d_unner
eloiner7149183eloiner
fawner125910463_fawner
flower124815503flow_er
fowler123712583_fowler
fronter103611583fronter
frother133110153frother
frown115415973frown__
frowns126011393frown_s
frowsier1444893frowsier
frowzier2343313frowzier
glower105114933glow_er
goner66025163_go_ner
gowned114410133_gowned
grainer83714063grainer
greener83111713greener
grinner8329233grinner
groaned9259973groaned
groaners9248503groaners
grocer94212143gro_cer
grodier939673grodier
groined92710813groined
groomer10399873groomer
groover11358543groover
groper94517253gro_per
grosser84313143grosser
grounder1047613grounder
grouper104210093grouper
grouser84513693grouser
grouter84412523grouter
growers113612723grow_ers
growled12278163growled
growlers12327093growlers
growlier1234883growlier
grown95317353grown__
grownup1342213grownup
groyne1037213groyne_
groynes1137823groynes
honer85332093_ho_ner
howler123514313_howler
irone55126363iro_ne_
ironed74916013iro_ned
ironers74813553iro_ners
irones64724013iro_nes
joiner134114133_joiner
knower1337073know_er
krone94018733kro_ne_
kronen10348913kro_nen
kronor10417233kro_nor
kronur10415313kro_nur
loaner64416503_loaner
loner55431043_lo_ner
loriner7511893loriner
lower85830413_low_er
moaner84415113_moaner
mooner85317833_mooner
mower104523453_mow_er
nonowner1145253nonowner
owned95113233__owned
owners94210703__owners
pawner114212923_pawner
plower114315063plow_er
powder123611903_powder
power105325953_pow_er
powter114116033_powter
prawned1346743prawned
prawners1346003prawners
preener93114833preener
preowned1435213preowned
prober104516073pro_ber
prodder1147953prodder
profaner13197943profaner
proffer15126933proffer
progger11319373progger
prone75332623pro_ne_
proofer12149103proofer
proper104319953pro_per
proser84223463pro_ser
prosier93817483prosier
prosper114012193prosper
prouder10310383prouder
prover113819723pro_ver
prowar114110943prow_ar
prowled13309903prowled
prowlers13328933prowlers
pruner83413453pr_uner
rawer84623733_raw_er
roamer84715163_roamer
roarer63914333_roarer
robber103916533_robber
rocker124319573_rocker
roger64521413_ro_ger
rolfer94412273_rolfer
roller63919793_roller
romper104213683_romper
ronnel63310883_ronnel
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
roper75431913_ro_per
ropier84118803_ropier
rosier64221263_rosier
roster64329083_roster
rotter64325463_rotter
rounder83514603_rounder
rouser65224083_rouser
router65025843_router
rover85527373_ro_ver
rowdier11348593_rowdier
rowed94034323_row_ed
rowel84721413_row_el
rowen84921153_row_en
rowens94515303_rowens
rowers94924573_row_ers
rozzer1437353_rozzer
ruiner64013643_ruiner
runner63814463_runner
scorner9259763scorner
scowder13286853scowder
scowler12248173scowler
shower124315113show_er
showier1339103showier
slower94016153slow_er
snowier1038793snowier
sooner64220463_sooner
sorner64720393_sorner
sower85229313_sow_er
spawner12347363spawner
stoner65823203sto_ner
swooner10358673swooner
thrower1386993throw_er
toner55336243_to_ner
tonner64819203_tonner
tower85729203_tow_er
townee92815213_townee
trainer73316793trainer
trawler104011903trawler
troffer13125863troffer
troller73913173troller
trone55131863tro_ne_
trones65629283tro_nes
trooper94210363trooper
trotter73312253trotter
trouncer1035443trouncer
trouper93811433trouper
trouser73812473trouser
trover95014663tro_ver
trowed104714653trow_ed
trowel94211463trow_el
troweler11106063troweler
trowsers11428003trowsers
unowned1148803unowned
uptowner1342043uptowner
urbaner9177133urbaner
vower115220793_vow_er
wonner95114443_wonner
wowser125110203_wowser
wronger11288823wronger
yawner12428473_yawner
yowler123310043_yowler
zoner144520343_zo_ner

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.1561145455.1
2DLD Change Limit1340273947.25018486.5
3Display Results3943940.1402814.3
 (SQL Overall)1786913947.54623680.2
 
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.