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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

138 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
stretch123641(None) 
stretchy1644081stretchy
restretch1473872restretch
retch104818302__retch
scratch1446012scratch
screech1435222screech
sketch1535362s_ketch
stench114111162st_ench
stitch11419102st_itch
strath93216372strat_h
stretched1546212stretched
stretcher1446292stretcher
stretches1438292stretches
stretta737292stretta
strette7310762strette
stretti747912stretti
stretto737732stretto
trench114211612_trench
wretch14326532_wretch
atretic9313923atretic
breach134213723_breach
breech13348263_breech
cratch134110793_cratch
crotch133410083_crotch
crutch13408243_crutch
dreich12377723_dreich
drench12369593_drench
entrench13115723entrench
etch95419143___etch
fetch134913473__fetch
fletch14388193_fletch
french143511213_french
grutch12285563_grutch
intrench1396593intrench
ketch144912023__ketch
kvetch1832993_kvetch
letch105215803__letch
ostrich1238663ostr_ich
outreach1346003outreach
outstretch1551713outstretch
preach133613923_preach
ratch104221363__ratch
reach105123883__reach
retrench1346283retrench
rotch105815933__rotch
samech13277033same_ch
scootch1434463scootch
scotch13207523s_cotch
scraich1436763scraich
scratchy1843653scratchy
screechy1842773screechy
scrooch1444963scrooch
scrootch1542813scrootch
scrunch1444033scrunch
scultch1483543scultch
scutch13247083s_cutch
sheuch14267043s_heuch
sketchy1943053s_ketchy
skreegh15182643skreegh
skreigh15243703skreigh
slatch114510533s_latch
smutch13205843s_mutch
snatch114310603s_natch
snitch11357943s_nitch
speech1347563s_peech
splotch1442853splotch
squelch2152953squelch
stanch113812373st_anch
starch113013203st_arch
starets73515923staret_s
staunch1244273staunch
stenchy15256213st_enchy
steric8317063steric_
stertor7310093stertor
stet45947323st_et__
stets55423913st_et_s
stich104117923st__ich
stomach1436033stomach
strata63616283strat_a
stratal72710603stratal
stratas73013583stratas
straths102711723straths
strati63518903strat_i
stratum9318253stratum
stratus73011733stratus
streak104613623stre_ak
streaks114411273streaks
streaky14447813streaky
stream84717293stre_am
streams94713373streams
streamy12509483streamy
streek104111413stre_ek
streeks11378713streeks
streel64214023stre_el
streels73811343streels
street64125773stre_et
streetcar1152463streetcar
streets73312613streets
strength1244433strength
strep77120853stre__p
streps86218063stre_ps
stress66616673stre_ss
stretchers1545173stretchers
stretchier1544483stretchier
stretching1645813stretching
strettas846423strettas
strettos847113strettos
strew89220663stre__w
strewed115811343strewed
strewer104310413strewer
strewn96710013stre_wn
strews96817103stre_ws
strick124813203str_ick
strict84821043str_ict
struck12489263str_uck
strut56030733strut__
struts65616803strut_s
surety93515013suret_y
swatch14549283s_watch
switch14458913s_witch
syrette1037183syrette
teach105221123_t_each
tech95925443_t_e_ch
teeth87315853_teet_h
tench105620003_t_ench
tetchy1436003_t_etchy
teth76327893_t_et_h
teuch105214853_t_euch
thatch1435613_thatch
trefah1235093_trefah
tret46653533_tret__
trets55928023_tret_s
troth85622203_trot_h
truth85214153_trut_h
twitch14406163_twitch
upreach1444693upreach
vetch134411843__vetch
wrench14439353_wrench

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271387.25018486.5
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.70223200.6
 
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.