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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

135 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
refinishing	18	4	371	(None)
finishing	16	4	584	2	__finishing
refurnishing	19	5	246	2	refurnishing
reminiscing	16	4	380	2	reminiscing
diminishing	18	5	325	3	diminishing
evanishing	17	4	386	3	_evanishing
feminising	16	4	544	3	feminis_ing
minishing	15	4	707	3	__minishing
premonishing	20	5	342	3	premonishing
refinancing	17	4	283	3	refinancing
refinding	14	25	994	3	refin__ding
refining	12	24	1686	3	refin___ing
refinish	14	4	789	3	refinish___
refinished	17	4	408	3	refinish_ed
refinisher	16	4	337	3	refinish_er
refinishers	17	5	262	3	refinishers
refinishes	16	4	469	3	refinish_es
refreshing	17	4	606	3	ref_reshing
refurbishing	21	5	208	3	refurbishing
relinquishing	26	6	158	3	relinquishing
relishing	13	22	918	3	re__lishing
replenishing	18	5	221	3	replenishing
repolishing	17	4	458	3	repolishing
resinifying	18	4	435	3	resinifying
revarnishing	19	8	218	3	revarnishing
admonishing	18	5	274	4	admonishing
astonishing	15	5	336	4	astonishing
banishing	15	3	714	4	__banishing
befingering	18	4	313	4	befingering
burnishing	16	4	391	4	_burnishing
cutinising	13	4	561	4	cutinis_ing
defensing	14	21	700	4	defen_s_ing
defining	13	37	1180	4	defin___ing
definitizing	26	7	299	4	definitizing
demolishing	18	4	388	4	demolishing
demonising	14	4	756	4	demonis_ing
depolishing	18	4	350	4	depolishing
divinising	15	4	510	4	divinis_ing
ebonising	12	4	593	4	_ebonis_ing
englishing	15	4	387	4	_englishing
enisling	9	4	963	4	_e__nisling
famishing	18	4	523	4	__famishing
feminizing	25	4	635	4	femini_zing
finessing	13	4	512	4	__finessing
finicking	19	5	446	4	__finicking
finiking	16	27	707	4	__fini_king
fishing	14	39	1386	4	__f__ishing
furnishing	17	4	401	4	_furnishing
garnishing	15	4	457	4	_garnishing
monishing	15	4	754	4	__monishing
perishing	15	3	953	4	pe__rishing
planishing	16	4	532	4	_planishing
plenishing	16	4	469	4	_plenishing
prefinancing	20	5	194	4	prefinancing
prerinsing	13	4	764	4	prerin_s_ing
punishing	15	4	538	4	__punishing
rainwashing	18	5	226	4	r_ainwashing
ravishing	16	3	498	4	r__avishing
realising	10	3	1317	4	re_alis_ing
rebinding	13	24	948	4	rebin__ding
recognising	15	4	454	4	recognis_ing
redigesting	14	4	457	4	redigesting
redividing	16	4	419	4	redivi_ding
reenlisting	12	4	467	4	reenlisting
refencing	15	18	885	4	refen__cing
refighting	18	4	520	4	refi_ghting
refiguring	15	4	393	4	refi_guring
refiling	12	31	1653	4	ref__i_ling
refilling	13	29	933	4	ref__illing
refilming	15	25	646	4	ref__ilming
refiltering	15	4	482	4	refiltering
refiring	12	35	1392	4	ref__i_ring
refitting	13	28	1112	4	ref__itting
refixing	19	32	979	4	ref__i_xing
refocusing	16	5	385	4	refocus_ing
refocussing	17	5	264	4	refocussing
reforesting	15	4	619	4	reforesting
refraining	14	3	726	4	refrai_ning
refunding	14	25	807	4	refun__ding
refusing	12	23	1087	4	ref__us_ing
rehashing	16	4	711	4	re__hashing
rehinging	14	3	745	4	rehin__ging
reigniting	12	4	637	4	reigni_ting
reinciting	13	4	710	4	re_inciting
reindexing	19	4	385	4	re_indexing
reindicting	15	4	507	4	re_indicting
reinducing	14	4	423	4	re_inducing
reinfusing	14	4	361	4	re_infusing
reining	8	44	2532	4	re_in___ing
reinjuring	18	4	442	4	re_injuring
reinking	13	3	1102	4	re_in__king
reinsuring	11	4	638	4	re_insuring
reinvading	15	4	382	4	re_invading
reinvesting	15	4	532	4	re_investing
reinviting	14	4	621	4	re_inviting
reinvoking	18	4	325	4	re_invoking
reissuing	10	3	461	4	re_i_ssuing
rekindling	16	4	352	4	rekin_dling
reknitting	15	8	499	4	re_knitting
relining	9	32	1874	4	relin___ing
relinking	14	5	825	4	relin__king
relisting	10	24	1435	4	re__listing
reminding	13	23	1154	4	remin__ding
reminiscent	15	5	442	4	reminiscent
reminting	12	23	1510	4	remin__ting
remising	11	25	1645	4	re__mis_ing
renesting	10	25	1470	4	re__nesting
renigging	12	3	557	4	re__nigging
repining	11	41	1659	4	repin___ing
repinning	12	25	897	4	repin__ning
reprising	12	3	1255	4	re_pris_ing
republishing	20	5	292	4	republishing
reraising	10	3	1377	4	re_rais_ing
rerising	9	30	1778	4	re__ris_ing
resinating	11	3	1373	4	resin_ating
resining	9	29	1955	4	resin___ing
resisting	10	32	1531	4	re__sisting
retinting	10	22	1525	4	retin__ting
retwisting	14	4	563	4	re_twisting
reunifying	17	4	516	4	re_unifying
reuniting	10	3	1069	4	re_uni_ting
revising	12	27	1440	4	re__vis_ing
revisiting	14	4	695	4	revisi_ting
revivifying	24	5	285	4	revivifying
rewashing	16	7	690	4	re__washing
reweighing	18	5	296	4	re_weighing
rewinding	14	23	893	4	rewin__ding
rewinning	13	25	744	4	rewin__ning
rinsing	8	25	1611	4	r__in_s_ing
romanising	13	4	658	4	romanis_ing
stonishing	14	4	491	4	_stonishing
tarnishing	14	4	515	4	_tarnishing
tetanising	11	4	617	4	tetanis_ing
vanishing	16	4	630	4	__vanishing
varnishing	17	4	447	4	_varnishing

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.420	425454.8
2	DLD Change Limit	148819	135	8.486	17537.0
3	Display Results	135	135	0.076	1776.3
	(SQL Overall)	178691	135	8.982	19894.3