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

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

112 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
princelings	16	4	257	(None)
princeling	15	4	465	1	princeling_
princekins	18	8	287	2	princekin_s
princeliness	16	5	301	2	princeliness
panelings	12	10	745	3	p_an_elings
pencilings	15	4	315	3	p_encilings
prickings	18	31	565	3	pri_c_kings
prickling	18	3	653	3	pri_ckling_
princekin	17	8	279	3	princekin__
princelets	14	4	346	3	princel_ets
princelier	14	4	334	3	princeli_er
princeliest	15	5	432	3	princeliest
printings	12	26	810	3	prin__tings
ridgelings	13	17	299	3	_ridgelings
sprinklings	18	4	185	3	sprin_klings
branchlines	18	4	361	4	branchlines
brandlings	14	4	399	4	bran_dlings
briefings	15	4	373	4	bri__efings
brislings	12	23	636	4	bri__slings
canceling	14	3	1016	4	_canceling_
changelings	18	4	318	4	changelings
counselings	14	4	271	4	counselings
cracklings	19	14	352	4	cr_acklings
creneling	12	4	773	4	cren_eling_
crinkling	16	14	586	4	crin_kling_
crinolines	12	4	673	4	crin_olines
dieselings	12	5	293	4	_dieselings
drillings	11	28	582	4	dri__llings
drinkings	15	24	477	4	drin__kings
drivelines	14	4	459	4	dri_velines
driveling	14	4	576	4	dri_veling_
fingerings	15	4	507	4	_fingerings
fingerlings	16	4	289	4	_fingerlings
francolins	15	4	387	4	francolin_s
frillings	13	26	580	4	fri__llings
grindelias	12	5	211	4	grindeli_as
gruelings	11	6	376	4	gr__uelings
hirelings	13	6	576	4	_hi_relings
inbeings	11	3	460	4	__inbe_ings
inclines	10	3	1314	4	__inc_lines
incomings	14	4	521	4	__incomings
indexings	18	4	369	4	__indexings
inklings	13	24	638	4	__in_klings
kindlings	15	19	527	4	_kin_dlings
paintings	12	32	709	4	pain__tings
paneling	11	10	1362	4	p_an_eling_
panellings	13	4	453	4	p_anellings
parceling	14	3	844	4	p_arceling_
peelings	11	33	952	4	p___eelings
penciling	14	3	741	4	p_enciling_
pencillings	16	5	240	4	p_encillings
pickings	17	35	938	4	p_i_c_kings
pickling	17	23	920	4	p_i_ckling_
picolines	13	3	962	4	p_i_colines
picolins	12	3	985	4	p_i_colin_s
piecings	13	4	534	4	p_i__ecings
pilings	10	33	1361	4	p_i___lings
pinching	16	37	1105	4	p_inc_hing_
pindling	12	21	1098	4	p_in_dling_
pinelands	12	4	493	4	p_in_elands
pinkening	16	3	499	4	p_inkening_
pinkings	15	33	814	4	p_in__kings
pipelines	13	17	835	4	p_i_pelines
prancing	13	26	1216	4	pranc__ing_
precanceling	19	5	277	4	precanceling_
preceding	15	12	936	4	pr_eceding_
priceless	13	3	688	4	pri_cel_ess
pricing	12	34	1734	4	pri_c__ing_
pricking	17	32	1260	4	pri_c_king_
prickliness	19	4	390	4	pri_ckliness
prilling	11	34	1341	4	pri__lling_
primings	13	33	814	4	pri___mings
princedoms	17	5	166	4	prince_doms
princelet	13	4	653	4	princel__et
princelinesses	18	9	272	4	princelin~~ess~~es
princely	15	4	515	4	princel___y
princes	11	30	1514	4	prince____s
princeships	20	5	309	4	princeships
princess	12	26	680	4	prince___ss
princesses	14	20	626	4	prince_sses
prinking	15	32	1245	4	prin__king_
printeries	12	4	1063	4	printeri_es
printing	11	32	1608	4	prin__ting_
printmakings	21	5	181	4	printmakings
proceedings	17	5	213	4	proceedings
profilings	16	5	356	4	pr_ofilings
proinsulins	13	5	203	4	proinsulin_s
ravelings	13	37	738	4	_r_avelings
reelings	9	40	1256	4	_r__eelings
renderings	12	25	608	4	_renderings
ridgelines	12	16	429	4	_ridgelines
ridgeling	12	15	526	4	_ridgeling_
ridglings	12	21	418	4	_ri_dglings
rieslings	10	3	449	4	_ri_eslings
riflings	12	22	730	4	_ri__flings
rinsings	9	31	801	4	_rin__sings
rocklings	16	22	484	4	_r_ocklings
shielings	13	23	712	4	shi__elings
spanceling	15	4	394	4	spanceling_
springeing	14	4	437	4	springe_ing_
springings	14	4	466	4	sprin__gings
sprinkling	17	4	382	4	sprin_kling_
tinklings	14	22	466	4	_tin_klings
tinseling	10	3	664	4	_tinseling_
trickling	16	4	772	4	tri_ckling_
triflings	13	23	597	4	tri__flings
trindling	11	3	713	4	trin_dling_
trinketing	15	4	415	4	trinketing_
tunnelings	11	4	249	4	_tunnelings
twinklings	18	4	188	4	twin_klings
windlings	14	23	672	4	_win_dlings
wrinkling	17	14	495	4	wrin_kling_

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.500	357382.0
2	DLD Change Limit	148819	112	9.110	16335.8
3	Display Results	112	112	0.063	1777.8
	(SQL Overall)	178691	112	9.673	18473.2