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

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

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

251 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
handicraft	19	11	381	(None)
handcraft	18	11	547	1	hand_craft
handicrafts	20	14	280	1	handicrafts
handcrafts	19	12	399	2	hand_crafts
handicrafter	21	15	173	2	handicrafter
antidraft	13	4	645	3	_antidraft
antigraft	13	4	740	3	_antigraft
handcart	14	4	932	3	hand_c_art
handcrafted	21	5	216	3	hand_crafted
handicap	16	4	493	3	handic_a_p
handicaps	17	4	408	3	handic_aps
handicrafters	22	17	155	3	handicraft~~ers~~
aircraft	13	5	651	4	_a_ircraft
anticrack	17	4	543	4	_anticrack
bandicoot	14	5	390	4	bandic_oot
campcraft	20	5	329	4	ca_mpcraft
handcar	13	3	737	4	hand_c_a_r
handcars	14	3	762	4	hand_c_ars
handcarts	15	4	553	4	hand_carts
handclap	16	4	365	4	hand_cla_p
handclaps	17	4	349	4	hand_claps
handclasp	17	4	286	4	hand_clasp
handcrafting	22	8	179	4	hand_craft~~ing~~
handcuff	20	4	255	4	hand_c_uff
handcuffs	21	5	201	4	hand_cuffs
handfast	15	4	673	4	hand__fast
handicraftsman	25	8	79	4	handicraft~~sman~~
handicraftsmen	25	7	82	4	handicraft~~smen~~
handier	11	38	1744	4	handier___
handiest	12	34	1778	4	handi__est
handprint	15	4	698	4	hand_print
handrail	12	4	730	4	hand__rail
handwrit	15	4	724	4	hand_wr_it
hovercraft	21	5	270	4	hovercraft
indicant	11	4	1034	4	_indic_ant
indraft	11	9	957	4	_ind__raft
kingcraft	19	5	258	4	kin_gcraft
mendicant	14	6	654	4	mendic_ant
sandcrack	18	5	292	4	sand_crack
tradecraft	16	5	295	4	tradecraft
warcraft	16	4	464	4	wa__rcraft
watercraft	18	5	395	4	watercraft
woodcraft	18	5	293	4	wood_craft
abdicate	13	4	890	5	_abdic_ate
addict	10	7	1120	5	_addic___t
adrift	10	3	1311	5	_a_d__rift
adscript	13	4	420	5	_a_dscript
aldicarb	13	4	290	5	_aldic_arb
aldicarbs	14	4	202	5	_aldicarbs
allograft	13	5	489	5	_allograft
andiron	8	4	828	5	_andi_r_on
andirons	9	4	842	5	_andi_rons
antiaircraft	17	6	170	5	_antiaircraft
anticar	9	3	1266	5	_antic_a_r
anticipant	14	5	682	5	_anticipant
anticrime	13	4	664	5	_anticrime
anticult	10	4	1169	5	_antic_ult
antifat	10	3	1425	5	_anti_fa_t
antifraud	13	5	367	5	_antifraud
antileft	11	4	999	5	_anti_left
antirape	10	4	1011	5	_anti_rape
antiriot	8	4	1458	5	_anti_riot
antirust	8	4	1118	5	_anti_rust
antistat	8	4	1379	5	_antista_t
antitheft	15	5	430	5	_antitheft
antitrade	10	4	652	5	_antitrade
antitragi	10	4	554	5	_antitragi
antitrust	9	4	637	5	_antitrust
aspirant	10	4	886	5	_aspi_rant
autocrat	10	4	928	5	_autocra_t
autograft	13	5	579	5	_autograft
backdraft	21	5	470	5	ba_ckdraft
bandicoots	15	5	194	5	bandicoots
bandit	9	38	2113	5	bandi____t
banditries	13	4	534	5	banditries
banditry	14	4	412	5	banditr__y
bandora	10	3	881	5	band_ora__
bandoras	11	3	874	5	band_ora_s
campcrafts	21	6	184	5	ca_mpcrafts
candida	11	41	1025	5	candi_da__
candidacy	18	5	236	5	candi_dacy
candidal	12	36	774	5	candi_da_l
candidas	12	33	865	5	candi_da_s
candidate	13	5	666	5	candi_date
candidest	13	4	653	5	candi_dest
candygram	18	5	238	5	candygra_m
candygrams	19	5	200	5	candygrams
candytuft	18	7	158	5	cand_ytuft
craft	10	53	2766	5	_____craft
dandiacal	13	5	219	5	dandiaca_l
dandier	9	37	1457	5	dandier___
dandiest	10	34	1503	5	dandi__est
dandify	15	24	567	5	dandi___fy
dandriff	16	9	417	5	dand__riff
dandruff	16	9	251	5	dand__ruff
dicast	9	3	1557	5	___dic_ast
downdraft	17	5	310	5	downd__raft
draft	9	55	2668	5	___d__raft
endocast	11	4	668	5	_endoc_ast
engraft	11	11	862	5	_en__graft
eradicant	12	4	693	5	eradic_ant
fabricant	16	4	489	5	fabric_ant
habitant	13	4	867	5	ha_bi_tant
habitat	12	4	1105	5	ha_bi_ta_t
haircap	14	13	475	5	ha__irca_p
haircaps	15	14	436	5	ha__ircaps
haircut	12	4	683	5	ha__i_rcut
hairnet	10	9	1170	5	ha__i_rnet
handax	17	4	958	5	hand___a_x
handbag	14	9	586	5	hand__ba_g
handbags	15	11	636	5	hand__bags
handball	14	8	703	5	hand__ball
handbarrow	19	5	108	5	handbarrow
handbasket	20	5	361	5	handbasket
handbreadth	21	15	197	5	handbreadth
handclasps	18	5	232	5	hand_clasps
handcraftsman	24	11	94	5	hand_craft~~sman~~
handcraftsmen	24	12	97	5	hand_craft~~smen~~
handcuffed	23	5	126	5	hand_cuffed
hander	10	45	2643	5	hand_er___
handers	11	42	2433	5	hand_er__s
handfasts	16	4	459	5	hand__fasts
handgrip	15	4	380	5	hand_gr_ip
handgrips	16	4	364	5	hand_grips
handicapped	22	5	149	5	handicapped
handicapper	21	6	156	5	handicapper
handily	14	36	1087	5	handi___ly
handiness	13	21	1093	5	handi_ness
handing	12	35	1889	5	handi___ng
handiwork	20	4	301	5	handi_work
handiworks	21	4	269	5	handiworks
handlebar	15	4	235	5	handleba_r
handlebars	16	4	237	5	handlebars
handler	11	35	1616	5	handler___
handlers	12	40	1414	5	handler__s
handlist	12	3	1133	5	hand__list
handmade	15	4	596	5	hand__made
handmaid	15	4	613	5	hand__maid
handoff	17	5	648	5	hand___off
handoffs	18	4	473	5	hand__offs
handout	11	3	1410	5	hand___out
handpick	20	4	384	5	handpic___k
handpicked	23	5	186	5	handpic_ked
handpicking	24	5	184	5	handpicking
handpicks	21	4	323	5	handpic__ks
handpress	15	4	403	5	hand_press
handprints	16	4	397	5	hand_prints
handrails	13	4	651	5	hand__rails
handsaw	14	3	553	5	hand__sa_w
handsaws	15	4	587	5	hand__saws
handsbreadth	22	11	140	5	handsbreadth
handset	11	30	1682	5	hand___set
handshake	20	4	371	5	hand_shake
handsomest	16	5	426	5	handsomest
handspring	17	4	386	5	handspring
handstamp	17	5	287	5	hand_stamp
handstand	14	4	497	5	hand_stand
handwork	19	4	690	5	handwor__k
handworker	21	4	321	5	handworker
handworks	20	4	670	5	handwor_ks
handwrite	16	4	514	5	hand_write
handwrote	16	4	412	5	hand_wrote
handyman	17	4	523	5	hand_yma_n
haniwa	12	3	674	5	han_i_wa__
haptical	15	4	734	5	haptic_a_l
hardcase	14	4	562	5	hard_c_ase
hardcourt	15	4	404	5	hard_court
hardhat	14	4	1102	5	hard__ha_t
hardier	11	47	2154	5	hardier___
hardiest	12	34	1634	5	hardi__est
hardiment	15	4	606	5	hardi_ment
haricot	12	3	1196	5	ha_ric__ot
hindbrain	15	5	285	5	hind_brain
homograft	18	5	604	5	h_omograft
hovercrafts	22	5	167	5	hovercrafts
hydrant	14	8	905	5	h_yd__rant
indican	10	4	824	5	_indic_a_n
indicans	11	4	766	5	_indic_ans
indicants	12	4	720	5	_indic_ants
indicate	11	3	1335	5	_indic_ate
indicia	10	4	698	5	_indicia__
indicias	11	4	741	5	_indicia_s
indict	9	31	1557	5	_indic___t
indignant	11	4	485	5	_indignant
indirect	11	4	752	5	_indi_rect
indiscreet	13	5	350	5	_indiscreet
indrafts	12	9	558	5	_ind__rafts
ingraft	11	9	950	5	_in__graft
kingcrafts	20	6	181	5	kin_gcrafts
landgrab	12	4	303	5	land_gra_b
landgrabs	13	4	286	5	land_grabs
landgrave	14	4	247	5	land_grave
landscape	14	4	399	5	landsc_ape
mandioca	13	5	411	5	mandioca__
mandiocas	14	4	394	5	mandioca_s
mandrake	15	4	600	5	mand__rake
manducate	14	4	577	5	manduc_ate
manicurist	14	5	459	5	man_icurist
manuscript	16	5	221	5	manuscript
maxicoat	19	4	503	5	ma_xicoa_t
medicant	13	9	1083	5	_medic_ant
mendicants	15	5	394	5	mendic_ants
monocrat	12	4	1078	5	mon_ocra_t
nadiral	8	3	634	5	na_di_ra_l
nandina	8	3	891	5	nandi_na__
nandinas	9	3	658	5	nandi_na_s
nonmigrant	13	9	465	5	nonmigrant
pandect	12	3	1095	5	pandec___t
pandit	9	38	2075	5	pandi____t
pandora	10	3	954	5	pand_ora__
pandoras	11	3	1005	5	pand_ora_s
pandura	10	3	714	5	pand_ura__
panduras	11	3	696	5	pand_ura_s
pandurate	12	4	588	5	pand_urate
predicant	14	4	939	5	predic_ant
predraft	14	4	759	5	pred__raft
radiant	8	28	1713	5	ra_di__ant
radical	10	33	1279	5	ra_dic_a_l
radicals	11	26	1016	5	ra_dic_als
radicand	12	11	528	5	ra_dic_and
radicate	11	4	1287	5	ra_dic_ate
randier	8	36	1847	5	randier___
randiest	9	34	1877	5	randi__est
redraft	11	3	1057	5	_red__raft
rotorcraft	15	5	236	5	rotorcraft
sandarac	11	4	583	5	sand_ara_c
sandaracs	12	4	470	5	sand_aracs
sandblast	12	5	565	5	sand_blast
sandcracks	19	5	263	5	sand_cracks
sandier	8	40	1784	5	sandier___
sandiest	9	32	1869	5	sandi__est
sandwort	12	4	1008	5	sandwor__t
scoutcraft	17	5	176	5	scoutcraft
seacraft	13	4	652	5	__seacraft
shandygaff	24	5	68	5	shand_ygaff
spacecraft	19	5	207	5	spacecraft
stagecraft	16	21	337	5	stagecraft
statecraft	15	22	364	5	statecraft
syndical	14	4	537	5	syndic_a_l
syndicate	15	4	451	5	syndic_ate
tardigrade	13	5	185	5	tardigrade
tradecrafts	17	5	182	5	tradecrafts
underact	11	3	1151	5	_und_eract
undercroft	16	15	496	5	_undercroft
updraft	13	4	603	5	_upd__raft
vindicate	15	4	635	5	vindic_ate
warcrafts	17	4	266	5	wa__rcrafts
watercrafts	19	5	278	5	watercrafts
witchcraft	23	5	223	5	witchcraft
woodcrafts	19	5	201	5	wood_crafts
xenograft	20	5	378	5	xen_ograft

Search took 17 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	173545	0.453	394461.4
2	DLD Change Limit	173545	251	15.516	11184.9
3	Display Results	251	251	0.123	2040.7
	(SQL Overall)	178691	251	16.092	11104.3