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

399 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
ketenes11481350(None) 
ketene106613001ketene_
ketones115014501ketones
retenes76324621retenes
butenes9313032butenes
cetanes9315132cetanes
detentes92712862detentes
detents83615152detents
ethenes103313872_ethenes
keened114013622ke_ened
keener104012832ke_ener
keeners113610782ke_eners
keenest11410962ke_enest
keens95721182ke_en_s
keeves133711982ke_eves
kernes104717522ke_rnes
ketches164012192ketches
ketone105014532ketone_
ketoses114912872ketoses
kettles113411612kettles
pentenes10315632pentenes
retene69224272retene_
retines75134672retines
retunes76918402retunes
serenes73222902serenes
venenes102712132venenes
acetones10310033acetones
achenes12313493achenes
agenes74720253_agenes
akenes104817343_akenes
alkenes114212753alkenes
arenes64928393_arenes
atones65225773_atones
attends8257593attends
attunes737823attunes
beetles9312083beetles
beeves114615043be_eves
beignes10149243beignes
benes75536233__benes
bennes86019013be_nnes
benzenes1946853benzenes
betaines10313293betaines
betakes134212523betakes
betels84515063bete_ls
betides104915263betides
betimes115114413betimes
betises94816123betises
betonies10413063betonies
betons84919553beton_s
butanes9312743butanes
butene8312623butene_
catenas9313103catenas
cements112714223cements
centeses1079443centeses
centones10313663centones
cetane8315283cetane_
cetes75731103cet__es
cuteness1039673cuteness
cymenes1477413cymenes
debones103315113debones
decanes103118913decanes
defences1439633defences
defends12358773defends
defense1137503defense
defenses1237913defenses
defines114118683defines
deletes83117933deletes
dements103016623dements
demesnes1137083demesnes
denes65639723__denes
dentines93418393dentines
depends11348993depends
depones103717093depones
desexes1537833desexes
destines93619663destines
detects104011093detects
detent73624483deten_t
detente83313603detente
deterges101510083deterges
deters74724683dete_rs
detests83711743detests
detinues9569823detinues
detoxes1538803detoxes
dienes75719903_dienes
ektexines2041963ektexines
emends95711433_emends
emeses86114963_emeses
emetines10611053emetines
ententes8312763ententes
epees75219833_epe_es
ernes55224813_e_rnes
esnes54817363_e_snes
etapes85415293_etapes
etches114217763_etches
eterne6311723_eterne_
ethanes103713503_ethanes
ethene93312923_ethene_
ethnos947053_ethnos
ethynes13377573_ethynes
etnas54713933_et_nas
etudes73811603_etudes
etwees9348793_etwees
evened101010313_evened
evener91010623_evener
eveners10109503_eveners
evenest10312103_evenest
evens84817103_even_s
events94814073_events
exines135715803_exines
extends15227113extends
extents142610173extents
externes1539823externes
fedexes1835473fedexes
feezes184412613fe_ezes
felines104718073felines
fetches153413893fetches
fetes85630143fet__es
fettles103912733fettles
fetuses10310243fetuses
gelees74116263gele_es
genes65133093__genes
geneses82613523geneses
gerents82612923gerents
gyrenes11267523gyrenes
haptenes133810823haptenes
heezes184211643he_ezes
heptanes1339003heptanes
heredes11313133heredes
heteros10312683heteros
hexanes17319463hexanes
hexones17299143hexones
indenes82916253indenes
intends8239963intends
intense72511903intense
intents72115703intents
internes82721233internes
intines7921113intines
intones7816533intones
jetes124922843jet__es
jetons134512613jeton_s
jetties143613123jetties
kalends1235683kalends
kanes95529373k__anes
kanteles1238123kanteles
kebbies1537253kebbies
keckles12318763keckles
kedges124812943ke_dges
keefs125116283ke_e_fs
keeked104810113ke_eked
keeks84717253ke_e_ks
keeled114414263ke_eled
keels94622413ke_e_ls
keen84830403ke_en__
keenly1336373ke_enly
keenness1234883keenness
keeper123811913ke_eper
keepers133410983ke_epers
keeps116020283ke_e_ps
keets95123483ke_e_ts
keeve124512123ke_eve_
kegeler1245493kegeler
kegelers1355163kegelers
keleps12478813kele_ps
kellies113516853kellies
kelpies13289903kelpies
kelters113813753kelte_rs
kenches163912273kenches
kenned114411263ke_nned
kennel10369213ke_nnel
kennels11387193kennels
kenos95220623k__enos
kens85435233k__en_s
kentes105118643ke_ntes
kermes124616123ke_rmes
kerne94718213ke_rne_
kerned114112923ke_rned
kernel104010583ke_rnel
kernels11417953kernels
kerns94719563ke_rn_s
kerosenes1345453kerosenes
kerries113317913kerries
ketamines15177013ketamines
ketols104210763ket_ols
ketonic1349923ketonic
ketose105711813ketose_
ketosis11429733ketosis
kettle104311613kettle_
kevels134410713keve_ls
kewpies16246923kewpies
kexes166216813k__exes
keystones1645083keystones
kines95039133k__ines
kineses113111253kineses
kiters105218583kite_rs
kites95432543kit__es
kithes135016653kit_hes
kittened1334523kittened
kittens11347583kitten_s
kitties113213623kitties
kittles113012493kittles
kleenex1842383kleenex
knees95114873k_ne_es
koines10415733k_oines
krewes1337923k_rewes
kvetches2053583kvetches
kytes125012913kyt__es
kythes16499133kyt_hes
lateens74210553lateens
latened8711923latened
lateness82614073lateness
latens64620213laten_s
latents75214313latents
latexes1438313latexes
lebens8310093leben_s
legends936073legends
lenes54738523__lenes
leones64417723le_ones
letches124015483letches
lethes94818083let_hes
levees93714523leve_es
lexemes1635673lexemes
liteness82213213liteness
meetness1036653meetness
melees83618083mele_es
melenas999203melenas
mentees93214503mente_es
menthenes1447703menthenes
mesnes85216213me_snes
mestees94617753meste_es
metages102714973metages
metates92720003metates
meteors94610013meteors
metepas1136303metepas
metered103514013metered
meters85625833mete_rs
metes74736213met__es
methanes133812163methanes
metopes11311363metopes
metres85121563met_res
mettles94115023mettles
muteness1039013muteness
mutines93117823mutines
neatened937043neatened
neatens73310403neaten_s
nemeses948663nemeses
nenes55329673__nenes
neotenies948383neotenies
nettles73214083nettles
octanes91111393octanes
oftener1035923oftener
oftenest1148863oftenest
patens84820863paten_s
patents94815203patents
patines95225763patines
pectens11189203pecten_s
pectines121914673pectines
peened94318153pe_ened
peens76428193pe_en_s
peeves113814873pe_eves
penes75839223__penes
pentanes10316073pentanes
pentene9313793pentene_
peones83821043pe_ones
peptones12311033peptones
petered103314963petered
peters86624593pete_rs
petites93820203petites
pettles93916483pettles
pewees11311393pewe_es
pinenes93416673pinenes
poteens92910883poteens
potences12710693potences
preteens1038123preteens
pretences132312603pretences
pretends11299113pretends
pretense10199813pretense
pretenses112210583pretenses
pyrenes123511223pyrenes
ratines75328583ratines
recanes93222263recanes
recedes102816063recedes
redenies9615713redenies
redeyes112910973redeyes
reeves94721493re_eves
refences13311843refences
refines105426343refines
regents83416543regents
relends84013253relends
relents74018503relents
releves103914973releves
relines75331323relines
remends105013033remends
reneges82513593reneges
repents93717623repents
repines94927383repines
rerents73319423rerents
resees63827483rese_es
resends83513713resends
resents74221223resents
retakes113718863retakes
retapes93917423retapes
retaxes143615093retaxes
retches123318513retches
reteams9339563reteams
retears72814923retears
retells73211523retells
retems83914573rete_ms
retests73813853retests
reties65436193ret_ies
retiles74426993retiles
retimes95020173retimes
retinas74819353retinas
retine66237333retine_
retinenes9410373retinenes
retints74717013retints
retinues85113153retinues
retires74726213retires
retries74129073retries
retune69121953retune_
retuned86613973retuned
retypes12308623retypes
revenges1238983revenges
revenues1138663revenues
reveres103621343reveres
rexines144719153rexines
rezones163213943rezones
sateens73710753sateens
scenes84520353_scenes
secedes103711983secedes
seethes103613743seethes
seines65029903se_ines
sememes11109203sememes
semens84616963semen_s
sentences11610303sentences
serene63522353serene_
serener73415753serener
serenest82717623serenest
serines74229543serines
sestines82717243sestines
setlines8312743setlines
setons64620173seton_s
settees73513633settees
settles73916003settles
sevens93813663seven_s
skeanes113610713ske_anes
skeens103912913ske_en_s
skenes104616633_skenes
sketches1746823sketches
sphenes123013163sphenes
stanes64933403_stanes
steeves103410903steeves
steles63725663_steles
stenos63915773_stenos
stents65019453_stents
steres63929533_steres
stones65130033_stones
teener64717503te_ener
teeners74415453te_eners
teens56227483te_en_s
tees45353583__te_es
teethes103611653teethes
teles54536003__teles
teleses7313123teleses
telexes1438343telexes
tends65425583__tends
tenet55542213__tenet
tenets65518953__tenets
tens45647413__ten_s
tense55225843__tense
tenses64722553__tenses
tents56434213__tents
tenues63816443__tenues
tepees84215243tepe_es
ternes65422903te_rnes
terpenes102111563terpenes
terrenes82212593terrenes
testees74215913teste_es
tetanies8513543tetanies
tetanus737933tetanus
tines54848423__tines
tones56048663__tones
trienes74118413trienes
tunes55332193__tunes
tutees6514553tute_es
tynes85920303__tynes
ukeleles1252663ukeleles
untunes72211253untunes
veenas91410413ve_enas
venene92912523venene_
venines103516613venines
vertexes18105613vertexes
vestees103513163veste_es
vetches153411263vetches
vetoes92914083vet_oes
weened104013733we_ened
weenies102915093we_enies
weens85224053we_en_s
wetness10277723wetness
xylenes1745093xylenes

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.1401276364.3
2DLD Change Limit1340273997.62617575.0
3Display Results3993990.1402850.0
 (SQL Overall)1786913997.90622601.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.