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

210 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
sketches174682(None) 
ketches164012191_ketches
sketched1835391sketched
sketcher1735431sketcher
sketchers1834511sketchers
etches114217762__etches
fetches153413892_fetches
fletches16308852fletches
kenches163912272_kenches
kvetches2053582kvetches
letches124015482_letches
resketches1942962resketches
retches123318512_retches
scotches15179472scotches
scutches15168882scutches
seethes103613742seet_hes
seiches12513812s_eiches
sketch1535362sketch__
sketchier1853412sketchier
sketchiest1943162sketchiest
sketchy1943052sketch_y
slatches131511522slatches
smutches15177272smutches
snatches131410712snatches
snitches13148982snitches
speeches1537412speeches
stenches132110292stenches
stitches131410592stitches
stretches1438292stretches
swatches16169962swatches
switches16159132switches
vetches153411262_vetches
wretches16257282wretches
aitches123014363_aitches
batches144019613_batches
beaches144120653_beaches
beeches143413883_beeches
belches143514343_belches
benches143918603_benches
bitches144117063_bitches
bleaches153410673bleaches
blenches153310763blenches
blotches1537433blotches
botches143716023_botches
breaches153714123breaches
breeches15258673breeches
britches15278683britches
butches144315363_butches
catches144320773_catches
clenches152910953clenches
clutches15307923clutches
cratches153012543cratches
creches14313093cre_ches
crotches153411303crotches
crutches15359593crutches
cultches15316533cultches
cutches143216463_cutches
detaches1439653_detaches
ditches133215713_ditches
drenches14309803drenches
eches106322163__e_ches
etched123613703__etched
etcher113912943__etcher
etchers123411293__etchers
fetched163710473_fetched
fetcher153510393_fetcher
fetchers16328863_fetchers
fetiches1636953_fetiches
fitches153516193_fitches
fleches153411443fle_ches
fleeches16287083fleeches
flenches163410533flenches
fletched17306693fletched
fletcher16306663fletcher
fletchers17335533fletchers
flitches16388463flitches
frenches163311633frenches
glitches14296653glitches
grutches14285853grutches
hatches153420273_hatches
hitches153616273_hitches
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
itches114916213__itches
ketch144912023_ketch__
ketchup1842783_ketchup
ketchups1941893_ketchups
ketenes114813503_ketenes
ketones115014503_ketones
ketoses114912873_ketoses
kettles113411613_kettles
kitchen16287683_kitchen
kitchens17195783_kitchens
kithes135016653_kit_hes
kitsches1734073_kitsches
klatches17157133klatches
kvetched2142783kvetched
kvetcher2052813kvetcher
kvetchers2142373kvetchers
kythes16499133_kyt_hes
latches123320123_latches
leaches123319343_leaches
leches115421313_le_ches
leeches123911933_leeches
letched133912053_letched
lethes94818083_let_hes
matches143219783_matches
merches144013763_merches
mutches143314283_mutches
nautches1336083nautches
notches123513653_notches
patches143320383_patches
peaches144120053_peaches
perches143717953_perches
pitches143617753_pitches
pleaches153210433pleaches
plenches153110623plenches
preaches153214893preaches
quenches2236013quenches
quitches2236193quitches
ratches123620463_ratches
reaches123423203_reaches
resketched2042313resketched
retched133814273_retched
rotches123515703_rotches
satchel123310303s_atchel
satchels13328163s_atchels
scathes124515713scat_hes
scooches15188413scooches
scootches1635003scootches
scorches15189143scorches
scotched16187933scotched
scratches1647323scratches
screeches1695653screeches
sculches15176273sculches
scultches1664293scultches
scutched16186893scutched
scutcher15176963scutcher
scutchers16175643scutchers
scythes15356523scyt_hes
searches132112903searches
seethe93712483seet_he_
seethed113410193seet_hed
seiche11811833s_eiche_
settees73513633s_ettees
settles73916003s_ettles
seviches1635803seviches
sheathes14610193sheathes
sheuchs15234933sheuch_s
skates104219403skat__es
skatoles1236143skatoles
skeanes113610713ske_anes
skees95023123ske___es
skenes104616633ske__nes
skerries12168673skerries
sketchily2142333sketchily
sketchiness2052173sketchiness
sketching1935083sketching
sketchpad2161363sketchpad
sketchpads2261183sketchpads
skites104418043skit__es
skittles1245763skittles
skoshes14246253sk_oshes
slouches13208073slouches
smirches1535993smirches
smooches15217263smooches
smutched16165923smutched
snatched14157633snatched
snatcher13167763snatcher
snatchers14146313snatchers
snathes104816493snat_hes
sneeshes1136513sneeshes
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
soothes103917113soot_hes
soroches1338803soroches
soutaches1446443soutaches
spathes125116533spat_hes
species11314133spe_cies
spectres12268683spectres
spences113413923spenc_es
splotches1643913splotches
squelches2343363squelches
stanches132312793stanches
starches131912913starches
stitched14148203stitched
stitcher13168393stitcher
stitchers14147013stitchers
stretched1546213stretched
stretcher1446293stretcher
stretchers1545173stretchers
swathes134115513swat_hes
switched17157133switched
switcher16177683switcher
switchers17146633switchers
teaches122718353_teaches
teethes103611653teet_hes
tenches123515523_tenches
tetched133010773_tetched
thatches1637513thatches
trenches133512603trenches
twitches16156373twitches
watches153017373_watches
welches153710313_welches
wenches152914133_wenches
witches152715793_witches
wrenches163210233wrenches
wretched17276533wretched

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622107.48619524.7
3Display Results2102100.0762763.2
 (SQL Overall)1786912107.98222386.7
 
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.