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

180 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
novenas103689(None) 
novena936761novena_
novenae1046321novenae
covens114919262coven_s
dovens104413902doven_s
foveas1238622fove_as
nonas55126652no__nas
novas85215362nov__as
novellas1176342novellas
novels95512502nove_ls
ovens86217452_oven_s
wovens12449832woven_s
advents11309473advents
arenas65021993_arenas
avens86419333_aven_s
bodegas1135483bodegas
boheas114013213bohe_as
boreas85421733bore_as
bovines12412663bovines
catenas9313113catenas
codeias103911223codeias
codeinas11338023codeinas
codens94821013coden_s
convenes132916913convenes
convents132614603convents
copens106119963copen_s
corneas94717003corneas
coronas93916913coronas
corvinas13238023corvinas
coven106925043coven__
covenant1349693covenant
covenants1445893covenants
covers114627963cove_rs
coverts124813813coverts
coves105539173cove__s
covets114819643cove_ts
coveys145413503cove_ys
covings134511243covings
covins114618063covin_s
cozens176314923cozen_s
davens104612913daven_s
docents102810803docents
donas65926473do__nas
donnas75511323do_nnas
doven94718553doven__
dovened12389063dovened
doves94728153dove__s
doyens104810223doyen_s
dozens164612463dozen_s
evens84817103_even_s
events94814073_events
faenas94412763_faenas
favelas1337023favelas
foments122912053foments
fovea11310483fove_a_
foveae1237563fove_ae
foveal1237703fove_al
foveolas14135113foveolas
galenas83310343galenas
givens10379733given_s
goannas836223goannas
governs1136103governs
havens124514043haven_s
hovels125413343hove_ls
hovers124320253hove_rs
hyaenas1334983hyaenas
hyenas1288953_hyenas
invents102812053invents
juvenal1743393juvenal
juvenals1842773juvenals
korunas1135443korunas
livens94314893liven_s
lodens74315063loden_s
loments93413473loments
lovers94223433love_rs
loves85332013love__s
mavens114312973maven_s
melenas999203melenas
moments113113123moments
monas74732153mo__nas
movers115117193move_rs
moves106128423move__s
naganas847983naganas
nanas55928633n__anas
navels95712693nave_ls
naves87030383nave__s
nemas75321573n__emas
nenes55329673n__enes
nepetas935943nepetas
neves87021873neve__s
nirvanas1142513nirvanas
niveous1037193niveous
nocent83217413nocen_t
nodes64633493node__s
noels56418703no_e_ls
noes45845393no_e__s
noesis6311443no_esis
nomas74726413no__mas
nomen75621623nomen__
nomes74933123nome__s
nomina83113683nomina_
nominal92712373nominal
nominals10278623nominals
nona46929063no__na_
nonegos837143nonegos
nones55639133no__nes
nonets64118703none_ts
nonevents1247483nonevents
nonfans1037533nonfans
nonnews1035313nonnews
nonvenous1245763nonvenous
noons54125283no_on_s
norias65518203no_rias
nosebag1043673nosebag
nosebags1143603nosebags
nosegay1143843nosegay
nosegays1243313nosegays
noses55435643nose__s
nosings8349593nosings
notecase1044823notecase
notepad1044123notepad
notepads1143343notepads
noters64021003note_rs
notes55034583note__s
noumena945633noumena_
noumenal1046173noumenal
nounal639813no_unal
nouns56717313no_un_s
nouveau1043953nouve_au
nova76518953nov__a_
novae85913123nov__ae
novel85615993nove__l
novelise1137953novelise
novelist1149453novelist
novella1076213novella
novelle1058233novelle
novelly1346513novelly
novelty1365173novelty
novercal1345683novercal
novices1238223novices
nowness1037033nowness
oceans81211003_oceans
omegas936983_omegas
omens75618963_omen_s
opens76118553_open_s
operas8312453_operas
oven76624143_oven__
overs85224793_ove_rs
ovines94614343_ovines
polentas1038743polentas
ravens93916883raven_s
rodents8611543rodents
rouens64814443rouen_s
roven85521973roven__
rovers95423523rove_rs
roves84834483rove__s
rovings11439493rovings
rowens94515303rowen_s
scenas84114703_scenas
sevens93813663seven_s
slovens10316573sloven_s
solvents1136763solvents
sovrans1036483sovrans
sowens93613153sowen_s
tavernas11365043tavernas
toeas55726423to_e_as
tokens104711563token_s
uveas84912283_uve_as
veenas91410413_veenas
vena76126293__vena_
venae85920983__venae
venal85523213__venal
vends95520893__vends
vents86125933__vents
venus84918903__venus
vinas85126343__vinas
whenas124610463_whenas
womeras1287603womeras
woven115215173woven__
zoeas145815613zo_e_as

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.390458182.1
2DLD Change Limit1340271805.76623244.4
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.21928733.1
 
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.