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

47 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
heterogeneously2271431heterogeneously_
heterogeneous1763323heterogeneous___
heterogenous1654284heterogen_ous___
heterogeneity2062805heterogene__ity_
heterologously2171395hetero_logously_
homogeneously2261845h__omogeneously_
autogenously1662816aut__ogen_ously_
endogenously1762566_e_ndogen_ously_
erroneously1453446_e_rro__neously_
exogenously2252796___exogen_ously_
heteroecious1763396hetero_ecious___
heterogamous1863806heterog_amous___
heterogeneities1972266heterogene_ities
heterogenies1695566heterogen_ies___
heterogeny1754336heterogen_____y_
overgenerously2171536_over_generously_
ceremoniously2063077ceremo__niously_
coterminously2071937coter_min_ously_
erogenous1046237___erogen_ous___
extraneously2262747_extr__aneously_
hematogenous1862307hematogen_ous___
heterocystous2192367heterocystous___
heterodynes18134167heterodyne__s___
heterogametes1982787heterogametes___
heterogamety2162627heterogame___ty_
heterogonies16104817heterogon_ies___
heterogony1753947heterog___o__ny_
heterologous1653537hetero_logous___
heteronomous1763517hetero_nomous___
heteronomy1854667hetero__n_o__my_
heteropterous1863097heteropterous___
heterosexual2262177hetero__sexual__
heterosexually2771497hetero__sexually
heterosexuals2371887hetero__sexual_s
heterosporous1862367heterosporous___
heterozygous2862797hetero_zygous___
homogeneous1753867h__omogeneous___
horrendously1962017h__or_rendously_
hydrogenous1953957h_ydrogen_ous___
intravenously1962587int_raven_ously_
nitrogenous1253547nit_rogen_ous___
outrageously1662567out_rag__eously_
petrogeneses1565447pet_rogene__s_es
petrogenesis1555567pet_rogene__s_is
strenuously1454187_st_r__enuously_
subterraneously2081387subter_raneously_
tremendously1872157__t_remendously_

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.1261418182.5
2DLD Change Limit95024479.6239874.7
3Display Results47470.0331424.2
 (SQL Overall)178691479.78218267.3
 
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.