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

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

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.

87 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
skiorings	14	24	379	(None)
skijorings	22	4	144	1	skijorings
skioring	13	23	722	1	skioring_
shirrings	13	24	532	2	shirrings
shorings	12	26	948	2	s_horings
skiings	12	29	573	2	ski__ings
skijoring	21	4	262	2	skijoring_
skillings	14	24	613	2	skillings
skimmings	18	24	326	2	skimmings
skirring	13	29	714	2	skirring_
skirtings	14	27	456	2	skirtings
sorings	8	38	1725	2	s__orings
stirrings	10	22	469	2	stirrings
airings	8	39	1384	3	_ai_rings
borings	10	36	1424	3	__borings
colorings	12	4	768	3	colorings
fairings	12	38	819	3	fai_rings
firings	11	41	1233	3	_fi_rings
floorings	13	24	509	3	floorings
killings	13	37	1048	3	_killings
kiltings	13	32	708	3	_kiltings
kitlings	13	31	810	3	_kitlings
knowings	16	23	404	3	_knowings
moorings	11	25	771	3	_moorings
motorings	12	4	597	3	motorings
pairings	11	39	831	3	pai_rings
sacrings	11	27	892	3	s_acrings
sailings	9	35	1325	3	sai_lings
savoring	12	6	948	3	savoring_
sciurines	11	4	468	3	sciurines
scoring	10	31	1721	3	s_coring_
scourings	12	23	529	3	scourings
seisings	9	39	852	3	sei_sings
seizings	18	32	647	3	sei_zings
shearings	13	33	756	3	shearings
shielings	13	23	712	3	shielings
shillings	13	34	809	3	shillings
shippings	17	27	568	3	shippings
shirring	12	29	1044	3	shirring_
shirtings	13	27	660	3	shirtings
shootings	13	26	606	3	shootings
shoring	11	28	2007	3	s_horing_
showings	15	24	688	3	s_howings
showrings	16	4	406	3	showrings
siblings	11	10	812	3	s_iblings
sidings	9	40	1146	3	s_i_dings
siftings	12	23	658	3	s_iftings
siring	7	51	2831	3	s_i_ring_
sittings	9	33	973	3	s_ittings
sizings	17	37	801	3	s_i_zings
skatings	13	32	699	3	sk_atings
skibobbings	19	5	90	3	skibobbings
skidding	15	3	546	3	skidding_
skidooing	15	6	250	3	skidooing_
skiing	11	36	1019	3	ski__ing_
skilling	13	29	1133	3	skilling_
skimming	17	28	627	3	skimming_
skimping	17	30	624	3	skimping_
skinking	12	29	977	3	skinking_
skinning	13	32	789	3	skinning_
skipping	17	29	760	3	skipping_
skirling	13	24	906	3	skirling_
skirting	13	28	939	3	skirting_
skiting	12	38	1250	3	ski_ting_
skiving	15	29	837	3	ski_ving_
snoring	8	39	1720	3	s_noring_
soarings	9	32	1039	3	s_oarings
soring	7	47	3188	3	s__oring_
speerings	12	27	684	3	speerings
spiering	11	27	1335	3	spiering_
spilings	11	30	881	3	spi_lings
spinnings	12	29	485	3	spinnings
spiring	10	39	1818	3	spi_ring_
spoolings	12	24	539	3	spoolings
spooring	11	31	1146	3	spooring_
sporing	10	43	1941	3	s_poring_
springs	10	44	1592	3	s__prings
stirring	9	29	965	3	stirring_
storing	8	39	2112	3	s_toring_
strings	8	46	1713	3	s__trings
subrings	11	22	988	3	s_ubrings
suitings	9	28	895	3	sui_tings
swimmings	17	26	315	3	swimmings
swingings	14	27	505	3	swingings
tailorings	11	4	343	3	tailorings
vaporings	15	4	409	3	vaporings
wirings	11	39	1011	3	_wi_rings

Search took 9 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	148641	0.403	443402.0
2	DLD Change Limit	148641	87	7.706	19289.0
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	8.155	21911.8