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

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

53 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
heteroses1241077(None) 
heterosis1258811heterosis
heterolyses1755192heterolyses
heteros10312682hetero__s
arthroses1248713arthroses
deterges101510083deter_ges
dethrones1347313dethrones
dextroses1745663dextroses
eroses65327053___eroses
esterases949623esterases
eternises9119453_eternises
ethnoses1146063_ethnoses
ethoses10311753_et_hoses
hearses104414533he_ar_ses
heiresses1236963heiresses
hematoses1448443hematoses
heptoses1338373he_ptoses
heroes94923823h__ero_es
hetaerisms1544883hetaerisms
hetero9312633hetero___
heterocyst1854463heterocyst
heterocysts1953733heterocysts
heterodox2053883heterodox
heterodynes18134163heterodynes
heterogeny1754333heterogeny
heterolysis1754933heterolysis
heteronym1774293heteronym
heteronyms1874233heteronyms
heterotic1449023heterotic
hexoses17228883h__exoses
hidroses1237903h_idroses
hyperopes1947503hyperopes
hystereses1643803hystereses
icteruses1144963icteruses
interposes12410563interposes
ketoses114912873ket__oses
meterages1248173meterages
necroses10310563ne_croses
nephroses1446303nephroses
neuroses8310153ne_uroses
osteoses839033oste_oses
petasoses1145443petasoses
reredoses1045773reredoses
reverses112513513rever_ses
rezeroes1737143rezero_es
scleroses1146373scleroses
selenoses947463selenoses
sideroses1047353sideroses
stenoses8310443_stenoses
tetrodes939073tet_rodes
tuberoses1195363tuberoses
uteruses837183_uteruses
xeroses143612823__xeroses

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 Filter1786911486410.296603685.8
2DLD Change Limit148641538.56317358.5
3Display Results53530.0301766.7
 (SQL Overall)178691538.88920102.5
 
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.