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

165 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
sketched183539(None) 
sketcher1735431sketcher
sketches1746821sketches
etched123613702__etched
fetched163710472_fetched
fletched17306692fletched
ketches164012192_ketches
kvetched2142782kvetched
letched133912052_letched
resketched2042312resketched
retched133814272_retched
scotched16187932scotched
scutched16186892scutched
seethed113410192seet_hed
sketch1535362sketch__
sketchers1834512sketchers
sketchier1853412sketchier
sketchpad2161362sketchpad
sketchy1943052sketch_y
smutched16165922smutched
snatched14157632snatched
snitched14166862snitched
stitched14148202stitched
stretched1546212stretched
switched17157132switched
tetched133010772_tetched
wretched17276532wretched
batched154114243_batched
beached154516553_beached
belched154011843_belched
benched154713943_benched
bitched153212923_bitched
bleached16378563bleached
blenched16358053blenched
blotched1635653blotched
botched153611903_botched
breached163411643breached
breeched16337383breeched
clenched16257763clenched
clutched16356033clutched
crotched16428593crotched
crutched16307463crutched
detached1537733_detached
ditched143711903_ditched
drenched15247913drenched
eched116919223__e_ched
etcher113912943__etcher
etches114217763__etches
fetcher153510393_fetcher
fetches153413893_fetches
fleeched17345823fleeched
flenched17267963flenched
fletcher16306663fletcher
fletches16308853fletches
flitched17256293flitched
frenched17299433frenched
grutched15284673grutched
hatched163414463_hatched
hitched163312253_hitched
hotched163610923_hotched
hutched16359883_hutched
itched123812023__itched
kecked125113173_ke_cked
kenches163912273_kenches
ketch144912023_ketch__
ketchup1842783_ketchup
kitchen16287683_kitchen
kithed144613013_kit_hed
kvetcher2052813kvetcher
kvetches2053583kvetches
kythed17407313_kyt_hed
latched133914073_latched
leached133715043_leached
leched123716003_le_ched
leeched13369503_leeched
letches124015483_letches
matched153513963_matched
notched134210303_notched
patched153514623_patched
peached154315883_peached
peched144915343_pe_ched
perched154713243_perched
pitched153512923_pitched
pleached16338063pleached
preached163412063preached
quenched2334103quenched
reached134619083_reached
resketches1942963resketches
retches123318513_retches
satchel123310303s_atchel
scathed134012643scat_hed
scooched16206683scooched
scootched1763963scootched
scorched16187203scorched
scotches15179473scotches
scratched1735393scratched
screeched17114343screeched
scutcher15176963scutcher
scutches15168883scutches
scythed16385303scyt_hed
searched14209253searched
seethe93712483seet_he_
seethes103613743seet_hes
seiche11811833s_eiche_
seiches12513813s_eiches
settled83210873s_ettled
sheathed1547223sheathed
skated114414883skat__ed
skeed105018983ske___ed
skeined1236773ske_ined
skelped1435203ske_lped
skeltered1443873skeltered
sketchiest1943163sketchiest
sketchily2142333sketchily
sketching1935083sketching
sketchpads2261183sketchpads
skewed145610233ske__wed
skewered1634213skewered
skited114313483skit__ed
skreeghed1841693skreeghed
skreighed1842453skreighed
slatches131511533slatches
sleighed1334033sleighed
sleuthed1233813sleuthed
slouched14206743slouched
smirched1634673smirched
smooched16185983smooched
smutches15177273smutches
snatcher13167763snatcher
snatches131410713snatches
snitcher13157373snitcher
snitches13148983snitches
soothed113712743soot_hed
southed114313993sout_hed
spathed134013183spat_hed
specced14266703spe_cced
specked16329013spe_cked
speeches1537413speeches
splotched1742823splotched
squelched2442593squelched
stanched14208903stanched
starched14199313starched
stenches132110293stenches
stetted82610403stet_ted
stitcher13168393stitcher
stitches131410593stitches
stretcher1446293stretcher
stretches1438293stretches
swatches16169963swatches
swathed144611933swat_hed
switcher16177683switcher
switches16159133switches
synched16277213s_ynched
teched124014433_te_ched
teethed11318623teet_hed
thatched1735433thatched
trenched14289853trenched
twitched17155033twitched
vetches153411263_vetches
watched163012823_watched
welched16298833_welched
wenched163910913_wenched
witched163012193_witched
wrenched17748133wrenched
wretches16257283wretches

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621656.51322441.6
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.99925530.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.