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

366 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
kernels1141795(None) 
kennels11387191kennels
kernel104010591kernel_
kernes104717531kerne_s
cornels94716662cornels
crenels93711012crenels
darnels83710432darnels
ernes55224812_erne_s
fennels10387902fennels
ferrels10248622ferrels
keels94622412ke__els
keeners113610782keeners
kennel10369222kennel_
kermes124616132kerme_s
kermess13396222kermess
kerne94718222kerne__
kerned114112932kerne_d
kerneled1344032kerneled
kernelly1543932kernelly
kerns94719562kern__s
kerseys1433992kerseys
kevels134410712ke_vels
tercels94110362tercels
ternes65422902terne_s
aeneus61111143ae_neus
aerials74017553aerials
aeries64737783aerie_s
aerogels945593aerogels
akenes104817343ake_ne_s
arenes64928393arene_s
ariels65119373_ariels
artels66216233_artels
barbels114514433barbels
barneys12569563barneys
barrels94514363barrels
bedels94015273be_dels
benes75536233be_ne_s
bennes86019013benne_s
bennets94712163bennets
berets85822523ber_ets
bermes106023003berme_s
beryls11107883ber_yls
betels84515063be_tels
bethels1238533bethels
bevels113913983be_vels
bezels173712283be_zels
bordels103911973bordels
borneols1046343borneols
burners94115673burners
burnets93813263burnets
cannels93413363cannels
carcels114516063carcels
carnets93918403carnets
carneys124310543carneys
carpels115315463carpels
carrels95117303carrels
cartels94618123cartels
carvels124914593carvels
cereals9313173cereals
ceres75540013cer_e_s
cereus85215523cer_eus
cermets1139713cermets
certes84623083certe_s
cervelas1344673cervelas
charnels13328173charnels
corbels113813593corbels
cormels113813373cormels
corneas94717003corneas
cornel84020053cornel_
corners94723313corners
cornets94820573cornets
coronels104012143coronels
creels84416943_creels
crenel84213063crenel_
crewels12438493crewels
darnel74312183darnel_
darners83815773darners
dearness939973dearness
deckels14367363deckels
defuels11296983defuels
denes65639723de_ne_s
derails84216393derails
devels104313903de_vels
dirndls933893dirndls
dorsels84412573dorsels
dynels10536813_dynels
earners74016453earners
easels65914553_easels
eels46536743_e__els
eeriness8311873eeriness
enols54718403_e_nols
enrols61213383_enrols
erne46727423_erne__
erns45428223_ern__s
erses55826803_erse_s
ervils948773_ervils
esnes54817363_esne_s
eternals8238953eternals
excels1536663_excels
expels1547173_expels
fardels11389893fardels
farfels13348213farfels
farness102912203farness
feels85223043fe__els
fennecs12305693fennecs
fennel9429473fennel_
ferals94216643fer_als
feres86038183fer_e_s
fernery1335813fernery
fernless1136063fernless
ferns85220083fern__s
ferrel92810203ferrel_
ferrets103111393ferrets
ferules103112723ferules
fewness1335003fewness
feyness1334923feyness
fresnels1135233fresnels
funnels10348173funnels
garners83815983garners
garnets84115403garnets
genes65133093ge_ne_s
genets75716663ge_nets
genres75515623genre_s
gerbils1037303gerbils
gerents82612923gerents
germens1078623germens
gruels73910153_gruels
gunnels8358563gunnels
gurnets84010793gurnets
gurneys11406463gurneys
harness102413933harness
heels85625533he__els
herbals122710603herbals
herders113914123herders
heres86245903her_e_s
herls85226433her__ls
hernias10310773hernias
herns84825583hern__s
heroes94923823heroe_s
herpes115517323herpe_s
herself1337623herself
hirsels10128343hirsels
hornets104113553hornets
hornfels1443783hornfels
jebels15418913je_bels
jennets14517633jennets
jereeds15326393jereeds
jerkers18287083jerkers
jerseys1733243jerseys
jewels16508613je_wels
jurels133710583jur_els
kanes95529373k_ane_s
karns96624143karn__s
keckles12318763keckles
kedges124812983kedge_s
keefs125116283ke__efs
keeks84717253ke__eks
keel85729473ke__el_
keened114013633keene_d
keener104012843keene_r
keenest11410963keenest
keenly1336373keen_ly
keenness1234883keenness
keens95721183ke__ens
keepers133410983keepers
keeps116020283ke__eps
keets95123483ke__ets
keeves133711993keeve_s
keggers13357043keggers
keglers12277773keglers
keleps12478813ke_leps
kelters113813753kelters
kenafs1337113ke_nafs
kendos114510663ke_ndos
kenned114411273kenne_d
kenneled1334003kenneled
kenos95220623ke_n_os
kens85435233ke_n__s
kentes105118653ke_ntes
kerbed13339703kerbe_d
kerbs115013673ker__bs
kerfed14358233kerfe_d
kerfs125413573ker__fs
kermesse14303483kermesse
kermis124012393ker_mis
kern85326213kern___
kerneling1464403kerneling
kernelled1443733kernelled
kerning124010893kerning
kernite1159473kernite
kernites1269113kernites
kerogens1345763kerogens
kerrias11289513kerrias
kerries113317913kerries
kersey1336793kerse_y
kestrels1235813kestrels
ketenes114813503ketenes
ketols104210763ke_tols
ketones115014503ketone_s
kettles113411613kettles
kevel124213103ke_vel_
kevils13358333ke_vils
kexes166216823ke_xe_s
keyless1436163keyless
keypals1634353keypals
keysets1434343keysets
kidneys1533423kidneys
kines95039133k_ine_s
kirmess13234313kirmess
kirned11408623kirne_d
kirns95315453kirn__s
kirtles11309663kirtles
knawels14344683knawels
kneels10408933k_neels
knees95114873k__nees
knell94210923k__nell
knells10439253k__nells
knelt94617683k__nelt
koels94613903k__oels
koines10415733koine_s
kraals10378433k_raals
kreeps12427413k_reeps
krewes1337923krewe_s
krills104211283k_rills
kugels1146073k_ugels
kummels15234793kummels
kyries133411373kyrie_s
leaners73718173leaners
learners8398153learners
lenes54738523le_ne_s
leones64417723leone_s
levels94113283le_vels
liernes739623lierne_s
marcels113212373marcels
marvels123810093marvels
meaners94415243meaners
mercers114412773mercers
merces105720743merce_s
merdes94518603merde_s
merely111312593mer_ely
meres75143573mer_e_s
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
merles85322763merle_s
merls77423903mer__ls
mesnes85216213mesne_s
morels84820013mor_els
morsels94112653morsels
nearness838313nearness
nenes55329673ne_ne_s
nereis6315343ner_eis
nerols6914883ner_ols
nerves94216193nerve_s
newels93710823ne_wels
newness1035703newness
oriels64914623_oriels
panels84716523_panels
parcels113712663parcels
parrels94713493parrels
peels75226423pe__els
pencels113610053pencels
penes75839223pe_ne_s
penners93414183penners
peones83821043peone_s
peres76246643per_e_s
perils84121853per_ils
pernods1038483pernods
perses85428063perse_s
pertness10310093pertness
petrels9279373petrels
petronels1146063petronels
rebels84518133re_bels
redness82012443redness
reels55333263__reels
refeels10379693refeels
refels94618053re_fels
refuels10399523refuels
reheels10298253reheels
renews93811753re_news
rennets75212633rennets
repanels1036783repanels
repels84318763re_pels
rerents73319423rerents
rerolls739943rerolls
revels94220573re_vels
riels55121333__riels
ronnels7318613ronnels
runnels7329153runnels
seels55632823se__els
seidels838393seidels
seiners74219273seiners
seines65029903seine_s
sennets73712583sennets
sequels1665703sequels
serails73318363serails
serenely1147623serenely
serenes73222903serenes
seres55448893ser_e_s
sergers83815633sergers
serges74225973serge_s
serials73919743serials
series64540973serie_s
serines74229543serine_s
servals103410743servals
servers103214833servers
serves94423653serve_s
simnels976103simnels
skeanes113610713skeane_s
skenes104616633ske_ne_s
skewness1533763skewness
sorels63921163sor_els
sorners73416873sorners
sorrels7310723sorrels
spinels94512443spinels
streels73811343streels
teasels74311313teasels
teazels16406893teazels
teels55726373te__els
teeners74415453teeners
telnets738373telnets
tenets65518953te_nets
tenners74014923tenners
tenrecs936033tenrecs
tercel83612993tercel_
terces83921413terce_s
tercets93512443tercets
termers95414503termers
terne56426153terne__
terns55226873tern__s
terrets72913583terrets
tersely1038113tersely
thermels13607763thermels
tiercels10344733tiercels
tunnels7328723tunnels
turners73912893turners
unkennels1342573unkennels
unreels7258313unreels
veiners104112523veiners
verbals121910743verbals
vergers114412633vergers
verges104320183verge_s
vermeils1374813vermeils
vermes115019143verme_s
vernal93514213vernal_
verniers11227843verniers
versers103813523versers
verses94223763verse_s
versets103913103versets
verves124617883verve_s
vervets13419753vervets
vessels1035933vessels
warners103315563warners
weaners104613833weaners
weasels10468503weasels
wedels103811033we_dels
weiners103913063weiners
wergeld1233183wergeld
wergelds1342293wergelds
wergelt1138583wergelt
wergelts1253413wergelts
wetness10277723wetness
wurzels1934083wurzels
yarners104312203yarners
yearners11346373yearners
zeroes154314343zeroe_s

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.406440125.6
2DLD Change Limit1340273665.67023637.9
3Display Results3663660.1262904.8
 (SQL Overall)1786913666.20228811.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.