Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “clefting” with Change Limit: [1] [2] [3]

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

358 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
clefting	14	34	758	(None)
cleating	11	35	1814	1	cleating
alerting	9	13	1238	2	alerting
bleating	11	35	1450	2	bleating
cheating	14	40	1452	2	cheating
cheffing	20	3	446	2	cheffing
chefing	16	35	903	2	chef_ing
cleaning	11	31	1238	2	cleaning
clearing	11	30	1488	2	clearing
cleaving	14	138	968	2	cleaving
cleeking	15	26	781	2	cleeking
cleping	12	33	1042	2	cle_ping
clerking	15	25	716	2	clerking
clewing	13	35	958	2	cle_wing
clotting	11	31	1064	2	clotting
clouting	11	30	1168	2	clouting
crafting	14	37	1017	2	crafting
creating	11	39	2195	2	creating
cresting	11	40	1704	2	cresting
electing	11	21	1378	2	electing
fleeting	12	29	1032	2	fleeting
gleeting	10	27	917	2	gleeting
hefting	14	45	1091	2	_hefting
leftwing	15	3	297	2	_leftwing
letting	8	32	1853	2	_letting
lifting	11	33	1327	2	_lifting
lofting	11	33	1131	2	_lofting
pleating	11	29	1605	2	pleating
sleeting	9	31	1416	2	sleeting
abetting	11	5	829	3	abetting
accenting	14	8	783	3	accenting
accepting	16	9	582	3	accepting
agenting	10	3	938	3	agenting
averting	12	25	1273	3	averting
beating	10	43	2687	3	_beating
beefing	13	39	1147	3	beef_ing
belting	10	41	1913	3	_belting
besting	10	49	2392	3	_besting
betting	10	39	2140	3	_betting
blasting	11	40	1343	3	blasting
blatting	11	41	1165	3	blatting
blearing	11	31	1194	3	blearing
blebbing	12	26	567	3	blebbing
bleeding	12	35	905	3	bleeding
bleeping	13	37	793	3	bleeping
blending	12	24	996	3	blending
blessing	11	3	759	3	blessing
bloating	11	35	1281	3	bloating
blotting	11	39	1043	3	blotting
bluffing	17	27	549	3	bluffing
blunting	11	31	984	3	blunting
blurting	11	25	877	3	blurting
canting	10	47	2590	3	c_anting
carting	10	42	2828	3	c_arting
caseating	12	3	1174	3	caseating
casefying	18	4	375	3	casefying
casting	10	46	2834	3	c_asting
catting	10	39	2264	3	c_atting
caveating	15	3	929	3	caveating
ceasing	10	41	1826	3	c_easing
ceding	10	40	1480	3	c_e_ding
ceiling	10	34	1672	3	c_eiling
celestine	11	14	794	3	celestine
celling	10	39	2126	3	c_elling
cementing	14	3	876	3	cementing
censing	10	42	1526	3	c_ensing
centring	11	21	1295	3	c_entring
cering	9	45	2253	3	c_e_ring
cessing	10	38	1481	3	c_essing
chaffing	20	3	632	3	chaffing
chafing	16	39	1149	3	chaf_ing
chanting	14	34	1353	3	chanting
charting	14	26	1419	3	charting
chatting	14	28	1014	3	chatting
checking	20	37	920	3	checking
cheeking	18	34	908	3	cheeking
cheeping	16	32	955	3	cheeping
cheering	14	36	1270	3	cheering
cheesing	14	34	941	3	cheesing
chelating	15	4	936	3	chelating
chevying	20	3	405	3	chevying
chewing	16	39	1114	3	che_wing
chuffing	20	5	504	3	chuffing
chuting	13	29	1073	3	c_huting
citing	9	42	2018	3	c__iting
clacking	17	33	1349	3	clacking
cladding	13	3	714	3	cladding
clagging	13	32	888	3	clagging
claiming	13	27	930	3	claiming
clamming	15	32	937	3	clamming
clamping	15	40	1115	3	clamping
clanging	12	40	1212	3	clanging
clanking	15	43	1306	3	clanking
clapping	15	38	1060	3	clapping
clashing	14	38	1219	3	clashing
clasping	13	33	1026	3	clasping
classing	11	32	1179	3	classing
clawing	13	38	1267	3	cl_awing
claying	13	36	1430	3	cl_aying
cleansing	12	3	507	3	cleansing
clearings	12	28	606	3	clearings
clearwing	15	3	367	3	clearwing
cleft	10	62	2285	3	cleft___
clefted	13	32	676	3	cleft_ed
clefts	11	46	1016	3	cleft__s
clenching	17	26	630	3	clenching
clicking	17	36	1098	3	clicking
climbing	15	20	598	3	climbing
cling	8	64	2467	3	cl___ing
clinging	12	29	1091	3	clinging
clinking	15	36	1166	3	clinking
clipping	15	34	915	3	clipping
cliquing	20	3	536	3	cliquing
cloaking	15	29	971	3	cloaking
clocking	17	43	1241	3	clocking
clogging	13	36	850	3	clogging
clomping	15	32	965	3	clomping
cloning	10	32	1547	3	cl_oning
clonking	15	38	1015	3	clonking
clopping	15	35	1108	3	clopping
closeting	12	3	618	3	closeting
closing	10	31	1484	3	cl_osing
clothing	14	27	878	3	clothing
clouding	12	26	949	3	clouding
clouring	11	28	1127	3	clouring
clowning	14	30	725	3	clowning
cloying	13	35	1175	3	cl_oying
clubbing	15	26	651	3	clubbing
clucking	17	42	999	3	clucking
clueing	10	41	1009	3	cl_ueing
cluing	9	39	1350	3	cl__uing
clumping	15	31	988	3	clumping
clunking	15	32	943	3	clunking
coacting	13	34	1270	3	coacting
coapting	13	35	1161	3	coapting
coasting	11	36	1551	3	coasting
coating	10	35	2531	3	c_oating
coediting	13	3	833	3	coediting
coempting	16	3	607	3	coempting
coercing	13	4	900	3	coercing
coffing	16	38	1125	3	c_offing
coffling	17	3	648	3	coffling
coiffing	17	5	593	3	coiffing
coifing	13	32	1389	3	coif_ing
coleading	13	3	852	3	coleading
collating	12	3	1278	3	collating
collecting	15	4	828	3	collecting
colleting	12	3	1106	3	colleting
compting	15	30	1360	3	compting
confuting	15	3	909	3	confuting
coopting	13	34	1131	3	coopting
costing	10	43	2302	3	c_osting
coting	9	46	2925	3	c__oting
counting	11	31	1527	3	counting
courting	11	25	1457	3	courting
coveting	14	19	1231	3	coveting
crating	10	37	2520	3	c_rating
creaking	15	34	1412	3	creaking
creaming	13	34	1314	3	creaming
creasing	11	33	1444	3	creasing
creatin	9	36	1813	3	creatin_
creatine	10	34	1741	3	creatine
creatins	10	36	1751	3	creatins
crediting	13	3	884	3	crediting
creeling	11	35	1336	3	creeling
creeping	13	33	1010	3	creeping
cremating	14	3	1220	3	cremating
creping	12	29	1365	3	cre_ping
crestings	12	29	804	3	crestings
cretin	8	29	1791	3	cre_tin_
cretins	9	32	1642	3	cre_tins
crewing	13	32	1263	3	cre_wing
crusting	11	36	1279	3	crusting
cueing	9	49	1361	3	cue__ing
cuffing	16	32	1025	3	c_uffing
curating	11	3	1429	3	curating
curetting	12	3	657	3	curetting
cutting	10	38	1749	3	c_utting
defying	15	32	882	3	_defying
delating	10	31	1960	3	delating
deleting	10	33	1442	3	deleting
denting	9	44	2218	3	_denting
dieting	9	36	1683	3	die_ting
drafting	13	33	941	3	drafting
drifting	13	33	873	3	drifting
dueting	9	38	1439	3	due_ting
duetting	10	4	718	3	duetting
eating	7	51	3440	3	__eating
egesting	10	3	901	3	egesting
ejecting	18	26	816	3	ejecting
elating	8	34	2308	3	el_ating
elevating	13	3	820	3	elevating
eluting	8	41	1529	3	el_uting
erecting	11	24	1506	3	erecting
everting	12	22	1313	3	everting
exerting	16	22	1115	3	exerting
felting	11	35	1521	3	_felting
feting	10	44	1779	3	_fe_ting
fetting	11	35	1787	3	_fetting
fileting	12	3	930	3	file_ting
flatting	12	35	1125	3	flatting
flecking	18	40	823	3	flecking
fledging	14	27	652	3	fledging
fleecing	14	34	757	3	fleecing
fleeing	11	35	1129	3	fle_eing
fleering	12	38	1128	3	fleering
flensing	12	4	697	3	flensing
fleshing	15	33	930	3	fleshing
flexing	18	35	899	3	fle_xing
fleying	14	32	987	3	fle_ying
flinting	12	34	1234	3	flinting
flirting	12	31	901	3	flirting
fliting	11	35	1461	3	fl_iting
flitting	12	30	1088	3	flitting
floating	12	31	1188	3	floating
flouting	12	26	1047	3	flouting
fluffing	14	27	541	3	fluffing
fluting	11	38	1509	3	fl_uting
flyting	14	37	855	3	fl_yting
fretting	12	27	1152	3	fretting
gelating	10	30	1573	3	gelating
getting	9	33	1656	3	_getting
gifting	12	38	1089	3	_gifting
gleaming	12	27	793	3	gleaming
gleaning	10	26	932	3	gleaning
gleeking	14	31	649	3	gleeking
gleying	12	31	843	3	gle_ying
glinting	10	32	1005	3	glinting
gloating	10	26	1146	3	gloating
glouting	10	37	969	3	glouting
glutting	10	24	764	3	glutting
grafting	13	31	962	3	grafting
greeting	10	31	1235	3	greeting
grifting	13	29	926	3	grifting
guesting	10	5	846	3	guesting
hafting	14	40	1417	3	_hafting
heating	11	40	2432	3	_heating
henting	11	37	1965	3	_henting
ideating	10	3	1170	3	ideating
inletting	10	8	787	3	inletting
jesting	15	43	1771	3	_jesting
jetting	15	38	1534	3	_jetting
lasting	8	47	2524	3	_lasting
leading	9	34	1955	3	_leading
leafing	11	33	1358	3	_leafing
leaking	12	36	1697	3	_leaking
leaning	8	37	2120	3	_leaning
leaping	10	32	1599	3	_leaping
leasing	8	39	2016	3	_leasing
leaving	11	42	1685	3	_leaving
leching	13	46	1365	3	_leching
lectin	8	25	1501	3	_lectin_
lectins	9	25	1500	3	_lectins
leering	8	34	1764	3	_leering
lefties	10	3	1207	3	_lefties
leftish	13	19	725	3	_leftish
leftism	12	22	609	3	_leftism
leftist	10	27	935	3	_leftist
legating	10	23	1311	3	_legating
legging	10	39	1264	3	_legging
lekking	11	30	650	3	_lekking
lemming	12	26	939	3	_lemming
lending	9	41	1853	3	_lending
leniting	9	3	1235	3	_leniting
lensing	8	40	1510	3	_lensing
leptin	8	25	1233	3	_leptin_
leptins	9	24	1269	3	_leptins
levying	14	3	587	3	_levying
lilting	8	35	1538	3	_lilting
linting	8	38	2098	3	_linting
listing	8	40	2059	3	_listing
looting	8	30	1964	3	_looting
lotting	8	29	1775	3	_lotting
louting	8	37	1938	3	_louting
luffing	14	33	1010	3	_luffing
lunting	8	38	1774	3	_lunting
lusting	8	36	1932	3	_lusting
luting	7	52	2175	3	_l_uting
meeting	10	33	1496	3	_meeting
melting	10	33	1775	3	_melting
meting	9	43	2059	3	_me_ting
molesting	12	3	775	3	molesting
nesting	8	43	2044	3	_nesting
netting	8	40	1876	3	_netting
nucleating	13	4	694	3	nucleating
olefin	9	3	758	3	olef_in_
olefine	10	3	802	3	olef_ine
olefins	10	3	749	3	olef_ins
pelting	10	29	1727	3	_pelting
petting	10	37	2095	3	_petting
plaiting	11	31	1351	3	plaiting
planting	11	35	1538	3	planting
plating	10	38	2307	3	pl_ating
platting	11	48	1303	3	platting
pleading	12	30	1144	3	pleading
pleasing	11	26	1159	3	pleasing
pledging	13	27	636	3	pledging
plotting	11	30	1101	3	plotting
questing	18	3	827	3	questing
rafting	11	38	1575	3	_rafting
reefing	11	40	1686	3	reef_ing
reesting	9	31	1827	3	reesting
reffing	14	37	1217	3	_reffing
refuting	12	19	1190	3	_refuting
relating	9	27	2544	3	relating
relenting	10	27	1677	3	relenting
reletting	10	27	1394	3	reletting
renting	8	40	2685	3	_renting
resting	8	50	3118	3	_resting
retting	8	34	2588	3	_retting
rifting	11	35	1500	3	_rifting
scenting	11	32	1281	3	scenting
sclaffing	18	4	336	3	sclaffing
seating	8	41	3068	3	_seating
selecting	12	3	1053	3	selecting
selfing	11	29	1162	3	self_ing
setting	8	36	2139	3	_setting
shafting	15	27	868	3	shafting
sheeting	12	27	1283	3	sheeting
shifting	15	29	1038	3	shifting
sifting	11	30	1459	3	_sifting
sklenting	14	7	512	3	sklenting
slanting	9	41	1509	3	slanting
slating	8	37	2465	3	sl_ating
slatting	9	40	1423	3	slatting
sleaving	12	33	1098	3	sleaving
sledding	11	24	850	3	sledding
sledging	11	28	818	3	sledging
sleeking	13	34	1096	3	sleeking
sleeping	11	38	1205	3	sleeping
sleeving	12	35	928	3	sleeving
sleuthing	13	3	420	3	sleuthing
slewing	11	33	1135	3	sle_wing
slitting	9	30	1258	3	slitting
slotting	9	26	1261	3	slotting
sluffing	15	24	730	3	sluffing
smelting	11	33	971	3	smelting
stetting	9	34	1071	3	stetting
sweating	12	32	1302	3	sweating
sweeting	12	39	1131	3	sweeting
tenting	8	46	2115	3	_tenting
testing	8	60	2105	3	_testing
treating	9	25	1961	3	treating
tufting	11	28	987	3	_tufting
tweeting	12	26	703	3	tweeting
uplifting	15	3	496	3	uplifting
valeting	12	3	885	3	vale_ting
venting	11	42	1809	3	_venting
vesting	11	46	1868	3	_vesting
vetting	11	42	1656	3	_vetting
wafting	14	39	1166	3	_wafting
weeting	11	38	1605	3	_weeting
welting	11	36	1531	3	_welting
westing	11	50	2027	3	_westing
wetting	11	41	1738	3	_wetting
whetting	15	3	597	3	whetting
wresting	12	38	1183	3	wresting
zesting	17	45	1533	3	_zesting

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	146162	0.440	406115.9
2	DLD Change Limit	146162	358	7.796	18748.3
3	Display Results	358	358	0.140	2557.1
	(SQL Overall)	178691	358	8.376	21333.7