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

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

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

153 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
paiking	14	38	1481	(None)
packing	16	44	2072	1	packing
paining	10	39	2024	1	paining
pairing	10	37	1673	1	pairing
parking	14	34	2304	1	parking
piking	13	37	1964	1	p_iking
aiding	8	44	2361	2	_aiding
ailing	7	43	3101	2	_ailing
aiming	9	43	2084	2	_aiming
airing	7	49	2750	2	_airing
asking	11	60	1723	2	_asking
backing	16	55	2344	2	backing
bailing	10	37	2352	2	bailing
baiting	10	39	1888	2	baiting
baking	13	56	2662	2	ba_king
balking	14	37	1735	2	balking
banking	14	46	2135	2	banking
barking	14	47	2418	2	barking
basking	14	47	1861	2	basking
batiking	15	3	750	2	batiking
biking	13	50	1817	2	_biking
caking	13	46	2467	2	ca_king
calking	14	46	1778	2	calking
carking	14	43	2285	2	carking
casking	14	43	1735	2	casking
darking	13	42	1734	2	darking
diking	12	43	2024	2	_diking
failing	11	35	2133	2	failing
fairing	11	36	1401	2	fairing
faking	14	55	2098	2	fa_king
gaining	9	40	1566	2	gaining
gaiting	9	37	1658	2	gaiting
gasking	13	44	1591	2	gasking
gawking	16	39	882	2	gawking
hacking	17	37	2061	2	hacking
hailing	11	38	2069	2	hailing
hanking	15	46	1910	2	hanking
harking	15	41	2094	2	harking
hawking	18	37	1142	2	hawking
hiking	14	36	1710	2	_hiking
jacking	21	45	1526	2	jacking
jailing	15	34	1584	2	jailing
jauking	19	41	832	2	jauking
lacking	14	38	2154	2	lacking
lairing	8	37	1534	2	lairing
laking	11	50	2704	2	la_king
larking	12	37	1825	2	larking
liking	11	43	1958	2	_liking
mailing	10	29	2334	2	mailing
maiming	12	29	1272	2	maiming
making	13	48	2385	2	ma_king
marking	14	40	2013	2	marking
masking	14	51	1661	2	masking
miking	13	42	1846	2	_miking
nailing	8	34	1996	2	nailing
narking	12	40	1538	2	narking
pacing	11	45	2275	2	pa_cing
packings	17	43	1006	2	packings
padding	12	34	1251	2	padding
paging	10	40	2040	2	pa_ging
painting	11	36	1442	2	painting
pairings	11	39	831	2	pairings
paling	9	35	3013	2	pa_ling
palling	10	40	2448	2	palling
palming	12	39	1401	2	palming
palping	12	41	1287	2	palping
panging	11	33	1911	2	panging
panicking	18	3	529	2	panicking
panning	10	40	1939	2	panning
panting	10	40	2542	2	panting
parging	11	33	1860	2	parging
paring	9	42	3649	2	pa_ring
parkings	15	36	1068	2	parkings
parling	10	38	2376	2	parling
parring	10	32	2206	2	parring
parsing	10	38	1955	2	parsing
parting	10	35	2738	2	parting
pashing	13	51	2051	2	pashing
passing	10	43	1842	2	passing
pasting	10	38	2655	2	pasting
patining	11	3	1230	2	patining
patting	10	37	2234	2	patting
pausing	10	39	1281	2	pausing
paving	12	45	1974	2	pa_ving
pawing	12	45	1955	2	pa_wing
pawning	13	47	1141	2	pawning
paying	12	37	2216	2	pa_ying
peaking	14	43	1769	2	peaking
pecking	16	40	1778	2	pecking
peeking	14	44	1495	2	peeking
peining	10	46	1915	2	peining
peising	10	34	1676	2	peising
perking	14	37	1646	2	perking
picking	16	34	1833	2	picking
pieing	9	39	1765	2	p_ieing
piing	8	52	1883	2	p_i_ing
piling	9	50	2559	2	p_iling
pining	9	37	2653	2	p_ining
pinking	14	39	1894	2	pinking
piping	11	40	1745	2	p_iping
plaining	11	39	1155	2	plaining
plaiting	11	31	1351	2	plaiting
planking	15	35	1301	2	planking
plinking	15	36	1124	2	plinking
pocking	16	39	1676	2	pocking
poising	10	36	1710	2	poising
poking	13	38	1930	2	p_oking
porking	14	35	1581	2	porking
praising	11	32	1456	2	praising
pranking	15	38	1338	2	pranking
pricing	12	34	1734	2	pricing
pricking	17	32	1260	2	pricking
priding	11	33	1754	2	priding
priming	12	34	1737	2	priming
prinking	15	32	1245	2	prinking
prising	10	33	2145	2	prising
prizing	19	35	1468	2	prizing
puking	13	39	1306	2	p_uking
racking	14	43	2366	2	racking
raiding	9	36	1759	2	raiding
railing	8	33	2564	2	railing
raining	8	39	2269	2	raining
raising	8	32	2053	2	raising
raking	11	47	2842	2	ra_king
ranking	12	43	2088	2	ranking
sacking	14	41	2270	2	sacking
sailing	8	39	2737	2	sailing
saining	8	36	2139	2	saining
spanking	15	39	1197	2	spanking
sparking	15	28	1254	2	sparking
spiking	14	43	1288	2	spiking
tacking	14	44	2148	2	tacking
tailing	8	29	2310	2	tailing
taking	11	47	2595	2	ta_king
talking	12	38	1582	2	talking
tanking	12	39	1879	2	tanking
tasking	12	46	1632	2	tasking
traiking	13	25	1197	2	traiking
vailing	11	38	1795	2	vailing
viking	14	34	1461	2	_viking
waifing	14	29	1089	2	waifing
wailing	11	36	2090	2	wailing
wairing	11	34	1431	2	wairing
waiting	11	36	1895	2	waiting
waiving	14	32	963	2	waiving
waking	14	48	2138	2	wa_king
walking	15	40	1330	2	walking
wanking	15	42	1678	2	wanking
warking	15	35	1957	2	warking
wauking	15	34	1001	2	wauking
yacking	17	43	1568	2	yacking
yakking	14	37	642	2	yakking
yanking	15	45	1246	2	yanking

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	153	3.093	34811.2
3	Display Results	153	153	0.063	2428.6
	(SQL Overall)	178691	153	3.532	50592.0