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

40 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
leukaemogenesis2271281leukaemogenesis_
leukaemogeneses2271212leukaemogeneses_
leukemogenesis21121832leuk_emogenesis_
leukemogeneses21121913leuk_emogeneses_
leukemogenic2161485leuk_emogen__i_c
ketogenesis1655016___k_etogenesis_
melanogenesis1663266me_la_nogenesis_
paedogenesis16104416___paedogenesis_
teratogenesis1453446te_ra_togenesis_
abiogenesis1454347____abiogenesis_
atherogenesis1763467__atherogenesis_
cladogenesis1653007__cla_dogenesis_
cyanogenesis1853657__cya_nogenesis_
electrogenesis1764487_electrogenesis_
embryogenesis2162027_e_mbryogenesis_
eudaemonism1692447_eudaemo__n__ism
eudaemonisms17132267_eudaemo__nisms_
eudaemonist14123107_eudaemo__n__ist
eudaemonists15132447_eudaemo__nists_
gametogenesis1793057__gametogenesis_
gluconeogenesis19261777gluconeogenesis_
ketogeneses1655067___k_etogeneses_
leukaemia1572387leukaem______i_a
leukaemias1672167leukaem______ias
leukopenia1652767leuk___open__i_a
leukopenias1762637leuk___open__ias
leukopoiesis1871817leuk___opoiesis_
lipogenesis1454087l____ipogenesis_
melanogeneses1653397me_la_nogeneses_
metagenesis14225227me_ta___genesis_
mutagenesis14233887_muta___genesis_
organogenesis1562817_orga_nogenesis_
osteogenesis1354457__oste_ogenesis_
paedogeneses16114357___paedogeneses_
parthenogenesis21142217parthenogenesis_
pathogenesis1854987___pathogenesis_
pedogenesis15115227____pedogenesis_
petrogenesis1555577pe___trogenesis_
spermatogenesis2082517sperma_togenesis_
teratogeneses1453917te_ra_togeneses_

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 Filter178691950240.376475242.0
2DLD Change Limit95024407.53012619.4
3Display Results40400.0331212.1
 (SQL Overall)178691407.93922508.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.