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

403 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
knowers143635(None) 
knower1337081knower_
answers1037042answers
avowers1336332avowers
blowers124313592blowers
bowers115523702_bowers
cowers114625532_cowers
crowers124614902crowers
dowers104523292_dowers
endowers1238232endowers
flowers133413172flowers
glowers113412092glowers
gnawers11356392gnawers
growers113612722growers
knawels14344682knawels
knawes13328392knawe_s
knifers14537082knifers
knockers13285732knockers
knollers12255142knollers
knotters12276152knotters
knowns13426442know_ns
knows124912412know__s
kotowers1534312kotowers
lowers94624922_lowers
mowers113219402_mowers
noters64021002_noters
plowers123812242plowers
powers113822322_powers
rowers94924572_rowers
showers134612682showers
snorers74313802snorers
sowers94923442_sowers
towers94423672_towers
vowers124317182_vowers
adorers84411733adorers
angers75222543an_gers
anglers84014823anglers
annoyers1185033annoyers
anodes74418763anode_s
anoles64827433anole_s
answer936893answer_
anthers103715203anthers
antlers74014743antlers
atoners75013953atoners
avower1236823avower_
blower115316573blower_
bonders104120663bonders
boners84825433_boners
bonkers134015303bonkers
boogers104514633boogers
bookers134016613bookers
boomers114115913boomers
boozers183912443boozers
borers85122683_borers
bowels114315593_bowels
bower107328183_bower_
bowery146012113_bowery
bowlers123715783_bowlers
bowyers15438733_bowyers
boxers155013483_boxers
brewers123811063brewers
brokers133111913brokers
browsers13449203browsers
canoers94318373cano_ers
chawers154412053chawers
chewers154111143chewers
chokers164311523chokers
cholers124215203cholers
chowders17387543chowders
clawers123910973clawers
cloners94514823cloners
closers94415323closers
clovers125114663clovers
clowders14357473clowders
coders95426983_coders
comers105328083_comers
confers124120093confers
congers104223233congers
conkers133721043conkers
conners94023113conners
cooers84324563_cooers
cookers134619463cookers
coolers93522493coolers
coopers114019483coopers
cooters94525723cooters
copers104629843_copers
corers85231073_corers
covers114627963_covers
cower104531773_cower_
crowders14398813crowders
crower114117563crower_
crowners133710753crowners
crozers184111083crozers
doers65225713_do_ers
doozers17419293doozers
dopers95522483_dopers
dosers75723633_dosers
doters74423913_doters
dowels104813343_dowels
dower95027703_dower_
dowery134311663_dowery
downers113912773_downers
dowsers115013533_dowsers
dozers164815423_dozers
drawers113610073drawers
droners84114383droners
drovers115212643drovers
drowners12428273drowners
elopers95112943elopers
embowers15236453embowers
emoters94712873emoters
empowers15276843empowers
encoders1137513encoders
enders74324053en_ders
endower1138483endower_
enjoyers1843883enjoyers
enows85115493enow__s
enrobers10236953enrobers
enters64425643en_ters
enviers1036993enviers
evokers14386793evokers
ewers86018823__ewers
flower124815503flower_
flowery16327783flowery
footers104618333footers
fowlers133411203_fowlers
foyers125413133_foyers
frowners14377933frowners
gaolers83511563gaolers
glovers114310883glovers
glower105114933glower_
gnawer10386953gnawer_
gnomes93812973gnome_s
gnoses76515163gnose_s
goers65520253_go_ers
gofers104711513_gofers
gomers94116883_gomers
goners74420173_goners
goobers10219623goobers
grocers103511253grocers
gropers104813853gropers
grower104614933grower_
growlers12327093growlers
hewers123715273_hewers
hoers85724923_ho_ers
homers114821973_homers
honers94324973_honers
honkers143315233honkers
honorers1139263honorers
hoofers134513323hoofers
hookers144916513hookers
hoopers123616483hoopers
hooters104520473hooters
hoovers134312703hoovers
hopers114222973_hopers
hosers95223963_hosers
hovers124320253_hovers
howes114730263_howe_s
howlers133312353_howlers
ignorers9215243ignorers
imbowers15295093imbowers
impowers15296823impowers
inchers123912523inchers
incomers1268593incomers
infers93615443in_fers
inkers104018833in_kers
inliers73110743inliers
inners63919353in_ners
inters64328053in_ters
intoners889933intoners
invokers1534673invokers
ionomers1038503ionomers
ironers74813553ironers
isomers9310043isomers
jokers175511193_jokers
jowars16369653_jowars
kaisers11369273kaisers
kashers143914023kashers
keeners113610783keeners
keepers133410983keepers
keggers13357043keggers
keglers12277773keglers
kelters113813753kelters
keynoters1642313keynoters
kickers124013293kickers
kidders13399173kidders
kiers95320093k__iers
killers114215583killers
kilters113813603kilters
kindlers13318483kindlers
kippers153211433kippers
kissers114211293kissers
kiters105218593k_iters
knackers13286843knackers
knappers16315643knappers
knars94416113kn__ars
knaurs10466963kn_aurs
knavery1733123knavery
knaves13439523knave_s
knawe12397883knawe__
knawel13415413knawe_l
kneaders1384713kneaders
kneelers12226213kneelers
kneels10408933kn_eels
knees95114873kn__ees
knickers13306723knickers
knifer13598563knifer_
knifes136210213knife_s
knitters12336623knitters
knives13458553knive_s
knobs11519713kno__bs
knocker12296393knocker_
knocks11397443kno_cks
knoller11285913knoller_
knolls10367413kno_lls
knops115911813kno__ps
knosps12405013kno_sps
knotless1264573knotless
knots95614723kno__ts
knotter11317643knotter_
knotweed1642103knotweed
knotweeds1741663knotweeds
knouts10438313kno_uts
know116115843know___
knowing15287683knowing
knowings16234043knowings
known12568343know__n
knurs94511153kn__urs
koels94613903k_o_els
kopeks1134603k_opeks
kors85933013k_o__rs
koshers144811803koshers
kotower1434383kotower_
kowtowers1942183kowtowers
kraters114212343kraters
krewes1337923krewe_s
kroner104612573kroner_
loners64225813_loners
longers84819543longers
lookers114014073lookers
loopers93914033loopers
looters74419163looters
lopers84424143_lopers
losers65123583_losers
lovers94223433_lovers
lower85830413_lower_
lowery124112713_lowery
lowes85732463_lowe_s
manpowers1644463manpowers
mongers104217273mongers
monomers12311033monomers
mooners94015343mooners
mooters93818623mooters
mopers104220373_mopers
movers115117193_movers
mower104523453_mower_
namers84517333_namers
newels93710823_newels
newer85717463_newer_
niters64624213_niters
nodders94410263_nodders
nodes64633493_node_s
noels56418703_no_els
noes45845393_no_e_s
noirs55615463_no_irs
nomes74933123_nome_s
nones55639133_none_s
nonets64118703_nonets
nonowners1245123nonowners
nonwars10109003_nonwars
noosers74913923noosers
noses55435643_nose_s
noshers103614333_noshers
noter55025643_noter_
notes55034583_note_s
novels95512503_novels
noways12127733_noways
nowhere1337213_nowhere
nowheres1437513_nowheres
nowness1037033_nowness
nows75738233_now__s
nowts86915863_now_ts
omers76923193__omers
onagers838103onagers
overs85224793__overs
owes75137103__owe_s
owners94210703__owners
oyers87620883__oyers
pawers114818783_pawers
plovers123611833plovers
plower114315063plower_
pokers124617923_pokers
polers84225643_polers
ponders103618843ponders
poolers94217423poolers
posers84223973_posers
powders134111553_powders
power105325953_power_
powters124015663_powters
probers113514583probers
propers113619033propers
prosers94219643prosers
provers123817793provers
prower114218123prower_
prowess1237903prowess
prowlers13328933prowlers
quoters16369263quoters
renewers11238183renewers
repowers13288533repowers
rioters73615513rioters
rogers74517913_rogers
roofers105013903roofers
roomers95416413roomers
roosers74217873roosers
rooters74522933rooters
ropers84325903_ropers
rovers95423523_rovers
rowels94515453_rowels
rowens94515303_rowens
rower85430493_rower_
runovers1134473runovers
sawers94620163_sawers
scorers94115323scorers
scoters93313813scoters
scowders14276233scowders
scowlers13257373scowlers
sewers94719723_sewers
shewers134312053shewers
shoers94518333sho_ers
shovers134613003shovers
shower124315113shower_
showery16437243showery
skewers14498383skewers
slopers94213093slopers
slower94016153slower_
smokers13389323smokers
snarers74216663snarers
sneers64016173sn_eers
snipers93311773snipers
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snorer64316763snorer_
snores64324323snore_s
snorters83410583snorters
snowed104613623snowe_d
snowier1038793snowier_
snowless1145633snowless
snows84719893snow__s
sobers85218863_sobers
sonders83820713sonders
sooners73916643sooners
sowars94318013_sowars
sowens93613153_sowens
sower85229313_sower_
spewers124210663spewers
stokers114515183stokers
stoners74817953stoners
stopers94217373stopers
storers75018683storers
stovers103713733stovers
tawers94118603_tawers
tenoners858713tenoners
thawers13428483thawers
throwers14106033throwers
tokers104818893_tokers
toners64128003_toners
tongers84116013tongers
tonners73816403tonners
toolers74416503toolers
tooters73818773tooters
topers85025323_topers
toters65026363_toters
towels94314643_towels
tower85729203_tower_
towery124012093_towery
toyers95516333_toyers
trovers103713323trovers
trowels10358363trowels
trowsers11428003trowsers
twofers1364053twofers
uncovers1336573uncovers
undoers82910583undoers
uniters73814173uniters
unswears1144023unswears
venomers1336703venomers
viewers1337173viewers
vomers115614943_vomers
voters95017443_voters
vowels124410483_vowels
vower115220793_vower_
widowers1535113widowers
winnowers1543953winnowers
wonders113315993wonders
wonners104312813wonners
wooers93712443_wooers
woofers133810583woofers
woolers104214023woolers
wowsers13488763_wowsers
yonkers14379823yonkers
yowes114926373_yowe_s
yowlers13328923_yowlers
zoners155115993_zoners

Search took 7 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.423422437.4
2DLD Change Limit1340274035.93622578.7
3Display Results4034030.1562583.3
 (SQL Overall)1786914036.51527427.6
 
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.