Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

193 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hatchets16331038(None) 
hatchels16368671hatchels
hatchers163113171hatchers
hatches153420271hatche_s
hatchet153317561hatchet_
latchets133410011latchets
ratchets133110261ratchets
batchers153613272batchers
batches144019612batche_s
cachets145014262ca_chets
catchers153114062catchers
catches144320772catche_s
fitchets16307412fitchets
hatcheck2244012hatcheck
hatchecks2343592hatchecks
hatched163414462hatche_d
hatchel153510752hatche_l
hatcher153314722hatche_r
hatchery19326382hatchery
hatchments2043882hatchments
hitchers16379992hitchers
hitches153616272hitche_s
hotches153814362hotche_s
hutches153613522hutche_s
latches123320122latche_s
latchet123117902latchet_
manchets15269572manchets
matchers153012432matchers
matches143219782matche_s
patchers153413302patchers
patches143320382patche_s
rachets124516832ra_chets
ratches123620462ratche_s
ratchet124218332ratchet_
sachets123914102sa_chets
satchels13328162satchels
thatchers1744582thatchers
thatches1637512thatche_s
watchers163511792watchers
watches153017372watche_s
aches106132293_a_che_s
aitches123014363aitche_s
archers124414573_archers
arches114822043_arche_s
baches135426943ba_che_s
batched154114243batche_d
batcher144414853batche_r
bathers124720363bat_hers
bathes116524833bat_he_s
bitches144117063bitche_s
botchers153511543botchers
botches143716023botche_s
brachets154311983brachets
butchers153710183butchers
butches144315363butche_s
caches137926913ca_che_s
cachet134526413ca_chet_
catcher143115823catche_r
catchiest1638313catchiest
catchments1944453catchments
catchups1744383catchups
cathects1545793cat_hects
chatchkas23172783chatchkas
chatchkes23174743chatchkes
chitchats1943653chitchats
cratches153012543cratche_s
crochets15359833crochets
crotchets16396303crotchets
cutches143216463cutche_s
datchas1347423datch_as
ditchers143610363ditchers
ditches133215713ditche_s
etchers123411293_etchers
etches114217763_etche_s
facets116316653fa_c_ets
fathers133916503fat_hers
faucets12578443fauc_ets
fetchers16328863fetchers
fetches153413893fetche_s
fitches153516193fitche_s
fitchet153113563fitchet_
fitchews19274773fitchews
gathers114315073gat_hers
gauchest1436293gauchest
haceks15447863ha_c_eks
hackees165014103ha_ckees
hackers164619043ha_ckers
haets86525123ha___ets
haffets1636053ha_ffets
hairnets1195633hairnets
hamlets123211403ha_mlets
hances115621283hanc_e_s
handsets12258343handsets
hardhats1546833hardhats
harshens1437603harshens
harshest14310193harshest
harslets1137833harslets
hashes125024803ha_she_s
haslets102510863ha_slets
hatch135719593hatch___
hatcheled1844223hatcheled
hatcheries1846523hatcheries
hatching173312213hatching
hatchings18225673hatchings
hatchment1945313hatchment
hatchway2243293hatchway
hatchways2342663hatchways
haters94930403hat__ers
hates86742573hat__e_s
hatless103813443hat_less
hatreds11307813hat_reds
hatters104221523hat_ters
haunches1656963haunche_s
heathens143210153heat_hens
heathers143914733heat_hers
hitched163312253hitche_d
hitcher153712003hitche_r
hooches153812523hooche_s
hootches1656973hootche_s
hotched163610923hotche_d
hotchpots1942903hotchpots
hotshots1455513hotshots
hunches153913463hunche_s
hutched16359883hutche_d
itches114916213_itche_s
jackets205011373ja_ckets
ketches164012193ketche_s
kitchens17195783kitchens
klatches17157133klatche_s
laches116528343la_che_s
lancets93411163lanc_ets
larches124416443larche_s
latched133914063latche_d
latchkeys2141873latchkeys
lathers104321883lat_hers
lathes95127493lat_he_s
letches124015483letche_s
maches134827233ma_che_s
machete14310883ma_chete
machetes1539633ma_chetes
manches143818623manche_s
manchet143317773manchet_
marchers153710813marchers
marches143921173marche_s
matched153513963matche_d
matcher143214283matche_r
matchless1644683matchless
matchups1743073matchups
mutches143314283mutche_s
naches114622413na_che_s
nautches1336083nautche_s
notchers13279423notchers
notches123513653notche_s
outcheats1445303outcheats
packets155114773pa_ckets
parches143720003parche_s
patched153514623patche_d
patcher143515143patche_r
patchiest1638353patchiest
pitchers153211483pitchers
pitches143617753pitche_s
planchets16236743planchets
rachet115028973ra_chet_
rackets134916873ra_ckets
ranchers133311793ranchers
ranches123620113ranche_s
ratcheted1554783ratcheted
retches123318513retche_s
rochets124213473_rochets
rotches123515703rotche_s
sachems14348903sa_chems
sachet114725773sa_chet_
satchel123310303satche_l
satinets8311733satinets
schatchens2042683schatchens
slatches131511523slatche_s
snatchers14146313snatchers
snatches131410713snatche_s
swatches16169963swatche_s
taches114224173ta_che_s
tackets134914363ta_ckets
thatched1735433thatche_d
thatcher1635663thatche_r
thatchiest1844163thatchiest
vetches153411263vetche_s
watched163012823watche_d
watcher153113403watche_r
watcheye19104273watcheye
watcheyes20103743watcheyes
watchouts1744043watchouts
wauchts15285283wauch_ts
witches152715793witche_s
yachts1437023ya_ch_ts

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1561145455.1
2DLD Change Limit1461621937.92318447.8
3Display Results1931930.0762539.5
 (SQL Overall)1786911938.15521911.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.