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

52 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
undergrowth1914250(None) 
undergrowths20151701undergrowths
intergrowth1852772intergrowth
intergrowths1952123intergrowths
overgrowth2053023_overgrowth
supergrowth2052473supergrowth
undercroft16154963undercroft_
undercrofts17153303undercrofts
underground1452783underground
underwrote1445273underwro_te
antigrowth1762224an_tigrowth
ingrowth1553024in___growth
nongrowth1652574_n_ongrowth
overgrowths2151934_overgrowths
pregrowth1852204_pre_growth
regrowth1544034__re_growth
supergrowths2161784supergrowths
underbrush1652694underbr_ush
undercoat1248734under_coat_
undercoats1346624under_coats
underflow1643944underflow__
underflows1743944underflow_s
underfoot1347034under_foot_
undergirt1147814underg_irt_
undergo937044underg_o___
undergod1136584underg_o__d
undergods1246334underg_o_ds
undergoer1146794underg_o_er
undergoers1245004underg_oers
undergoes1139054underg_o_es
undergoing1347084underg_oing
undergone1158274underg_o_ne
undergrad1245484undergr__ad
undergrads1344794undergr_ads
undergrounds1551974undergrounds
undermost1247964under_most_
underneath1444054under_neath
underplot1246824underplo_t_
underplots1345404underplo_ts
underproof1643574underpro_of
underprop1444354underpro__p
underprops1554414underpro_ps
underrate10411894under_r_ate
undershoot1445104undershoot_
undershoots1553454undershoots
undershorts1543694undershorts
undershot1346894undersho_t_
undertow1266234under_tow__
undertows1366684under_tow_s
undervote1357754under_vo_te
underwrite1446314underwr_ite
upgrowth1741954u___pgrowth

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 Filter1786911488190.406440125.6
2DLD Change Limit148819528.95316622.2
3Display Results52520.0331575.8
 (SQL Overall)178691529.39219025.9
 
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.