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

245 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
clutches1530792(None) 
clutched16356031clutched
crutches15359591crutches
cultches15316531cultches
cutches143216461c_utches
blotches1537432blotches
butches144315362_butches
catches144320772c_atches
churches1846432churches
clenches152910952clenches
cliches144213742cl_iches
clinches153910362clinches
cloches144113712cl_oches
clothes124513812clot_hes
clutch13367752clutch__
clutchy17323892clutch_y
couches144020472cou_ches
cratches153012542cratches
crotches153411302crotches
crunches153711352crunches
crutched16307462crutched
culches143710742c_ulches
curches143512742c_urches
fletches16308852fletches
flitches16388462flitches
glitches14296662glitches
glunches1436262glunches
grutches14285852grutches
hutches153613522_hutches
klatches17157142klatches
latches123320132_latches
letches124015482_letches
lunches124115442_lunches
lurches123311662_lurches
mutches143314282_mutches
nautches1336082nautches
scultches1664292scultches
scutches15168882scutches
slatches131511532slatches
smutches15177272smutches
aitches123014363_aitches
batches144019613_batches
bitches144117063_bitches
blanches153311603blanches
bleaches153410673bleaches
blenches153310763blenches
blotched1635653blotched
blucher143310223blu_cher
bluchers15359033blu_chers
blushes124314823blu_shes
botches143716023_botches
britches15278683britches
brunches153710453brunches
bunches144116033_bunches
butcher143411163_butcher
butchers153710183_butchers
caches137926913c__aches
caleches15269943caleches
caliches153812273caliches
capuches1735513capuches
caroches15710693caroches
catcher143115823c_atcher
catchers153114063c_atchers
ceviches1834843ceviches
chatchkes23174743chatchkes
chinches18369373chinches
churched1934653churched
chutes114615773chut__es
chutnees1343963chutnees
cinches144215773c_inches
clachs133511323cl_ach_s
clashes124017283cl_ashes
clenched16257763clenched
clencher15277973clencher
clenchers16276553clenchers
cliche133712453cl_iche_
cliched153711023cl_iched
clinched16347383clinched
clincher15347663clincher
clinchers16336263clinchers
cloche134312373cl_oche_
clothe114712993clot_he_
clothed134010283clot_hed
cloths115512483clot_h_s
clotures10299023clotures
clucked163810133clu_cked
clucks144512073clu_c_ks
clues74623033clu___es
clutching17154823clutching
clutter94211663clut_ter
clutters103210353clutters
coaches144018693c_oaches
conches144019813c_onches
cooches143515833c_ooches
couched154115793cou_ched
coucher144515853cou_cher
couchers153513863cou_chers
couther123914633cout_her
couthest13312083cout_hest
couths115715413cout_h_s
coutures10311993coutures
cranches153114543cranches
craunches1655723craunches
creches14313093c_reches
crotched16428603crotched
crotchet152711993crotchet
crotchets16396303crotchets
crouches153711293crouches
cruces105117543cru_c_es
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
crushes124215133cru_shes
crutch13408243crutch__
cuishes122810823c_uishes
culices113713123culic_es
cultch13385953cultch__
cultures10310153cultures
cultuses1037753cultuses
cutch125116193c_utch__
cutchery18265173c_utchery
cutes79438323c_ut__es
cuticles1237893c_uticles
cuties84927363c_ut_ies
cutises94414913c_utises
cutties93118843c_utties
cuttles93613923c_uttles
ditches133215713_ditches
douches134315233dou_ches
dunches133312583_dunches
elutes64020313elut__es
etches114217763__etches
fetches153413893_fetches
fitches153516193_fitches
fleches153411443fl_eches
fleeches16287083fleeches
flenches163410533flenches
fletched17306693fletched
fletcher16306663fletcher
fletchers17335533fletchers
flinches16358953flinches
flitched17256293flitched
flushes134114143flu_shes
flutes95421783flut__es
flysches1933123flysches
glunched1544263glunched
glutes74517673glut__es
gouaches1436203gouaches
grutched15284673grutched
gulches13398113_gulches
hatches153420273_hatches
haunches1656963haunches
hitches153616273_hitches
hootches1656973hootches
hotches153814363_hotches
hunches153913463_hunches
hutched16359883_hutched
itches114916213__itches
ketches164012193_ketches
klatsches1842233klatsches
klutzes2064113klut_zes
kvetches2053583kvetches
laches116528353_l_aches
larches124416453_larches
latched133914073_latched
latchet123117913_latchet
latchets133410013_latchets
lathes95127503_lat_hes
launches1387903launches
leaches123319343_leaches
leches115421313_l_eches
leeches123911933_leeches
letched133912053_letched
lethes94818083_let_hes
liches114724293_l_iches
litchis1238373_litchis
loaches123613983_loaches
luces75528433_lu_c_es
lucres84513303_lu_cres
lunched133911823_lunched
luncher123111413_luncher
lunchers13349563_lunchers
lurched13358033_lurched
lurcher12338133_lurcher
lurchers13307153_lurchers
lushes94022743_lu_shes
lutes55836663_lut__es
lutzes153711923_lut_zes
lyches144213613_l_yches
lynches15378873_lynches
matches143219783_matches
mouches143815963mou_ches
muches134718993_mu_ches
mulches143210673_mulches
munches144215793_munches
notches123513653_notches
ouches114322183_ou_ches
patches143320383_patches
paunches1568173paunches
pitches143617753_pitches
planches153111863planches
pleaches153210433pleaches
plenches153110623plenches
plushes124313673plu_shes
pouches144116743pou_ches
punches144816133_punches
putsches1535313_putsches
quiches2139333_quiches
quitches2236193quitches
ratches123620463_ratches
raunches1368053raunches
retches123318513_retches
rotches123515703_rotches
rouches124217893rou_ches
ruches114819583_ru_ches
scootches1635003scootches
scotches15179473scotches
scratches1647323scratches
scrunches1635403scrunches
sculches15176273sculches
scutched16186893scutched
scutcher15176963scutcher
scutchers16175643scutchers
sketches1746823sketches
slouches13208073slouches
sluices959073sluic_es
slushes103514413slu_shes
smutched16165923smutched
snatches131410713snatches
snitches13148983snitches
soutaches1446443soutaches
splotches1643913splotches
stitches131410593stitches
swatches16169963swatches
switches16159133switches
thatches1637513thatches
touches125118343tou_ches
tusches1237903_tusches
twitches16156373twitches
unlatches1444303unlatches
vetches153411263_vetches
vouches153914113vou_ches
watches153017373_watches
witches152715793_witches
wretches16257283wretches

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622458.71616769.4
3Display Results2452450.1102227.3
 (SQL Overall)1786912459.24919320.0
 
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.