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

Here are the results of your fuzzy-string dictionary search for “knotted” 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.

327 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
knotted	12	35	722	(None)
knitted	12	33	742	1	knitted
knotter	11	31	764	1	knotter
knouted	12	41	676	1	knouted
beknotted	16	4	234	2	beknotted
blotted	10	39	1183	2	blotted
clotted	10	40	1182	2	clotted
dotted	8	47	1752	2	_dotted
hotted	10	43	1993	2	_hotted
jotted	14	36	1517	2	_jotted
kitted	11	51	1483	2	k_itted
knitter	11	34	813	2	knitter
knobbed	16	3	370	2	knobbed
knocked	13	23	629	2	knocked
knolled	12	29	656	2	knolled
knopped	16	35	544	2	knopped
knotters	12	27	614	2	knotters
knottier	12	20	398	2	knottier
knotty	13	31	522	2	knott_y
knotweed	16	4	209	2	knotweed
lotted	7	42	2240	2	_lotted
netted	7	41	1871	2	_netted
notated	8	27	1366	2	_notated
noted	6	51	2384	2	_no_ted
nutted	7	43	1697	2	_nutted
plotted	10	46	1237	2	plotted
potted	9	46	2401	2	_potted
reknotted	14	4	351	2	reknotted
rotted	7	45	2443	2	_rotted
shotted	11	39	1238	2	shotted
slotted	8	46	1387	2	slotted
snooted	8	42	1327	2	snooted
snorted	8	38	1349	2	snorted
snouted	8	43	1134	2	snouted
sotted	7	41	2139	2	_sotted
spotted	10	37	1313	2	spotted
stotted	8	35	1141	2	stotted
swotted	11	39	870	2	swotted
totted	7	43	1995	2	_totted
trotted	8	37	1128	2	trotted
undotted	10	4	852	2	undotted
unknotted	14	4	361	2	unknotted
unpotted	11	10	839	2	unpotted
wotted	10	41	1571	2	_wotted
abetted	10	5	832	3	abetted
aborted	10	3	1042	3	aborted
abutted	10	5	698	3	abutted
adopted	11	3	625	3	adopted
allotted	9	8	687	3	allotted
annotated	10	9	561	3	annotated
anointed	9	3	834	3	anointed
another	10	28	915	3	another
ansated	8	42	1400	3	ansated
anted	6	63	2824	3	an__ted
anteed	7	56	1611	3	an_teed
azoted	16	38	859	3	azo_ted
batted	9	56	2365	3	_batted
bedotted	12	3	498	3	bedotted
besotted	11	3	584	3	besotted
betted	9	47	2116	3	_betted
bitted	9	44	1848	3	_bitted
blatted	10	48	1271	3	blatted
bloated	10	45	1343	3	bloated
blotter	9	46	1285	3	blotter
boated	9	42	2197	3	_boated
bolted	9	46	1780	3	_bolted
boosted	10	41	1198	3	boosted
booted	9	48	2273	3	_booted
bottled	10	46	1123	3	_bottled
butted	9	47	2206	3	_butted
catted	9	54	2247	3	_catted
chatted	13	34	1189	3	chatted
clothed	13	40	1028	3	clothed
clouted	10	42	1216	3	clouted
coated	9	49	2703	3	_coated
coopted	12	37	1076	3	coopted
costed	9	56	2311	3	_costed
coted	8	50	3385	3	_co_ted
cotter	8	49	2667	3	_cotter
denoted	9	35	1276	3	deno_ted
doated	8	41	1818	3	_doated
doited	8	50	1663	3	_doited
donated	9	35	1386	3	donated
doted	7	52	2707	3	_do_ted
dottel	7	36	1089	3	_dottel
dotter	7	44	1934	3	_dotter
dratted	9	35	859	3	dratted
duetted	9	3	702	3	duetted
emitted	10	30	1085	3	emitted
emoted	9	46	1492	3	emo_ted
enacted	10	3	1064	3	enacted
endited	9	35	1291	3	endited
enrooted	9	7	742	3	enrooted
fatted	10	54	1984	3	_fatted
fetted	10	48	1789	3	_fetted
fitted	10	47	1666	3	_fitted
flatted	11	40	1294	3	flatted
flitted	11	40	1164	3	flitted
floated	11	33	1270	3	floated
flouted	11	32	1081	3	flouted
footed	10	44	1862	3	_footed
footled	11	36	1076	3	footled
fretted	11	34	1185	3	fretted
fritted	11	36	1133	3	fritted
fronted	11	40	1127	3	fronted
frosted	11	32	1187	3	frosted
frothed	14	28	878	3	frothed
garotted	10	6	619	3	garotted
gavotted	13	6	334	3	gavotted
ghosted	12	3	627	3	ghosted
gitted	8	40	1505	3	_gitted
gloated	9	35	1153	3	gloated
glouted	9	42	971	3	glouted
glutted	9	3	724	3	glutted
gotten	7	34	1011	3	_gotten
gritted	9	41	1090	3	gritted
grottoed	10	23	450	3	grottoed
grouted	9	41	1150	3	grouted
gutted	8	47	1636	3	_gutted
hatted	10	49	2151	3	_hatted
hooted	10	44	2265	3	_hooted
hosted	10	50	2034	3	_hosted
hotbed	12	33	1067	3	_hotbed
hotter	9	47	2007	3	_hotter
hutted	10	46	1633	3	_hutted
incited	10	33	1462	3	incited
indited	9	35	1502	3	indited
ingoted	9	3	917	3	ingoted
inputted	11	3	466	3	inputted
insetted	9	24	902	3	insetted
instated	9	16	1333	3	instated
intoned	8	8	1198	3	intoned
intorted	9	3	1012	3	intorted
invited	11	36	1246	3	invited
jetted	14	39	1508	3	_jetted
jolted	14	35	1063	3	_jolted
jotter	13	43	1563	3	_jotter
jutted	14	43	1502	3	_jutted
keynoted	16	4	278	3	keyno_ted
kilted	11	36	1383	3	k_ilted
kirtled	12	28	703	3	kirtled
kited	10	51	2009	3	k__ited
kithed	14	46	1301	3	k_ithed
kittel	10	36	886	3	k_ittel
kitten	10	46	1148	3	k_itten
kittled	12	38	819	3	kittled
knacked	13	28	779	3	knacked
knapped	16	39	710	3	knapped
knarred	12	26	600	3	knarred
kneaded	13	14	647	3	kneaded
kneed	10	46	1205	3	kn__eed
kneeled	12	32	806	3	kneeled
knelled	12	33	898	3	knelled
knifed	14	52	812	3	kn_ifed
knighted	17	4	512	3	knighted
knitters	12	33	662	3	knitters
knocker	12	29	639	3	knocker
knoller	11	28	590	3	knoller
knot	8	56	3050	3	kno_t__
knotless	12	6	456	3	knotless
knots	9	56	1472	3	kno_t_s
knottiest	13	17	456	3	knottiest
knottily	15	4	315	3	knottily
knotting	13	23	657	3	knotting
knotweeds	17	4	165	3	knotweeds
knout	9	50	1826	3	knout__
knouts	10	43	831	3	knout_s
knower	13	3	707	3	kno_wer
knurled	12	4	464	3	knurled
konked	10	40	1058	3	k_onked
kotowed	15	3	377	3	k_otowed
kythed	17	40	731	3	k_ythed
letted	7	41	1854	3	_letted
lofted	10	38	1189	3	_lofted
looted	7	44	2111	3	_looted
lotte	5	49	2385	3	_lotte_
lotter	6	40	2560	3	_lotter
lottes	6	53	2275	3	_lottes
louted	7	49	2069	3	_louted
matted	9	45	2141	3	_matted
moated	9	48	1900	3	_moated
molted	9	42	1747	3	_molted
mooted	9	41	2037	3	_mooted
motte	7	55	2697	3	_motte_
mottes	8	55	2369	3	_mottes
mottled	10	40	997	3	_mottled
natter	6	44	2074	3	_natter
nested	7	47	2006	3	_nested
netter	6	37	2202	3	_netter
nettled	8	33	994	3	_nettled
nocked	13	46	1738	3	_nocked
nodded	9	40	1212	3	_nodded
nogged	9	57	1633	3	_nogged
noised	7	54	1623	3	_noised
noosed	7	50	1801	3	_noosed
normed	9	50	1454	3	_normed
nosed	6	55	2455	3	_no_sed
noshed	10	44	1350	3	_noshed
notate	6	32	1786	3	_notate_
notates	7	28	1748	3	_notates
notched	13	42	1029	3	_notched
note	4	62	3996	3	_no_te_
noter	5	50	2564	3	_no_ter
notes	5	50	3458	3	_no_tes
nother	9	38	1596	3	_nother
noticed	10	3	786	3	_noticed
nutated	8	31	1342	3	_nutated
nutter	6	39	1805	3	_nutter
omitted	10	34	789	3	omitted
opted	8	49	1427	3	__opted
otter	5	44	2397	3	__otter
outed	6	54	2906	3	__outed
patted	9	47	2468	3	_patted
petted	9	41	2152	3	_petted
photoed	13	3	890	3	photoed
pitted	9	43	1959	3	_pitted
platted	10	36	1426	3	platted
plotter	9	41	1366	3	plotter
plotzed	19	37	621	3	plotzed
ported	9	42	2324	3	_ported
posted	9	37	2249	3	_posted
potter	8	39	2698	3	_potter
pouted	9	40	2139	3	_pouted
putted	9	42	2025	3	_putted
quitted	17	33	989	3	quitted
quoited	17	5	640	3	quoited
quoted	16	35	945	3	quo_ted
ratted	7	49	2334	3	_ratted
reknitted	14	4	402	3	reknitted
repotted	11	3	928	3	repotted
retted	7	48	2631	3	_retted
rioted	7	34	1637	3	rio_ted
roosted	8	32	1188	3	roosted
rooted	7	54	2400	3	_rooted
rootled	8	34	1053	3	rootled
rotated	8	27	1529	3	_rotated
rotte	5	46	2593	3	_rotte_
rotten	6	41	1543	3	_rotten
rotter	6	43	2546	3	_rotter
rottes	6	45	2483	3	_rottes
routed	7	56	2433	3	_routed
rutted	7	45	1840	3	_rutted
scatted	10	35	1277	3	scatted
scooted	10	36	1227	3	scooted
scouted	10	41	1203	3	scouted
shitted	11	42	1204	3	shitted
shorted	11	36	1439	3	shorted
shotten	10	28	844	3	shotten
shouted	11	39	1154	3	shouted
slatted	8	40	1518	3	slatted
slitted	8	35	1331	3	slitted
slotter	7	33	1444	3	slotter
smutted	10	3	746	3	smutted
snogged	10	41	797	3	snogged
snooded	9	41	1036	3	snooded
snooked	12	37	1149	3	snooked
snooled	8	45	1393	3	snooled
snooped	10	37	1181	3	snooped
snoozed	17	34	1012	3	snoozed
snored	7	48	1954	3	sno_red
snorter	7	44	1265	3	snorter
snottier	8	21	737	3	snottier
snotty	9	48	919	3	snott_y
snowed	10	46	1361	3	sno_wed
sooted	7	39	2258	3	_sooted
soothed	11	37	1273	3	soothed
sorted	7	45	2371	3	_sorted
spatted	10	40	1414	3	spatted
spitted	10	39	1270	3	spitted
sported	10	40	1543	3	sported
spotter	9	45	1487	3	spotter
spouted	10	34	1226	3	spouted
stetted	8	26	1040	3	stetted
swatted	11	41	1069	3	swatted
swotter	10	39	946	3	swotter
tatted	7	49	2053	3	_tatted
toited	7	40	1675	3	_toited
tooted	7	46	2012	3	_tooted
toothed	11	33	1024	3	toothed
tootled	8	35	1104	3	tootled
toted	6	49	2948	3	_to_ted
totter	6	50	2146	3	_totter
touted	7	44	1974	3	_touted
trothed	11	40	1097	3	trothed
trotter	7	33	1225	3	trotter
tutted	7	51	1744	3	_tutted
twitted	11	32	663	3	twitted
unacted	10	3	1273	3	unacted
unbated	10	33	1773	3	unbated
unbitted	11	3	821	3	unbitted
unbolted	11	7	932	3	unbolted
unbooted	11	8	877	3	unbooted
unbottled	12	4	415	3	unbottled
uncoated	11	3	1496	3	uncoated
undated	9	31	1846	3	undated
unfitted	12	3	816	3	unfitted
ungated	9	27	1721	3	ungated
ungotten	9	4	453	3	ungotten
unhatted	12	3	818	3	unhatted
united	7	44	2154	3	un_ited
unknitted	14	4	370	3	unknitted
unletted	9	3	1031	3	unletted
unmated	10	33	1702	3	unmated
unmatted	11	3	829	3	unmatted
unnoted	8	3	1136	3	unnoted
unoiled	8	24	1547	3	unoiled
unowned	11	4	880	3	unowned
unpitted	11	4	862	3	unpitted
unposted	11	5	943	3	unposted
unrated	8	26	2155	3	unrated
unrooted	9	8	1051	3	unrooted
unsated	8	34	1993	3	unsated
unsorted	9	3	1251	3	unsorted
unspotted	12	4	493	3	unspotted
unstated	9	16	1581	3	unstated
untied	7	37	2081	3	un_tied
unwetted	12	3	812	3	unwetted
unwitted	12	3	754	3	unwitted
unwonted	12	24	864	3	unwonted
vatted	10	42	1473	3	_vatted
vetted	10	43	1632	3	_vetted
voted	9	39	1914	3	_vo_ted
wetted	10	37	1702	3	_wetted
whetted	14	25	669	3	whetted
witted	10	42	1681	3	_witted
wonted	10	32	1328	3	_wonted
zonated	17	33	1053	3	zonated

Search took 7 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	134027	0.153	1167915.0
2	DLD Change Limit	134027	327	6.253	21434.0
3	Display Results	327	327	0.123	2658.5
	(SQL Overall)	178691	327	6.529	27368.8