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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

79 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
ranched	13	31	1360	(None)
branched	16	32	1045	1	branched
cranched	16	32	1041	1	cranched
rancher	12	30	1363	1	rancher
ranches	12	36	2011	1	ranches
ached	11	92	2783	2	_a_ched
arched	12	57	1732	2	_arched
bached	14	55	1989	2	ba_ched
batched	15	41	1424	2	batched
benched	15	47	1394	2	benched
blanched	16	30	860	2	blanched
branches	15	36	1380	2	branches
brunched	16	31	785	2	brunched
bunched	15	43	1241	2	bunched
cached	14	54	1920	2	ca_ched
cinched	15	39	1086	2	cinched
cranches	15	31	1454	2	cranches
craunched	17	6	402	2	craunched
crunched	16	32	816	2	crunched
danced	10	53	1525	2	danc_ed
drenched	15	24	791	2	drenched
fancied	13	33	1060	2	fancied
frenched	17	29	943	2	frenched
hatched	16	34	1446	2	hatched
haunched	17	4	481	2	haunched
hunched	16	37	1049	2	hunched
inched	12	45	1448	2	_inched
lanced	9	37	1772	2	lanc_ed
latched	13	39	1406	2	latched
launched	14	7	540	2	launched
lunched	13	39	1182	2	lunched
lynched	16	37	675	2	lynched
manche	13	35	1510	2	manche_
manches	14	38	1862	2	manches
manchet	14	33	1777	2	manchet
marched	15	38	1340	2	marched
matched	15	35	1396	2	matched
munched	15	34	1107	2	munched
parched	15	40	1369	2	parched
patched	15	35	1462	2	patched
paunched	16	4	552	2	paunched
pinched	15	38	1245	2	pinched
pranced	12	37	1404	2	pranc_ed
punched	15	35	1217	2	punched
raced	8	76	3531	2	ra_c_ed
rachet	11	50	2897	2	ra_chet
racked	13	45	2608	2	ra_cked
ralphed	13	3	436	2	ralphed
rance	7	50	2851	2	ranc_e_
rances	8	46	2544	2	ranc_es
ranch	10	50	1979	2	ranch__
ranchero	13	27	742	2	ranchero
ranchers	13	33	1179	2	ranchers
ranchmen	15	4	583	2	ranchmen
rancho	11	43	1085	2	ranch_o
ranchos	12	39	1139	2	ranchos
rancid	9	5	1386	2	ranc_id
rancored	11	3	722	2	rancored
ranged	8	48	2431	2	ran_ged
ranked	11	46	2074	2	ran_ked
rankled	12	39	1065	2	rankled
ranted	7	43	2470	2	ran_ted
ratches	12	36	2046	2	ratches
ratchet	12	42	1833	2	ratchet
raunches	13	6	805	2	raunches
reached	13	46	1908	2	reached
retched	13	38	1427	2	retched
roached	13	32	1183	2	roached
ruched	12	43	1463	2	r_uched
stanched	14	20	890	2	stanched
synched	16	27	721	2	synched
tranced	10	44	1417	2	tranc_ed
tranche	12	33	1222	2	tranche_
tranches	13	29	1551	2	tranches
trenched	14	28	985	2	trenched
watched	16	30	1282	2	watched
wenched	16	39	1091	2	wenched
winched	16	31	1059	2	winched
wrenched	17	74	813	2	wrenched

Search took 5 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	107671	0.390	458182.1
2	DLD Change Limit	107671	79	3.813	28237.9
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	4.233	42213.8