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 “hatchet” 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.

260 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
hatchet15331756(None) 
hatched163414461hatched
hatchel153510751hatchel
hatcher153314721hatcher
hatches153420271hatches
hatchets163310381hatchets
latchet123117901latchet
ratchet124218331ratchet
batched154114242batched
batcher144414852batcher
batches144019612batches
cachet134526412ca_chet
catcher143115822catcher
catches144320772catches
fitchet153113562fitchet
hatch135719592hatch__
hatcheck2244012hatcheck
hatchels16368672hatchels
hatchers163113172hatchers
hatchery19326382hatchery
hatchment1945312hatchment
hitched163312252hitched
hitcher153712002hitcher
hitches153616272hitches
hotched163610922hotched
hotches153814362hotches
hutched16359882hutched
hutches153613522hutches
latched133914062latched
latches123320122latches
latchets133410012latchets
manchet143317772manchet
matched153513962matched
matcher143214282matcher
matches143219782matches
patched153514622patched
patcher143515142patcher
patches143320382patches
rachet115028972ra_chet
ratches123620462ratches
ratchets133110262ratchets
sachet114725772sa_chet
satchel123310302satchel
thatched1735432thatched
thatcher1635662thatcher
thatches1637512thatches
watched163012822watched
watcher153113402watcher
watches153017372watches
ache96829823_a_che_
ached119227833_a_ched
aches106132293_a_ches
aitches123014363aitches
arched125717323_arched
archer115016243_archer
arches114822043_arches
bached145519893ba_ched
baches135426943ba_ches
batch124620103batch__
batchers153613273batchers
bathe105822883bat_he_
bathed125518743bat_hed
bather115322513bat_her
bathes116524833bat_hes
bitched153212923bitched
bitchen14349733bitchen
bitches144117063bitches
botched153611903botched
botcher143613223botcher
botches143716023botches
brachet144020313brachet
butcher143411163butcher
butches144315363butches
cache125122483ca_che_
cached145419203ca_ched
caches137926913ca_ches
cachets145014263ca_chets
catch125120373catch__
catchers153114063catchers
catchier15329863catchier
catchiest1638313catchiest
catchment1846293catchment
catchup1644793catchup
catchy16559583catch_y
cathect1439863cat_hect
chatchka22202893chatchka
chatchke22153883chatchke
chatchkes23174743chatchkes
chitchat1846053chitchat
cratches153012543cratches
crochet143616663crochet
crotchet152711993crotchet
cutches143216463cutches
datcha1266563datch_a
datchas1347423datchas
ditched143711903ditched
ditcher134012003ditcher
ditches133215713ditches
etched123613703_etched
etcher113912943_etcher
etches114217763_etches
facet106038523fa_c_et
father125116713fat_her
faucet115816553fauc_et
fetched163710473fetched
fetcher153510393fetcher
fetches153413893fetches
fitchee152710783fitchee
fitches153516193fitches
fitchets16307413fitchets
fitchew18276803fitchew
gather104115853gat_her
gauche1238553gauche_
gaucher1337233gaucher
gauchest1436293gauchest
hacek145411843ha_c_ek
hacked164923513ha_cked
hackee154921833ha_ckee
hacker154822693ha_cker
haet75659503ha___et
haffet15311703ha_ffet
hairnet10911703hairnet
halachot1697343halachot
hamlet113722793ha_mlet
hance105424153hanc_e_
hances115621283hanc_es
handset113016823handset
hardhat14411023hardhat
hardset113415833hardset
harshen1339283harshen
harsher13310363harsher
harshest14310193harshest
harslet10315653harslet
hashed136021943ha_shed
hashes125024803ha_shes
haslet93222713ha_slet
hatchecks2343593hatchecks
hatcheled1844223hatcheled
hatching173312213hatching
hatchments2043883hatchments
hatchway2243293hatchway
hate78450173hat__e_
hated95734023hat__ed
hater85034753hat__er
hates86742573hat__es
hath105933913hat_h__
hatred104814333hat_red
hatted104921513hat_ted
hatter94724873hat_ter
haunched1744813haunched
haunches1656963haunches
heathen133410893heat_hen
heather133914853heat_her
hitch134515473hitch__
hitchers16379993hitchers
hither124417253hit_her
hooches153812523hooches
hootches1656973hootches
hotch136214733hotch__
hotchpot1844123hotchpot
hotshot1358343hotshot
hunched163710493hunched
hunches153913463hunches
hutch135414093hutch__
itched123812023_itched
itches114916213_itches
jacket194720673ja_cket
ketches164012193ketches
kitchen16287683kitchen
klatches17157133klatches
laches116528343la_ches
lancet84223573lanc_et
larchen12479623larchen
larches124416443larches
latch104620463latch__
latchkey2042913latchkey
lathe85626713lat_he_
lathed104718453lat_hed
lather95124353lat_her
lathes95127493lat_hes
letched133912053letched
letches124015483letches
mache125925303ma_che_
maches134827233ma_ches
machete14310883ma_chete
manche133515103manche_
manches143818623manches
manchets15269573manchets
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marches143921173marches
match125621103match__
matchers153012433matchers
matchup1643513matchup
mutches143314283mutches
naches114622413na_ches
natch105018223natch__
nautches1336083nautches
notched134210303notched
notcher123610933notcher
notches123513653notches
outcheat1349413outcheat
packet144726503pa_cket
parched154013693parched
parches143720003parches
patch125221223patch__
patchers153413303patchers
patchier15319663patchier
patchiest1638353patchiest
patchy16509573patch_y
pitched153512923pitched
pitcher143813713pitcher
pitches143617753pitches
planchet152511963planchet
rachets124516833ra_chets
racket125229423ra_cket
ranched133113603ranched
rancher123013633rancher
ranches123620113ranches
ratch104221363ratch__
ratcheted1554783ratcheted
rathe85821923rat_he_
rather94319743rat_her
retched133814273retched
retches123318513retches
rochet115423003_rochet
rotche114311983rotche_
rotches123515703rotches
sachem134012223sa_chem
sachets123914103sa_chets
satchels13328163satchels
satinet7325283satinet
schatchen1943853schatchen
slatches131511523slatches
snatched14157633snatched
snatcher13167763snatcher
snatches131410713snatches
swatches16169963swatches
tacet75840023ta_c_et
tache106222373ta_che_
taches114224173ta_ches
tacket124627493ta_cket
tetched133010773tetched
thatch1435613thatch__
thatchers1744583thatchers
thatchier1743983thatchier
thatchiest1844163thatchiest
thatchy1833303thatch_y
unhatched1844133unhatched
vetches153411263vetches
watch135617063watch__
watchers163511793watchers
watcheye19104273watcheye
watchmen1844753watchmen
watchout1647013watchout
waucht14399413wauch_t
witched163012193witched
witches152715793witches
yacht13417393ya_ch_t

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272606.76319817.7
3Display Results2602600.0962708.3
 (SQL Overall)1786912607.01525472.7
 
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.