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

206 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
vena7612629(None) 
veena81912321veena
vela75725541vela
venae85920981venae
venal85523211venal
vend86626421vend
vent76049051vent
vera76828841vera
vina76331811vina
ana39559832_ana
anna45529012anna
arena55323812arena
avens86419332avens
bean66443862bean
bema85825252bema
ben56554922ben_
bend76435262bend
bene66439492bene
bens65945702bens
bent67759912bent
beta66234132beta
buna64730722buna
ceca84820782ceca
cent67451012cent
dean56039482dean
den47554342den_
denar65223292denar
dene56643412dene
deni56929392deni
dens55945072dens
dent57158412dent
deny86027122deny
deva85720982deva
dona55529632dona
en28052392_en_
end46834362_end
eng46726782_eng
ens37245922_ens
era35741502_era
eta35834192_eta
etna46415262etna
even75222272even_
evens84817102evens
event85924442event
faena85014202faena
fen66851352fen_
fend84832972fend
fens76139762fens
feta76528902feta
frena85915272frena
gen45950512gen_
gene56237222gene
genoa64315822genoa
gens55740072gens
gent56954392gent
genu55929072genu
genua64614152genua
geta56627442geta
hen67555272hen_
henna84414042henna
hens75642572hens
hent76656382hent
hyena11810252hyena
jean116629282jean
kana85928552kana
kea76540922ke_a
ken76344002ken_
kenaf12316032kenaf
keno87926452keno
kens85435252kens
kent86846982kent
kina85632012kina
kuna85120712kuna
lea37660182le_a
lean46345242lean
lend56233672lend
leno47331392leno
lens46146492lens
lent46360532lent
leva77020712leva
luna46229852luna
mana65341962mana
mean65538092mean
mega77620872mega
men59252852men_
menad85918982menad
mend75334032mend
meno66031362meno
mensa75318672mensa
menta74424422menta
menu65130232menu
mesa67025482mesa
meta65932412meta
mina65136932mina
myna95815302myna
na28652482__na
nana46632902nana
nema65522522nema
nene45932062nene
nona46929062nona
novena936762novena
oven76624142oven_
ovens86217452ovens
pea56657242pe_a
pean66147172pean
pen56558842pen_
penal75228372penal
pend75934532pend
penna74520202penna
pens65649642pens
pent66559072pent
pina65842642pina
plena75816392plena
puna65331652puna
regna64614812regna
renal55929512renal
rend56136572rend
rent46661242rent
scena74815782scena
sea36161292se_a
sen36058522sen_
send55237292send
sene46848052sene
senna54617982senna
sensa54117472sensa
sent46963012sent
sera46141392sera
seta45637312seta
tea37353322te_a
tela45532972tela
ten35856112ten_
tend56433772tend
tenia55324482tenia
tens45647412tens
tent46159862tent
tepa66021682tepa
tuna45127842tuna
ulna46317332ulna
uvea74712652uve_a
van66246332van_
vanda94515922vanda
vane75534692vane
vang84926052vang
vans76236742vans
vara75530892vara
varna84516182varna
vasa76522972vasa
veal76936812veal
vee65750182ve_e
veenas91410412veenas
veep95325092veep
veer76229572veer
vees75439432vees
veg76931062ve_g
vegan95114152vegan
veil75523592veil
vein75625752vein
veinal93812962veinal
veins84620492veins
veiny115414362veiny
velar85817632velar
veld85323202veld
vends95520892vends
venge95117992venge
venial94218282venial
venin85118662venin
venom103914862venom
vents86125932vents
venue84918212venue
venus84918902venus
verb96224872verb
vernal93514212vernal
vert77249372vert
very108025642very
vest75743602vest
vesta86618302vesta
vet65958522ve_t
veto76622992veto
vets76835092vets
vex136429172ve_x
vext146927762vext
via65636252v_ia
viga85622972viga
vinal85725812vinal
vinas85126342vinas
vinca105315162vinca
vine75643692vine
vino76128442vino
viny106025962viny
visa76323882visa
vita75828532vita
viva106119102viva
wean75734352wean
weka117013872weka
wen66249602wen_
wend85330452wend
wens76337932wens
went76051872went
xenia124814772xenia
yea66445752ye_a
yean75834582yean
yen66847382yen_
yens75832262yens
yenta83917042yenta
zeta135121642zeta
zona136321962zona

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298722060.83035990.4
3Display Results2062060.0464478.3
 (SQL Overall)1786912061.156154577.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.