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

227 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
genesis8251082(None) 
agenesis938041agenesis
geneses82613521geneses
ageneses939302ageneses
agenesia945982agenesia
agenesias1045362agenesias
centesis1058142centesis
digenesis1145332digenesis
ecesis84611202_ecesis
emesis84712622_emesis
enosis63816422_enosis
geests75912162ge_ests
generic101310752generic
generics11118792generics
genes65133092gene__s
genetic101211782genetic
genetics11128612genetics
genets75716662gene_ts
genevas1185252genevas
genuses83510882genuses
gneiss765952g_neiss
gnosis75711212g_nosis
kenosis11369002kenosis
kinesis11259592kinesis
nemesis937372nemesis
oogenesis1046072oogenesis
renests74014212renests
senseis73310642senseis
synesis1039162synesis
telesis7310792telesis
adenosis946343adenosis
aeneous739893aeneous
aeneus61111143aene_us
agedness1036683agednes_s
ageless8310343ageles_s
agenes74720253agene__s
agenetic1138203agenetic
amnesia938293amnesia
amnesias1047833amnesias
amnesic1137183amnesic
amnesics1255283amnesics
anagenesis1145373anagenesis
aphesis12610513aphesis
ascesis938373ascesis
askesis1136123askesis
auxesis1445443auxesis
behests1235953behests
bejesus1643693bejesus
benefic1446043benefic
benefit1248073benefit
benefits1345713benefits
benes75536233bene__s
bennis84314803ben_nis
biogenesis1345413biogenesis
censers94313903censers
censes83721803cen_ses
census84310303cen_sus
centeses1079443centeses
cyesis1148573_cyesis
denes65639723dene__s
detests83711743detests
devests114410473devests
diagenesis1244583diagenesis
dieresis956853dieresis
diesis74013493_diesis
digeneses1147393digeneses
dueness82310123duenes_s
dysgenesis1553103dysgenesis
ecesic10369223_ecesic
egests74411253_egests
egress73310433egres_s
elemis8312383_elemis
emeses86114963_emeses
enemas8812003_enemas
enemies9313693_enemies
ennuis636473_ennuis
enokis103010273_enokis
entasis73012573_entasis
enuresis845493_enuresis
envois988703_envois
epigenesis1344733epigenesis
exegesis1643643exegesis
fewness1335003fewnes_s
feyness1334923feynes_s
gameness112810693gamenes_s
ganefs10489203gane_fs
ganevs10456913gane_vs
gaposis1038423gaposis
gayness1136843gaynes_s
geeks104915843ge_e_ks
gees55647883ge_e__s
geese64316003ge_es_e
geest64829613ge_es_t
gelatis83313513gelatis
gelees74116263gele_es
genders93616783genders
gene56237223gene___
genera71211713gene_ra
general81010933general
generals9109333generals
generous939773generous
genet66038683gene__t
genette838863genette
genettes938303genettes
geneva1085853gene_va
genic85119393gen__ic
genie66124923gen__ie
genies75324943gen_ies
genii64514173gen__ii
genip84415203gen__ip
genips9469943gen_ips
genius74512923gen_ius
geniuses935933geniuses
genoas74013623gen_oas
genoise839423genoise
genoises939253genoises
genomes103611703genomes
genomic1237923genomic
genomics1345713genomics
genoms94412483gen_oms
genres75515623gen_res
genros74211333gen_ros
gens55740073gen___s
genseng933983genseng
gensengs1043093gensengs
gentes75324163gen_tes
gentil74115123gen_til
gentles83714343gentles
gentoos838633gentoos
gentries91315263gentries
gents65729613gen__ts
genus65319833gen__us
geodesic1243563geodesic
geodesics1342843geodesics
geodesies1144593geodesies
geodesist1183823geodesist
gerents82612923gerents
gesneria944053gesneria
gests66028813g__ests
geysers1135703geysers
gingelis10247093gingelis
glegness1034613glegnes_s
gnoses76515163g_noses
gonefs10439873gone_fs
goneness9310763gonenes_s
goners74420173gone_rs
greyness1235243greynes_s
guess64213363g_ues_s
guests74311203g_uests
gunless8299633gunles_s
gunsels8338133gunsels
gynecia1384233gynecia
gynecic1584353gynecic
heresies11312693heresies
hugeness1237373hugenes_s
joneses1438963joneses
ketosis11429733ketosis
kineses113111253kineses
kinesic13257023kinesic
kinesics14286283kinesics
kneesies1245543kneesies
lenes54738523lene__s
lenis56326863len__is
lenses64620893len_ses
meiosis939023meiosis
mensas85115853men_sas
menses84222453men_ses
merisis93213173merisis
mimesis1137323mimesis
nemeses948663nemeses
nenes55329673nene__s
nereis6315343nere_is
ness45526563__nes_s
nests55728003__nests
newness1035703newnes_s
noesis6311443_noesis
oneness7512143onenes_s
oogeneses1047853oogeneses
orogenesis1146363orogenesis
pangenesis1345813pangenesis
paresis93315093paresis
penes75839223pene__s
penis75129323pen__is
penises9318193penises
pennis84315743pen_nis
pensees9311203pensees
pensil83013333pen_sil
pensils92811593pen_sils
pheresis1377633pheresis
recess8314263reces_s
redness82012443rednes_s
reests64618893re_ests
reneges82513593reneges
renest64529713renes_t
renews93811753rene_ws
renvois1036503renvois
retests73813853retests
revests104413733revests
sageness92111983sagenes_s
sanseis73011603sanseis
senecas939013senecas
senecio947203senecio
senecios1046303senecios
senegas837253senegas
sensei64712593sensei_
senses63923943sen_ses
sepsis83011293se_psis
stenosis847993stenosis
syndesis1245733syndesis
teleses7313123teleses
tenesmic1244303tenesmic
tenesmus1043453tenesmus
tenets65518953tene_ts
teniasis846063teniasis
tennis64015303ten_nis
tenses64722553ten_ses
tenuis64213083ten_uis
thesis94913733_thesis
tmesis8529793_tmesis
veneers103710293veneers
venenes102712133venenes
veneries112815033veneries
venuses103111413venuses
waeness102512783waenes_s
wetness10277723wetnes_s
woeness1020211543woenes_s
xerosis14249663xerosis

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.1561145455.1
2DLD Change Limit1340272276.62320236.6
3Display Results2272270.0802837.5
 (SQL Overall)1786912276.85926052.0
 
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.