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

248 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
keenest1141096(None) 
deepest10310442deepest
evenest10312102evenest
greenest9312622greenest
keened114013632keene_d
keener104012842keene_r
keeners113610782keeners
keenness1234882keenness
keens95721182keen_s_
keeves133711992keeves_
kernes104717532kernes_
ketenes114813502ketenes_
leanest7415862leanest
meanest9315702meanest
meekest1336892meekest
openest9312912openest
renest64529712_renest
serenest82717622serenest
teeniest82112412teeniest
weeniest112411212weeniest
aeriest73924053aeriest
agenes74720253agenes_
akenes104817343akenes_
anenst63514983anen_st
arenes64928393arenes_
beefiest13269013beefiest
beeriest104013403beeriest
beeves114615043beeves_
behest11314613_behest
benes75536233_benes_
bennes86019013bennes_
bennet84823363benne_t
bennets94712163bennets
bequest1837823bequest
cleanest10310293cleanest
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
decentest1249083decentest
deediest102912253deediest
deepness1136443deepness
deffest14308803deffest
deftest112611713deftest
denes65639723_denes_
densest83112473densest
detest74122843_detest
devest104418703_devest
dewiest11312343dewiest
dienes75719903dienes_
dueness82310123dueness
dunnest83312263dunnest
earnest7318733earnest
eeliest73516473eeliest
eeriest73620673eeriest
egest65222343__egest
eldest72912683_eldest
ernes55224813_ernes_
esnes54817363_esnes_
fainest10417703fainest
featest102715113featest
feeblest1336913feeblest
feeless103511103feeless
feezes184412613feezes_
fellest10313753fellest
fenniest113113203fenniest
ferniest1132214153ferniest
fewest12311663_fewest
fewness1335003fewness
feyest12311403_feyest
feyness1334923feyness
finest94321733_finest
fleetest1136723fleetest
freeness11710443freeness
freest95318283fre_est
funest94316863_funest
funnest102912003funnest
geekiest13257863geekiest
geest64829613_ge_est
genes65133093_genes_
genet66038683_gene_t
genets75716663_genets
greeniest1039033greeniest
greyest11348343greyest
heezes184211643heezes_
heppest14228143heppest
honest94822423_honest
inanest72115363inanest
jennet134714953jenne_t
jennets14517633jennets
kanes95529373k_anes_
kedges124812983kedges_
keefs125116283kee_fs_
keeked104810123keeke_d
keeks84717253kee_ks_
keeled114414273keele_d
keelless12236193keelless
keels94622413kee_ls_
keen84830413keen___
keening123713153keening
keenly1336373keen_ly
keeper123811923keepe_r
keepers133410983keepers
keeps116020283kee_ps_
keet85347343k_e_e_t
keets95123483kee_ts_
keeve124512133keeve__
kenned114411273kenne_d
kennel10369223kenne_l
kennels11387193kennels
kenos95220623k_enos_
kens85435233k_en_s_
kent86846963k_en__t
kentes105118653kentes_
kermes124616133kermes_
kermess13396223kermess
kerne94718223kerne__
kerned114112933kerne_d
kernel104010593kerne_l
kernels11417953kernels
kerns94719563kern_s_
ketene106613003ketene__
ketones115014503ketones_
kexes166216823k_exes_
keyless1436163keyless
keyset13411533keyse_t
keysets1434343keysets
kindest12311503kindest
kines95039133k_ines_
kleenex1842383kleene_x
knees95114873kne_es_
knelt94617683k__nelt
knesset11310413knesset
koines10415733koines_
krewes1337923krewes_
leeriest83112883leeriest
leftest10269463leftest
lenes54738523_lenes_
leones64417723leones_
lewdest1136283lewdest
liefest1038443liefest
lievest1048343lievest
meekness1434303meekness
meetness1036653meetness
merest84725113_merest
mesnes85216213mesnes_
nearest73415843nearest
neatest72516003neatest
neediest92611303neediest
nenes55329673_nenes_
nest45548733___nest
newest9314213_newest
newness1035703newness
oftenest1148863oftenest
oneness7512143oneness
peened94318163peene_d
peens76428193peen_s_
peeress939503peeress
peeves113814873peeves_
penes75839223_penes_
peones83821043peones_
pertest9317043pertest
plenist9314333plenist
pretest9517633pretest
queerest1746273queerest
realest73322433realest
recentest11410283recentest
reddest9311953reddest
redness82012443redness
reediest92815423reediest
reefiest112811483reefiest
reeject16349623reeject
reekiest122711313reekiest
reelect911515633reelect
reenact9413003reenact
reenlist8410363reenlist
reerect92915883reerect
reest54938093_re_est
reeves94721493reeves_
reinvest1138203reinvest
renests74014213_renests
rennet64624853renne_t
rennets75212633rennets
request16311023request
retenes76324623retenes_
retest64028453_retest
revest94623603_revest
sanest64426693_sanest
scenes84520353scenes_
searest73322023searest
seediest92714053seediest
seepiest102412623seepiest
seeress7311573seeress
seines65029903seines_
sennet64224143senne_t
sennets73712583sennets
serenes73222903serenes_
serest64831613_serest
severest11310323severest
sexiest142112223sexiest
sheeniest12158353sheeniest
sheerest11310083sheerest
skeanes113610713skeanes_
skeens103912913skeen_s_
skenes104616633skenes_
skewness1533763skewness
sleekest1236153sleekest
soonest7415593soonest
steepest1038123steepest
sternest8314433sternest
sweetest1137173sweetest
tannest72617853tannest
teener64717503teene_r
teeners74415453teeners
teens56227483teen_s_
teensiest945823teensiest
teensy9478273teen_sy
teentsy1034073teentsy
telnet6518833telne_t
telnets738373telnets
tempest1139223tempest
tenet55542213_tene_t
tenets65518953_tenets
tennist72813113tennist
tensest72713313tensest
ternes65422903ternes_
tersest71713993tersest
tweeness11246403tweeness
unevenest1247473unevenest
vainest10315763vainest
veenas91410413veenas_
veiniest1139383veiniest
venenes102712133venenes_
veriest103719133veriest
waeness102512783waeness
wannest103915003wannest
weakest1439003weakest
weediest122311133weediest
weened104013733weene_d
weenies102915093weenies_
weens85224053ween_s_
weensiest1244743weensiest
weensy12416823ween_sy
weepiest13219473weepiest
weest85026773_we_est
wenniest11259593wenniest
wetness10277723wetness
wettest10239363wettest
woeness1020211543woeness

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.390458182.1
2DLD Change Limit1340272486.67320085.0
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.15624970.8
 
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.