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

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

125 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
skijorings	22	4	144	(None)
skijoring	21	4	262	1	skijoring_
skiorings	14	24	379	1	ski_orings
skioring	13	23	722	2	ski_oring_
shirrings	13	24	532	3	shi_rrings
shorings	12	26	948	3	s__horings
skibobbings	19	5	90	3	skibobbings
skidooing	15	6	250	3	skidooing_
skiings	12	29	573	3	ski___ings
skijorers	20	4	197	3	skijor_ers
skillings	14	24	613	3	ski_llings
skimmings	18	24	326	3	ski_mmings
skirring	13	29	714	3	ski_rring_
skirtings	14	27	456	3	ski_rtings
sorings	8	38	1725	3	s___orings
stirrings	10	22	469	3	sti_rrings
tailorings	11	4	343	3	tailorings
airings	8	39	1384	4	_ai__rings
borings	10	36	1424	4	___borings
colorings	12	4	768	4	_colorings
fairings	12	38	819	4	fai__rings
firings	11	41	1233	4	_fi__rings
flavorings	17	6	297	4	flavorings
floorings	13	24	509	4	_floorings
ironings	9	21	758	4	__ironings
killings	13	37	1048	4	_ki_llings
kiltings	13	32	708	4	_ki_ltings
kindlings	15	19	527	4	_kindlings
kitlings	13	31	810	4	_ki_tlings
knowings	16	23	404	4	_k_nowings
majoring	18	3	636	4	_majoring_
minoring	11	3	1147	4	_minoring_
moorings	11	25	771	4	__moorings
motorings	12	4	597	4	_motorings
niderings	11	7	540	4	_niderings
pairings	11	39	831	4	pai__rings
pilotings	12	3	435	4	_pilotings
sacrings	11	27	892	4	s__acrings
sailings	9	35	1325	4	sai__lings
savoring	12	6	948	4	s_avoring_
schoolings	16	4	401	4	schoolings
scissoring	13	4	330	4	scissoring_
sciurines	11	4	468	4	sci_urines
scoring	10	31	1721	4	s__coring_
scourings	12	23	529	4	s_courings
seafarings	14	4	278	4	seafarings
seasonings	11	4	329	4	seasonings
sectoring	12	3	958	4	sectoring_
seisings	9	39	852	4	sei__sings
seizings	18	32	647	4	sei__zings
shearings	13	33	756	4	s_hearings
shielings	13	23	712	4	shi_elings
shillings	13	34	809	4	shi_llings
shippings	17	27	568	4	shi_ppings
shirring	12	29	1044	4	shi_rring_
shirtings	13	27	660	4	shi_rtings
shivering	16	3	733	4	shivering_
shootings	13	26	606	4	s_hootings
shoring	11	28	2007	4	s__horing_
showings	15	24	688	4	s__howings
showrings	16	4	406	4	s_howrings
siblings	11	10	812	4	s_i_blings
sidings	9	40	1146	4	s_i__dings
siftings	12	23	658	4	s_i_ftings
sightings	14	25	653	4	s_ightings
signorinas	11	5	267	4	signorinas
siloing	8	32	1550	4	s_ilo_ing_
silverings	14	4	384	4	silverings
siring	7	51	2831	4	s_i__ring_
sittings	9	33	973	4	s_i_ttings
sizings	17	37	801	4	s_i__zings
skatings	13	32	699	4	sk__atings
skewering	17	4	463	4	skewering_
skibobbing	18	5	132	4	skibobbing_
skidding	15	3	546	4	ski_dding_
skiddooing	17	5	101	4	skiddooing_
skiffling	20	4	310	4	skiffling_
skiing	11	36	1019	4	ski___ing_
skijorer	19	4	214	4	skijor__er
skilling	13	29	1133	4	ski_lling_
skimming	17	28	627	4	ski_mming_
skimobiles	18	5	199	4	skimobiles
skimping	17	30	624	4	ski_mping_
skinflints	17	4	147	4	skinflints
skinking	12	29	977	4	ski_nking_
skinning	13	32	789	4	ski_nning_
skippering	19	4	367	4	skippering_
skipping	17	29	760	4	ski_pping_
skirling	13	24	906	4	ski_rling_
skirting	13	28	939	4	ski_rting_
skiting	12	38	1250	4	ski__ting_
skittering	15	3	539	4	skittering_
skiving	15	29	837	4	ski__ving_
skivvying	23	9	160	4	skivvying_
skydivings	22	7	88	4	skydivings
skyjackings	27	5	82	4	skyjackings
slivering	13	3	808	4	slivering_
snoring	8	39	1720	4	s__noring_
soarings	9	32	1039	4	s__oarings
soring	7	47	3188	4	s___oring_
speerings	12	27	684	4	s_peerings
spiering	11	27	1335	4	spi_ering_
spilings	11	30	881	4	spi__lings
spinnings	12	29	485	4	spi_nnings
spiring	10	39	1818	4	spi__ring_
spoolings	12	24	539	4	s_poolings
spooring	11	31	1146	4	s_pooring_
sporing	10	43	1941	4	s__poring_
springs	10	44	1592	4	s___prings
stipplings	15	8	237	4	stipplings
stirring	9	29	965	4	sti_rring_
storing	8	39	2112	4	s__toring_
strings	8	46	1713	4	s___trings
subjoins	17	4	545	4	subjo_in_s
subrings	11	22	988	4	s__ubrings
succoring	14	4	587	4	succoring_
sufferings	17	4	323	4	sufferings
suitings	9	28	895	4	sui__tings
swimmings	17	26	315	4	swi_mmings
swingings	14	27	505	4	swi_ngings
tailoring	10	3	640	4	tailoring_
vaporings	15	4	409	4	_vaporings
visoring	12	3	837	4	_visoring_
vizoring	21	3	457	4	_vizoring_
wirings	11	39	1011	4	_wi__rings

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	161450	0.440	406115.9
2	DLD Change Limit	161450	125	9.326	17311.8
3	Display Results	125	125	0.063	1984.1
	(SQL Overall)	178691	125	9.829	18180.0