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

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

55 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
crisper	11	35	1105	(None)
crimper	13	65	1042	1	crimper
crisped	12	40	1010	1	crisped
crispen	11	34	820	1	crispen
crispers	12	30	943	1	crispers
crispier	12	29	725	1	crispier
brisker	13	42	1029	2	brisker
chipper	16	39	1258	2	chipper
chirper	14	35	996	2	chirper
clasper	11	38	1186	2	clasper
clipper	13	37	1032	2	clipper
crapper	13	39	1319	2	crapper
crasher	12	46	1616	2	crasher
crasser	9	41	1434	2	crasser
creeper	11	33	998	2	creeper
cribber	13	36	766	2	cribber
crier	7	47	2446	2	cri__er
crimmer	13	33	1077	2	crimmer
crimped	14	39	1076	2	crimped
crimpers	14	31	893	2	crimpers
crimpier	14	28	732	2	crimpier
cringer	10	35	1424	2	cringer
cripe	9	55	2114	2	cri_pe_
cripes	10	51	2087	2	cri_pes
crippler	14	82	671	2	crippler
crises	8	45	2943	2	cris_es
crisp	9	50	1462	2	crisp__
crispens	12	28	625	2	crispens
crispest	12	17	737	2	crispest
crisply	14	42	652	2	crisply
crisps	10	44	1151	2	crisp_s
crispy	13	47	856	2	crisp_y
critter	9	41	1303	2	critter
cropper	13	33	1296	2	cropper
crosier	9	41	1657	2	crosier
crosser	9	50	1546	2	crosser
cruiser	9	34	1043	2	cruis_er
crupper	13	33	856	2	crupper
crusher	12	44	1232	2	crusher
dripper	12	34	923	2	dripper
frisker	14	38	927	2	frisker
grasper	10	38	979	2	grasper
griper	9	41	1461	2	gri_per
gripper	12	44	1071	2	gripper
grister	8	39	1541	2	grister
lisper	8	41	1443	2	_lisper
prosper	11	40	1219	2	prosper
rasper	8	39	1733	2	_rasper
riper	7	43	2840	2	_ri_per
ripper	10	35	1865	2	_ripper
riser	5	54	3105	2	_ris_er
risker	10	54	1449	2	_risker
scrimper	14	5	576	2	scrimper
tripper	11	37	1192	2	tripper
whisper	15	29	801	2	whisper

Search took 4 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.373	479064.3
2	DLD Change Limit	107671	55	2.936	36672.7
3	Display Results	55	55	0.016	3437.5
	(SQL Overall)	178691	55	3.325	53741.7