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

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

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

311 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
checkers	19	31	784	(None)
checker	18	32	953	1	checker_
cheaters	13	36	1351	2	cheaters
checked	19	37	1002	2	checke_d
checkered	21	4	468	2	checkered
checkless	20	4	423	2	checkless
checks	17	49	1270	2	check__s
checkups	21	4	280	2	checkups
cheders	13	45	1239	2	che_ders
cheepers	15	32	901	2	cheepers
cheerers	13	31	954	2	cheerers
cheers	11	45	1891	2	che__ers
chequers	22	3	410	2	chequers
chewers	15	41	1114	2	che_wers
chickees	19	25	851	2	chickees
chickens	19	26	743	2	chickens
chokers	16	43	1152	2	ch_okers
chucklers	20	3	444	2	chucklers
chukkers	16	3	348	2	chukkers
clackers	16	39	1170	2	clackers
clickers	16	39	1020	2	clickers
clockers	16	36	981	2	clockers
cockers	15	36	1833	2	c_ockers
crackers	16	41	1172	2	crackers
deckers	14	44	1383	2	_deckers
hackers	16	46	1904	2	_hackers
hecklers	17	35	712	2	_hecklers
hockers	16	39	1591	2	_hockers
neckers	13	42	1046	2	_neckers
peckers	15	33	1267	2	_peckers
shickers	17	30	1282	2	shickers
shockers	17	31	946	2	shockers
shuckers	17	38	813	2	shuckers
whackers	20	32	654	2	whackers
whickers	20	29	798	2	whickers
wreckers	17	31	597	2	wreckers
backers	15	38	2189	3	_backers
beakers	13	42	1687	3	_beakers
beckets	15	39	982	3	_beckets
bickers	15	43	1655	3	_bickers
blockers	16	39	879	3	blockers
breakers	14	38	1097	3	breakers
buckers	15	35	1745	3	_buckers
cacklers	16	37	1070	3	c_acklers
calkers	13	44	1469	3	c_alkers
cancers	11	40	1858	3	canc_ers
cankers	13	44	1875	3	c_ankers
catchers	15	31	1406	3	catchers
caulkers	14	37	565	3	caulkers
ceders	9	38	1767	3	c_e_ders
ceilers	9	39	1253	3	c_eilers
censers	9	43	1390	3	c_ensers
centers	9	44	2060	3	c_enters
chafers	15	45	1274	3	ch_afers
chaffers	19	37	800	3	chaffers
chambers	17	34	1062	3	chambers
chamfers	18	40	922	3	chamfers
champers	17	33	1162	3	champers
chancers	15	43	1349	3	chancers
changers	14	43	1320	3	changers
chanters	13	40	1674	3	chanters
chapters	15	40	1213	3	chapters
chargers	14	40	1132	3	chargers
charmers	15	42	1133	3	charmers
charters	13	41	1559	3	charters
chasers	12	37	1492	3	ch_asers
chatters	13	42	1395	3	chatters
chaufers	16	34	730	3	chaufers
chawers	15	44	1205	3	ch_awers
cheapens	15	30	594	3	cheapens
cheaper	14	40	1058	3	cheaper_
cheater	12	48	1696	3	cheater_
chebecs	16	3	501	3	che_becs
check	16	47	1471	3	check___
checkering	22	4	440	3	checkering
checking	20	37	920	3	checking
checklist	20	4	385	3	checklist
checkmark	21	5	216	3	checkmark
checkmarks	22	5	198	3	checkmarks
checkoff	25	4	242	3	checkoff
checkoffs	26	4	175	3	checkoffs
checkout	19	4	559	3	checkout
checkouts	20	4	318	3	checkouts
checkrein	20	4	290	3	checkrein
checkreins	21	5	249	3	checkreins
checkrow	22	4	275	3	checkrow
checkrows	23	4	277	3	checkrows
checksum	21	5	240	3	checksum
checksums	22	5	200	3	checksums
checkup	20	4	332	3	check_up
cheddars	15	23	438	3	cheddars
cheder	12	51	1349	3	che_der_
cheeked	17	39	966	3	cheeke_d
cheekier	17	3	510	3	cheekier_
cheekless	18	7	388	3	cheekless
cheeks	15	47	1278	3	che__eks
cheeper	14	36	1074	3	cheeper_
cheeps	13	53	1291	3	che__eps
cheer	10	54	2038	3	che__er_
cheerer	12	35	1176	3	cheerer_
cheero	11	47	1294	3	che__ero
cheeros	12	37	1164	3	che__eros
cheery	14	49	1315	3	che__ery
cheeses	12	36	1310	3	cheese_s
chegoes	13	3	733	3	chegoe_s
chequer	21	3	515	3	chequer_
cheques	21	3	686	3	cheque_s
chesses	12	41	1263	3	chesse_s
chevies	15	35	1144	3	chevie_s
chevres	15	37	979	3	chevre_s
chevrets	16	25	532	3	chevrets
chewer	14	55	1262	3	che_wer_
chewier	15	3	759	3	chewier_
chicaners	16	8	536	3	chicaners
chicer	13	45	1360	3	chic_er_
chickee	18	31	1155	3	chicke_e
chicken	18	27	898	3	chicke_n
chickory	22	4	336	3	chickory
chickpeas	22	4	296	3	chickpeas
chicks	17	53	1759	3	chick__s
chicles	14	35	1250	3	chicle_s
chicness	15	3	559	3	chicness
chiders	13	53	1294	3	ch_iders
chiggers	15	3	556	3	chiggers
chillers	13	37	1092	3	chillers
chimers	14	45	1514	3	ch_imers
chippers	17	35	1088	3	chippers
chirker	16	42	932	3	chirker_
chirpers	15	35	813	3	chirpers
chitters	13	37	1117	3	chitters
chocked	19	44	1161	3	chocke_d
chocks	17	48	1531	3	chock__s
choker	15	43	1437	3	ch_oker_
chokes	15	49	1738	3	ch_oke_s
cholers	12	42	1520	3	ch_olers
chompers	17	36	959	3	chompers
choosers	13	48	1088	3	choosers
choppers	17	41	1046	3	choppers
chousers	13	46	1020	3	chousers
chowders	17	38	754	3	chowders
chucked	19	46	973	3	chucke_d
chuckies	19	3	770	3	chuckies
chuckler	19	3	555	3	chuckler_
chuckles	19	3	680	3	chuckles
chucks	17	48	1293	3	chuck__s
chudders	15	23	556	3	chudders
chuggers	15	5	486	3	chuggers
chukars	16	3	428	3	ch_ukars
chukkars	16	4	201	3	chukkars
chukker	15	4	383	3	chukker_
chunters	13	39	1090	3	chunters
churners	13	31	689	3	churners
circlers	12	3	535	3	circlers
clacker	15	38	1377	3	clacker_
cleaners	10	36	1054	3	cleaners
clearers	10	34	930	3	clearers
cleavers	13	39	887	3	cleavers
clenchers	16	27	655	3	clenchers
clicker	15	41	1188	3	clicker_
clinkers	14	33	983	3	clinkers
clocker	15	39	1087	3	clocker_
clunkers	14	32	756	3	clunkers
coachers	15	43	1230	3	coachers
cocker	14	43	2039	3	c_ocker_
coercers	12	3	765	3	coercers
coherers	13	23	1073	3	cohe_rers
comakers	16	33	917	3	comakers
conkers	13	37	2104	3	c_onkers
cookers	13	46	1946	3	c_ookers
corkers	13	41	1885	3	c_orkers
couchers	15	35	1386	3	couchers
cracker	15	31	1417	3	cracker_
creamers	12	41	1131	3	creamers
creasers	10	36	1284	3	creasers
creches	14	3	1309	3	creche_s
creepers	12	31	863	3	creepers
crickets	16	41	812	3	crickets
croakers	14	28	852	3	croakers
crockery	19	35	660	3	crockery
crockets	16	33	954	3	crockets
cyclers	14	3	587	3	c_yclers
dackers	14	34	1704	3	_dackers
deckels	14	36	736	3	_deckels
decker	13	52	1599	3	_decker_
dickers	14	41	1766	3	_dickers
dockers	14	37	1500	3	_dockers
duckers	14	32	1471	3	_duckers
erecters	10	26	1161	3	erecters
eskers	10	53	1222	3	__eskers
flickers	17	33	888	3	flickers
fuckers	16	36	1159	3	_fuckers
hackees	16	50	1410	3	_hackees
hacker	15	48	2269	3	_hacker_
hacklers	17	37	1030	3	_hacklers
hankers	14	42	1813	3	_hankers
hawkers	17	42	1033	3	_hawkers
headers	11	38	1939	3	_headers
healers	10	43	1946	3	_healers
heapers	12	36	1667	3	_heapers
hearers	10	43	1978	3	_hearers
heaters	10	42	2522	3	_heaters
heavers	13	37	1719	3	_heavers
heckler	16	27	857	3	_heckler_
heckles	16	37	1138	3	_heckles
hecks	14	52	2065	3	_heck__s
hectors	12	35	1326	3	_hectors
heders	10	41	1976	3	_he_ders
hedgers	12	43	1026	3	_hedgers
heeders	11	42	1374	3	_heeders
heelers	10	38	1563	3	_heelers
hefters	13	43	1200	3	_hefters
heifers	13	3	793	3	_heifers
hellers	10	36	1983	3	_hellers
helpers	12	33	1185	3	_helpers
hemmers	14	33	1084	3	_hemmers
herders	11	39	1412	3	_herders
hewers	12	37	1527	3	_he_wers
hexers	16	56	1275	3	_he_xers
hickeys	19	50	822	3	_hickeys
hikers	13	50	1435	3	_h_ikers
hocker	15	51	1856	3	_hocker_
hockeys	19	50	927	3	_hockeys
honkers	14	33	1523	3	_honkers
hookers	14	49	1652	3	_hookers
hunkers	14	33	1433	3	_hunkers
huskers	14	35	1004	3	_huskers
ickers	12	39	1418	3	__ickers
jackers	20	42	1445	3	_jackers
jerkers	18	28	708	3	_jerkers
kickers	12	40	1329	3	_kickers
knackers	13	28	684	3	knackers
knickers	13	30	672	3	knickers
knockers	13	28	573	3	knockers
lackers	13	41	2054	3	_lackers
leakers	11	34	1542	3	_leakers
lechers	12	33	1396	3	_lechers
lickers	13	41	1825	3	_lickers
lockers	13	35	1692	3	_lockers
mockers	15	38	1294	3	_mockers
muckers	15	36	1280	3	_muckers
necker	12	40	1279	3	_necker_
nickers	13	44	1509	3	_nickers
ockers	12	38	1390	3	__ockers
oxpeckers	24	4	176	3	oxpeckers
packers	15	38	1889	3	_packers
pecker	14	46	1536	3	_pecker_
phreakers	18	3	467	3	phreakers
pickers	15	37	1809	3	_pickers
piecers	11	41	1225	3	piec_ers
pluckers	16	31	656	3	pluckers
prickers	16	37	1067	3	prickers
puckers	15	35	1467	3	_puckers
rackers	13	43	2045	3	_rackers
reekers	11	36	1314	3	_reekers
rockers	13	39	1655	3	_rockers
sackers	13	38	2022	3	_sackers
schemers	15	7	671	3	sche_mers
seekers	11	37	1233	3	_seekers
shacklers	18	33	603	3	shacklers
shakers	14	40	1556	3	sh_akers
sharkers	15	40	1105	3	sharkers
shearers	11	39	1132	3	shearers
shedders	13	26	743	3	shedders
sheers	9	43	2240	3	she__ers
sheeters	11	31	1186	3	sheeters
shekels	14	3	604	3	she_kels
shellers	11	28	1258	3	shellers
shelters	11	34	1281	3	shelters
shelvers	14	38	881	3	shelvers
shewers	13	43	1205	3	she_wers
shicker	16	39	1482	3	shicker_
shikkers	14	32	652	3	shikkers
shirkers	15	31	958	3	shirkers
shocker	16	34	1143	3	shocker_
shucker	16	37	1010	3	shucker_
slackers	14	38	1274	3	slackers
sleekers	12	37	799	3	sleekers
slickers	14	31	1255	3	slickers
smackers	16	31	871	3	smackers
snackers	14	30	1022	3	snackers
sneakers	12	30	864	3	sneakers
snickers	14	30	1096	3	snickers
speakers	14	29	945	3	speakers
specters	12	28	1106	3	specters
stackers	14	34	1356	3	stackers
stickers	14	29	1303	3	stickers
stockers	14	34	1107	3	stockers
suckers	13	37	1762	3	_suckers
tackers	13	43	1962	3	_tackers
thankers	15	29	783	3	thankers
theaters	11	42	1190	3	theaters
thickens	17	26	641	3	thickens
thicker	16	36	1102	3	thicker_
thickets	17	28	708	3	thickets
thinkers	15	30	870	3	thinkers
thwackers	21	4	222	3	thwackers
tickers	13	36	1772	3	_tickers
trackers	14	35	1285	3	trackers
trekkers	11	3	380	3	trekkers
trickers	14	38	1281	3	trickers
truckers	14	27	901	3	truckers
tuckers	13	40	1435	3	_tuckers
whacker	19	36	850	3	whacker_
wheelers	14	28	774	3	wheelers
wheezers	23	26	528	3	wheezers
whetters	14	24	665	3	whetters
whicker	19	35	977	3	whicker_
whiskers	18	30	677	3	whiskers
wickers	16	41	1470	3	_wickers
wreakers	15	32	842	3	wreakers
wrecker	16	36	760	3	wrecker_

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	146162	0.483	369960.7
2	DLD Change Limit	146162	311	7.780	18786.9
3	Display Results	311	311	0.126	2468.3
	(SQL Overall)	178691	311	8.389	21300.6