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 “nenes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

285 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
nenes5532967(None) 
benes75536231benes
denes65639721denes
genes65133091genes
lenes54738521lenes
nene45932061nene_
neves87021871neves
nines55937341nines
nones55639131nones
penes75839221penes
acnes75922622acnes
aedes64625142aedes
aeneus61111142aeneus
agenes74720252agenes
akenes104817342akenes
aneles64626292aneles
anes45255932_anes
arenes64928392arenes
banes74945582banes
bees65453382be_es
bends85628972bends
bene66439492bene_
bennes86019012bennes
bens65945702ben_s
bents76033692bents
beses75830722beses
bines76946792bines
bones76446532bones
canes75350372canes
cedes84927322cedes
cees65941592ce_es
cense75121402cense
censes83721802censes
cents74730332cents
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
cines75239682cines
cones76457422cones
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
dene56643412dene_
denies74729642denies
dens55945072den_s
dense65923502dense
dents65031802dents
dexes135224512dexes
dienes75719902dienes
dines66449152dines
dunes65332172dunes
dynes95917582dynes
ekes86726602_ekes
emes65434662_emes
ends56528522_ends
engs56121392_engs
ens37245922_en_s
ernes55224812ernes
eses45336102_eses
esnes54817362esnes
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fanes84639892fanes
feces105625362feces
fees76450602fe_es
femes105626222femes
fences114617112fences
fends96324972fends
fens76139762fen_s
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fines86644262fines
gees55647882ge_es
gene56237222gene_
genet66038682genet
genets75716662genets
genies75324942genies
genres75515622genres
gens55740072gen_s
gentes75324162gentes
gents65729612gents
genus65319832genus
hebes105521672hebes
hemes105031082hemes
henges104516452henges
hens75642572hen_s
hents87330742hents
heres86245902heres
hexes155123042hexes
hones88144492hones
inanes62519802inanes
indenes82916252indenes
janes124928122janes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
jones125028182jones
kanes95529372kanes
keens95721182keens
kenos95220622kenos
kens85435232ken_s
kentes105118642kentes
kernes104717522kernes
kexes166216812kexes
kines95039132kines
knees95114872kne_es
lanes54946792lanes
lees45455882le_es
leges64427282leges
lends65326252lends
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
lense54523432lense
lenses64620892lenses
leones64417722leones
leses54930812leses
lexes127225262lexes
lines57054572lines
lunes55337772lunes
manes76648952manes
memes94927702memes
mends84927692mends
mense75025632mense
menses84222452menses
menus75822842menus
meres75143572meres
mesnes85216212mesnes
metes74736212metes
mezes167719262mezes
mines75651952mines
nabes75427092nabes
names74833362names
nanas55928632nanas
nances83618642nances
nans46139392nan_s
napes74828462napes
nares55544152nares
nates55238332nates
naves87030382naves
neaps75618322neaps
nears55529422nears
neats55931902neats
nebs66124982ne_bs
necks115119332necks
nee36657782ne_e_
need54934152ne_ed
needs65719632needs
neem67328082ne_em
neems77316292neems
neep65728312ne_ep
neeps75617882neeps
negs55727362ne_gs
negus64513562negus
neifs85613042neifs
nemas75321572nemas
neoned7311482neoned
neons55818682neons
nerds65719252nerds
nereis6315342nereis
nerts55924982nerts
nerves94216192nerves
ness45526562ne_ss
nesses64718322nesses
nests55728002nests
nets45941532ne_ts
netts55320722netts
neuks96510862neuks
neumes83112622neumes
neums75414252neums
neve76224832neve_
never86218642never
nevus84611392nevus
newel86114132newel
newels93710822newels
newer85717462newer
newest9314212newest
newies91014072newies
newness1035702newness
news76127372ne_ws
newts86015282newts
nexus124710662nexus
nides65229132nides
nieces84112712nieces
nieves94311292nieves
nine45842172nine_
nites55736342nites
nixes124519622nixes
nodes64633492nodes
noes45845392n_oes
nomes74933122nomes
nonas55126652nonas
nonces84418832nonces
none45743172none_
nonet54540842nonet
nonets64118702nonets
noses55435642noses
notes55034582notes
nudes64723292nudes
nukes95418122nukes
nuns45228232nun_s
oneness7512142oneness
ones46146532_ones
panes76148692panes
pedes85327282pedes
peens76428192peens
pees65257372pe_es
pekes114623562pekes
peles75738082peles
pends85527192pends
penis75129322penis
pens65649642pen_s
peones83821042peones
peres76246642peres
pinenes93416672pinenes
pines76048862pines
pones74547042pones
redes65139122redes
rees45364192re_es
reges65628782reges
rends65129952rends
renest64529712renest
renew83917512renew
renews93811752renews
rentes65431192rentes
rents55935182rents
rexes124526952rexes
runes55530222runes
sanes55649072sanes
scenes84520352scenes
sees45361052se_es
seines65029902seines
semes75731582semes
sends65528242sends
sene46848052sene_
sense55526822sense
senses63923942senses
seres55448892seres
sexes126126222sexes
sines55954822sines
skenes104616632skenes
sones55444142sones
teens56227482teens
tees45353582te_es
teles54536002teles
tends65425582tends
tenet55542212tenet
tenets65518952tenets
tens45647412ten_s
tense55225842tense
tenses64722552tenses
tents56434212tents
tenues63816442tenues
ternes65422902ternes
tines54848422tines
tones56048662tones
tunes55332192tunes
tynes85920302tynes
vanes85130972vanes
vees75439432ve_es
veges94118862veges
vends95520892vends
venenes102712132venenes
venges104015142venges
vents86125932vents
venues95115202venues
venus84918902venus
vexes155719122vexes
vines85137642vines
wanes85040882wanes
weens85224052weens
wees76249122we_es
wends95822812wends
wens76337932wen_s
wines85546862wines
yens75832262yen_s
yentes95517602yentes
yeses85119322yeses
zees136331892ze_es
zines145232652zines
zones145528042zones

Search took 3 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 Filter178691538000.0961861364.6
2DLD Change Limit538002851.95027589.7
3Display Results2852850.0803562.5
 (SQL Overall)1786912852.12684050.3
 
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.