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

72 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
stretching164581(None) 
restretching1852892restretching
retching143412172__retching
scratching1844532scratching
screeching1843642screeching
sketching1935082s_ketching
stitching1547102st_itching
stretchering1852452stretchering
stretchier1544482stretchier
trenching15227652_trenching
breaching17269403_breaching
breeching17236473_breeching
crutching17216073_crutching
drenching16256033_drenching
entrenching1743353entrenching
etching134511843___etching
fetching17298413__fetching
fletching18256143_fletching
frenching18267753_frenching
grutching16224373_grutching
intrenching1744073intrenching
kvetching2242903_kvetching
letching143810263__letching
outreaching1744913outreaching
outstretching1961153outstretching
preaching172811163_preaching
reaching143317203__reaching
retrenching1743923retrenching
scootching1843363scootching
scotching1735653s_cotching
scraiching1843793scraiching
scrooching1843323scrooching
scrootching1951893scrootching
scrunching18163473scrunching
scutching1735223s_cutching
seething1239023s_eet_hing
skreeghing1941483skreeghing
skreighing1942303skreighing
smutching1734853s_mutching
snatching1536363s_natching
snitching1535913s_nitching
something1545403somet_hing
splotching1842863splotching
squelching2542233squelching
stanching1538083st_anching
starching1538593st_arching
staunching1643213staunching
stetting93410713st_et_ting
stomaching1844313stomaching
streaking142010323stre_aking
streaming12239653stre_aming
streeking14217453stre_eking
streeling10189483stre_eling
stressing1038333stre_ssing
stretch1236413stretch___
stretched1546213stretch_ed
stretcher1446293stretch_er
stretchers1545173stretchers
stretches1438293stretch_es
stretchiest1644203stretchiest
stretchy1644083stretch__y
strewing12289853stre__wing
strutting1037003strut_ting
switching1835703s_witching
teaching143612603_t_eaching
teething1237163_teet_hing
thatching1835143_thatching
trithing122811773_trit_hing
trothing122410843_trot_hing
twitching1834243_twitching
upreaching1844113upreaching
wrenching18276273_wrenching

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 Filter1786911406030.423422437.4
2DLD Change Limit140603726.68621029.5
3Display Results72720.0302400.0
 (SQL Overall)178691727.13925030.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.