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

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

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.

63 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
crawfishing	23	5	173	(None)
brandishing	18	5	336	3	brandishing
crashing	14	35	1263	3	cra___shing
crawfish	19	4	423	3	crawfish___
crawfished	22	4	225	3	crawfish_ed
crawfishes	21	4	359	3	crawfish_es
ravishing	16	3	498	3	_ra_vishing
banishing	15	3	714	4	_ba_nishing
blandishing	18	5	290	4	blandishing
bonefishing	20	5	262	4	bonefishing
braising	11	30	1456	4	bra__is_ing
cashing	13	50	2255	4	c_a___shing
chamoising	18	5	516	4	chamois_ing
chastising	16	5	488	4	chastis_ing
cherishing	19	4	483	4	c_herishing
clashing	14	38	1219	4	cla___shing
coassisting	14	4	359	4	coassisting
crafting	14	37	1017	4	cra_f__ting
cranching	17	27	873	4	cra__nching
craunching	18	4	331	4	cra_unching
crawling	14	31	1051	4	craw___ling
crayfish	19	4	425	4	crayfish___
crayfishes	21	4	340	4	crayfish_es
creeshing	15	3	624	4	cr__eeshing
creolising	13	4	599	4	creolis_ing
crisping	13	31	966	4	cr___isping
cruising	11	26	1015	4	cr__uis_ing
crushing	14	30	1005	4	cr___ushing
enravishing	18	5	223	4	enra_vishing
evanishing	17	4	386	4	eva_nishing
famishing	18	4	523	4	_fa_mishing
fishing	14	39	1386	4	____fishing
garnishing	15	4	457	4	_garnishing
graffitiing	19	5	149	4	graffitiing
graffiting	18	4	292	4	graffi_ting
lavishing	16	4	455	4	_la_vishing
outfishing	17	6	599	4	_outfishing
outwishing	17	6	579	4	outw_ishing
overfishing	21	4	585	4	overfishing
planishing	16	4	532	4	pla_nishing
practising	15	8	636	4	practis_ing
praising	11	32	1456	4	pra__is_ing
prewashing	19	4	494	4	prew_ashing
preweighing	21	4	233	4	preweighing
raising	8	32	2053	4	_ra__is_ing
rawhiding	17	4	311	4	_rawhi_ding
relishing	13	22	918	4	_r_elishing
rewashing	16	7	690	4	_rew_ashing
reweighing	18	5	296	4	_reweighing
scraiching	18	4	379	4	scra__iching
scraighing	17	4	293	4	scra__ighing
spearfishing	21	5	146	4	spearfishing
stablishing	17	5	354	4	stablishing
swishing	15	27	781	4	__sw_ishing
tarnishing	14	4	515	4	_tarnishing
trafficking	24	5	178	4	trafficking
trashing	12	26	1322	4	tra___shing
unwishing	16	3	559	4	_unw_ishing
vanishing	16	4	630	4	_va_nishing
varnishing	17	4	447	4	_varnishing
wampishing	21	4	275	4	_wampishing
whishing	18	28	718	4	___whishing
wishing	14	41	1489	4	___w_ishing

Search took 10 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	148819	0.453	394461.4
2	DLD Change Limit	148819	63	8.703	17099.7
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	9.189	19446.2