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

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

56 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
crappier	14	28	814	(None)
crampier	14	28	890	1	crampier
crapper	13	39	1319	1	crapp_er
crappie	13	29	899	1	crappie_
crappies	14	29	1117	1	crappies
scrappier	15	4	444	1	scrappier
campier	13	33	1327	2	c_ampier
capper	12	44	2198	2	c_app_er
chappie	16	29	866	2	chappie_
chappies	17	26	1010	2	chappies
chippier	17	29	767	2	chippier
choppier	17	28	665	2	choppier
clapper	13	40	1186	2	clapp_er
crabbier	14	32	680	2	crabbier
craftier	13	7	619	2	craftier
craggier	12	11	606	2	craggier
crankier	14	33	916	2	crankier
crapped	14	39	1263	2	crapp_ed
crappers	14	40	1102	2	crapp_ers
crappiest	15	26	727	2	crappiest
crapping	15	39	1145	2	crapping
crawlier	13	21	687	2	crawlier
crazier	18	36	1074	2	cra_zier
creepier	12	3	625	2	creepier
crepier	11	3	975	2	cr_epier
crimpier	14	28	732	2	crimpier
crippler	14	82	671	2	crippler
crispier	12	29	726	2	crispier
cropper	13	33	1297	2	cropp_er
croppie	13	27	880	2	croppie_
croppies	14	31	1115	2	croppies
croupier	12	4	689	2	croupier
crupper	13	33	856	2	crupp_er
cuppier	13	6	832	2	c_uppier
drippier	13	8	504	2	drippier
flappier	15	4	430	2	flappier
gappier	12	36	984	2	_gappier
grapier	10	37	1260	2	gra_pier
grappler	13	33	619	2	grappler
grippier	13	5	520	2	grippier
happier	14	33	1204	2	_happier
nappier	11	44	1117	2	_nappier
pappier	10	35	1160	2	_pappier
preppier	11	5	664	2	preppier
rapier	8	40	1999	2	_ra_pier
rapper	10	46	2157	2	_rapp_er
raspier	9	31	1064	2	_raspier
sappier	11	36	1312	2	_sappier
scrapper	14	6	697	2	scrapp_er
snappier	12	6	622	2	snappier
strappier	13	4	514	2	strappier
trampier	12	31	824	2	trampier
trapper	11	39	1280	2	trapp_er
trippier	12	4	662	2	trippier
wrapper	14	36	833	2	wrapp_er
zappier	20	45	837	2	_zappier

Search took 8 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	121059	0.763	234195.3
2	DLD Change Limit	121059	56	6.250	19369.4
3	Display Results	56	56	0.016	3500.0
	(SQL Overall)	178691	56	7.029	25422.0