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

190 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
ageneses93930(None) 
agenesis938041agenesis
geneses82613521_geneses
adenoses947902adenoses
agedness1036682agednes_s
agednesses1237412agednesses
ageless8310342ageles_s
agencies1138742agencies
agenes74720252agen__es
agenesia945982agenesia
agenesias1045362agenesias
agenizes18269742agenizes
agonises92613162agonises
anageneses1145592anageneses
avenses1049642aven_ses
diageneses1245582diageneses
digeneses1147392digeneses
genesis82510822_genesis
genuses83510882_genuses
oogeneses1047852oogeneses
pangeneses1346372pangeneses
sageness92111982sagenes_s
sagenesses11510822sagenesses
abiogeneses1454723abiogeneses
adenines9310193adenines
adenosis946343adenosis
adonises92611433adonises
aegises8311373a_egises
aeneous739893a_eneous
aeneus61111143a_ene_us
agametes1147293agametes
agaroses938823agaroses
ageisms1056603age_isms
ageists848493age_ists
agemates111110023agemates
agendas936933agen_das
agendums1243443agendums
agene65621583agen__e_
agenetic1138203agenetic
agenize172910153agenize_
agenized19257733agenized
agented939423agen_ted
agentives1346443agentives
agentries1048233agentries
agents74816293agen__ts
aggress935593aggres_s
aggresses1146143aggresses
agileness1046493agilenes_s
agilenesses1247753agilenesses
agnates82813183ag_nates
agnizes17328843ag_nizes
agones75719863agon__es
agonies83016623agon_ies
agonise83112693agonise_
agonised10248483agonised
agonistes10266263agonistes
agonists9289833agonists
agonizes182610583agonizes
agrees74915323ag_re_es
akenes104817343aken__es
alienees8118653aliene_es
anagenesis1145373anagenesis
anamneses1144613anamneses
aneles64626293a__neles
anemoses10159433anemoses
angeluses1045243angeluses
anises64826693a__nises
annexes1437203a_nnexes
antheses11311473antheses
anureses837973anureses
anuses66218773a__nuses
aphereses1466423aphereses
apheses12610703a_pheses
aptness9268573aptnes_s
aptnesses11168993aptnesses
arenes64928393aren__es
arenites8917103arenites
arenose7311373arenose_
arginases1046373arginases
asceses938623a_sceses
asepses946363ase_pses
askeses1136463a_skeses
auxeses1435623a_uxeses
avenges1157543aven_ges
avenues1057183aven_ues
aweless1038723aweles_s
axonemes1744333axonemes
bareness10912813barenes_s
barenesses12311693barenesses
baseness10910943basenes_s
basenesses12310553basenesses
biogeneses1346013biogeneses
cageyness1543483cageynes_s
cageynesses1743873cageynesses
caginess11310303cagines_s
caginesses13310933caginesses
censes83721803_cen_ses
centeses1079443_centeses
cheeses123613103che_eses
creeses93914623cre_eses
diagenesis1244583diagenesis
diereses938693diereses
digenesis1145333digenesis
dueness82310123duenes_s
duenesses1039323duenesses
dysgeneses1542893dysgeneses
eagerness1046263eagernes_s
eagernesses1246973eagernesses
emeses86114963__emeses
epigeneses1345293epigeneses
exegeses1644213exegeses
flenses1039473flen_ses
gameness112810693gamenes_s
gamenesses1368983gamenesses
gayness1136843gaynes_s
gaynesses1336563gaynesses
geese64316003_ge_ese_
geests75912163_ge_ests
gelees74116263_gele_es
genes65133093_gen__es
genets75716663_gene_ts
genettes938303_genettes
genevas1185253_genevas
genies75324943_gen_ies
geniuses935933_geniuses
genoises939253_genoises
genomes103611703_genomes
genres75515623_gen_res
gentes75324163_gen_tes
gentles83714343_gentles
gnoses76515163_g_noses
haleness11312623halenes_s
halenesses13312033halenesses
hugeness1237373hugenes_s
hugenesses1437133hugenesses
joneses1438963_joneses
kineses113111253_kineses
lameness102612673lamenes_s
lamenesses12610563lamenesses
largeness1038273largenes_s
largenesses1247553largenesses
lateness82614073latenes_s
latenesses10413353latenesses
lenses64620893_len_ses
maleness10312313malenes_s
malenesses12312203malenesses
manganeses1345023manganeses
menses84222453_men_ses
metageneses14125193metageneses
mutageneses14163993mutageneses
nemeses948663_nemeses
oneness7512143onenes_s
onenesses9311823onenesses
oogenesis1046063oogenesis
orogeneses1147863orogeneses
paganises1239723paganises
paleness10312983palenes_s
palenesses12312653palenesses
pangenesis1345813pangenesis
parageneses1446203parageneses
penises9318193_penises
pensees9311203_pensees
phereses1348093phereses
rareness81112853rarenes_s
rarenesses10313093rarenesses
reneges82513593_reneges
renests74014213_renests
safeness11239633safenes_s
safenesses1349373safenesses
sameness102712683samenes_s
samenesses12410853samenesses
saneness82313723sanenes_s
sanenesses10412693sanenesses
senses63923943_sen_ses
spenses92913573spen_ses
stenoses8310443stenoses
tameness102411253tamenes_s
tamenesses1259963tamenesses
teleses7313123_teleses
tenses64722553_ten_ses
vaginoses1344143vaginoses
vagueness1343933vaguenes_s
vaguenesses1544813vaguenesses
venenes102712133_venenes
venuses103111413_venuses
waeness102512783waenes_s
waenesses1239773waenesses
wageless1237173wageles_s
woeness1020211543woenes_s
woenesses1239133woenesses

Search took 9 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.1561145455.1
2DLD Change Limit1461621908.65616885.6
3Display Results1901900.0762500.0
 (SQL Overall)1786911908.88820104.7
 
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.