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

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

59 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
androgenesis148415(None) 
androgeneses1464321androgeneses
androgenetic1663632androgenetic
angiogenesis14103672angiogenesis
abiogenesis1454343a_biogenesis
anagenesis1145373an__agenesis
androgenic1455213androgen__ic
androgens1145253androgen___s
androgynes1552703androgyne__s
angiogeneses14123733angiogeneses
atherogenesis1763463atherogenesis
oncogenesis1454463on_cogenesis
ontogenesis1255423on_togenesis
orogenesis1146363__orogenesis
paedogenesis16104413paed_ogenesis
pedogenesis15115223ped_ogenesis
petrogenesis1555553petrogenesis
sporogenesis1554313sporogenesis
abiogeneses1454724a_biogeneses
adroitness1153054a_droitnes_s
agenesis938044a____genesis
anageneses1145594an__ageneses
androcentric1762714androcentric
androgen1046314androgen____
androgyne1452394androgyne___
androgynies1652084androgyn_ies
androgynous1661744androgyn_ous
atherogeneses1753774atherogeneses
averageness1555034averagenes_s
biogenesis1345414__biogenesis
cladogenesis1653004cladogenesis
cyanogenesis1853654cyanogenesis
cyclogenesis20124054cyclogenesis
diagenesis1244584__diagenesis
digenesis1145334__d_igenesis
dysgenesis1553104__dysgenesis
embryogenesis2162024embryogenesis
gametogenesis1793054gametogenesis
glycogenesis19103394glycogenesis
gynogenesis16124554_gynogenesis
handsomeness1853044handsomenes_s
histogenesis1653414histogenesis
hydrogenases20104604hydrogenases
ketogenesis1655014_ketogenesis
lipogenesis1454084_lipogenesis
monogenesis1445884_monogenesis
oncogeneses1465134on_cogeneses
ontogeneses1255874on_togeneses
oogenesis1046074___oogenesis
orogeneses1147864__orogeneses
orthogenesis1685034orthogenesis
osteogenesis1354454osteogenesis
paedogeneses16114354paed_ogeneses
pangenesis1345814pan___genesis
paragenesis1455904_paragenesis
pathogenesis1854974pathogenesis
pedogeneses1595334ped_ogeneses
petrogeneses1565444petrogeneses
sporogeneses1554854sporogeneses

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 Filter1786911247900.1731032896.0
2DLD Change Limit124790598.87314064.0
3Display Results59590.0331787.9
 (SQL Overall)178691599.07919681.8
 
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.