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 “spermatogenesisb” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
spermatogenesis2082511spermatogenesis_
spermatogeneses2072602spermatogeneses_
spermiogenesis1962103sperm_iogenesis_
spermatogenic2062744spermatogen__i_c
spermiogeneses1962254sperm_iogeneses_
teratogenesis1453444_ter_atogenesis_
spermatogonia18182635spermatogon__i_a
spermatogonial19161935spermatogon__ial
spermatogonium2171805spermatogon__ium
sporogenesis1554315spor___ogenesis_
steroidogenesis1771655steroidogenesis_
teratogeneses1453915_ter_atogeneses_
dermatogens1552666_dermatogen___s_
frontogenesis1762496__frontogenesis_
gametogenesis1793066__gametogenesis_
ketogenesis1655016_ke___togenesis_
melanogenesis1663266_me_lanogenesis_
operativeness1876666oper_ativenes_s_
organogenesis1562816__organogenesis_
paragenesis1455916_par_a__genesis_
pathogenesis1854996_p___athogenesis_
pedogenesis15115226_pe___dogenesis_
petrogenesis1555586_pe__trogenesis_
prematureness17102576_prematurenes_s_
spermatocytes2262306spermatocyte__s_
sporogeneses1554856spor___ogeneses_
steroidogeneses1771716steroidogeneses_
superlativeness20283946superlativenes_s_
androgenesis1484167andr___ogenesis_
atherogenesis1763467ather___ogenesis_
averageness1555037aver_a__genes_s_
carcinogenesis19143037_carcinogenesis_
cladogenesis1653007___cladogenesis_
cyanogenesis1853657___cyanogenesis_
dermatogen1453007_dermatogen_____
dermatosis1354957_dermato____sis_
desperateness1665197desper_at__enes_s_
electrogenesis1764487ele_ctrogenesis_
embryogenesis2162027__embryogenesis_
frontogeneses1762687__frontogeneses_
gametogeneses1792937__gametogeneses_
hematogenous1862307_he_matogen_ous_
hematopoiesis2061987_he_matopoiesis_
histogenesis1653427___histogenesis_
immunogenesis1863597__immunogenesis_
imperativeness2155477imper_ativenes_s_
ketogeneses1655067_ke___togeneses_
leukaemogenesis2271287_leukaemogenesis_
leukemogenesis21121837_leukemogenesis_
melanogeneses1653397_me_lanogeneses_
metagenesis14225227____metagenesis_
monogenesis1445887____monogenesis_
morphogenesis21153067_mor_phogenesis_
mutagenesis14233887____mutagenesis_
normativeness1855007_normativenes_s_
ontogenesis1255427____ontogenesis_
operativenesses2055777oper_ativenesses
operatorless1461897oper_ato_rles_s_
operoseness1354837oper___osenes_s_
organogeneses1562907__organogeneses_
orogenesis1146367__or___ogenesis_
orthogenesis1685037__or_thogenesis_
osteogenesis1354467oste____ogenesis_
paedogenesis16104417_p__aedogenesis_
pangenesis1345817_p___a_ngenesis_
parageneses1446217_par_a__geneses_
parthenogenesis21142217_parthenogenesis_
pathogeneses1854587_p___athogeneses_
pedogeneses1595337_pe___dogeneses_
peremptoriness2061487_peremptorines_s_
permanentness1761747_permanentnes_s_
pervasiveness2155137_pervasivenes_s_
petrogeneses1565447_pe__trogeneses_
prematurenesses1971957_prematurenesses
psychogenesis2464817_p_sychogenesis_
sedateness1146667s_e_dat__enes_s_
separateness1455507separat__enes_s_
spermacetis1753967sperma____cetis_
spermagonia1653117sperma__gon__i_a
spermagonium1962177sperma__gon__ium
spermatocyte2162447spermatocyte____
spermatophores23152327spermato_phores_
spermatophytes26112327spermato_phytes_
spermatophytic2872067spermato_phyti_c
spermatozoans2661827spermato__zoans_
spermatozoid2662497spermato___zoi_d
spermatozoids2761927spermato___zoids
sportiveness1766987spor__tivenes_s_
strangeness1246107s_tr_a_ngenes_s_
superableness17127527super_a_blenes_s_
teratogenic1453757_ter_atogen__i_c
teratogenicity2071627_ter_atogenicity
teratogens1143557_ter_atogen___s_
versatileness1654017_versatilenes_s_

Search took 10 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 Filter178691950240.360496363.9
2DLD Change Limit95024949.18610344.4
3Display Results94940.0631492.1
 (SQL Overall)178691949.60918596.2
 
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.