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

128 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
agenesis93804(None) 
ageneses939301ageneses
agenesia945981agenesia
agenesias1045361agenesias
genesis82510821_genesis
adenosis946342adenosis
agedness1036682agednes_s
ageless8310342ageles_s
agenes74720252agene__s
agenetic1138202agenetic
anagenesis1145372anagenesis
diagenesis1244582diagenesis
digenesis1145332digenesis
geneses82613522_geneses
oogenesis1046072oogenesis
pangenesis1345812pangenesis
sageness92111982sagenes_s
abiogenesis1454343abiogenesis
adenitis947433adenitis
adenoses947903adenoses
aeneous739893a_eneous
aeneus61111143a_ene_us
agednesses1237413agednesses
ageisms1056603age_isms
ageists848493age_ists
agencies1138743agencies
agendas936933agen_das
agendums1243443agendums
agene65621583agene___
agenizes18269743agenizes
agentries1048233agentries
agents74816293agen__ts
aggress935593aggres_s
agileness1046493agilenes_s
agnosia837643ag_nosia
agnosias947243ag_nosias
agones75719863agone__s
agonises92613163agonises
agonists9289833agonists
akenes104817343akene__s
akinesia1284073akinesia
akinesias1383903akinesias
amnesia938293a_mnesia
amnesias1047833a_mnesias
amnesic1137183a_mnesic
amnesics1255283a_mnesics
anageneses1145593anageneses
anamnesis1144023anamnesis
anemosis10148073anemosis
anthesis11312503anthesis
anuresis846963anuresis
apheresis1475333apheresis
aphesis12610513a_phesis
aptness9268573aptnes_s
arenes64928393arene__s
ascesis938373a_scesis
asepsis985903ase_psis
askesis1136123a_skesis
auxesis1445443a_uxesis
avenses1049643aven_ses
aweless1038723aweles_s
bareness10912813barenes_s
baseness10910943basenes_s
biogenesis1345413biogenesis
cageyness1543483cageynes_s
caginess11310303cagines_s
centesis1058143_centesis
diageneses1245583diageneses
dieresis956853dieresis
digeneses1147393digeneses
dueness82310123duenes_s
dysgenesis1553103dysgenesis
eagerness1046263eagernes_s
ecesis84611203__ecesis
emesis84712623__emesis
enosis63816423__enosis
epigenesis1344733epigenesis
exegesis1643643exegesis
gameness112810693gamenes_s
gayness1136843gaynes_s
geests75912163_ge_ests
generic101310753_generic
generics11118793_generics
genes65133093_gene__s
genetic101211783_genetic
genetics11128613_genetics
genets75716663_gene_ts
genevas1185253_genevas
genuses83510883_genuses
gneiss765953_g_neiss
gnosis75711213_g_nosis
haleness11312623halenes_s
hugeness1237373hugenes_s
kenosis11369003_kenosis
kinesis11259593_kinesis
lameness102612673lamenes_s
largeness1038273largenes_s
lateness82614073latenes_s
magnesia1145723mag_nesia
magnesias1245693mag_nesias
magnesic1345753mag_nesic
maleness10312313malenes_s
metagenesis14225223metagenesis
mutagenesis14233883mutagenesis
nemesis937373_nemesis
oneness7512143onenes_s
oogeneses1047853oogeneses
orogenesis1146363orogenesis
paleness10312983palenes_s
pangeneses1346373pangeneses
paragenesis1455903paragenesis
pheresis1377633pheresis
rareness81112853rarenes_s
renests74014213_renests
safeness11239633safenes_s
sagenesses11510823sagenesses
sameness102712683samenes_s
saneness82313723sanenes_s
senseis73310643_senseis
stenosis847993stenosis
synesis1039163_synesis
tameness102411253tamenes_s
telesis7310793_telesis
vaginosis1343573vaginosis
vagueness1343933vaguenes_s
waeness102512783waenes_s
wageless1237173wageles_s
woeness1020211543woenes_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621286.75021653.6
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.21924752.9
 
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.