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

182 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
hatchels1636867(None) 
hatchel153510751hatchel_
hatchers163113171hatchers
hatches153420271hatche_s
hatchets163310381hatchets
satchels13328161satchels
batchers153613272batchers
batches144019612batche_s
catchers153114062catchers
catches144320772catche_s
hatcheck2244012hatcheck
hatchecks2343592hatchecks
hatched163414462hatche_d
hatcheled1844222hatcheled
hatcher153314722hatche_r
hatchery19326382hatchery
hatchet153317562hatche_t
hitchers16379992hitchers
hitches153616272hitche_s
hotches153814362hotche_s
hutches153613522hutche_s
latches123320122latche_s
latchets133410012latchets
matchers153012432matchers
matches143219782matche_s
patchers153413302patchers
patches143320382patche_s
ratches123620462ratche_s
ratchets133110262ratchets
satchel123310302satchel_
thatchers1744582thatchers
thatches1637512thatche_s
watchers163511792watchers
watches153017372watche_s
aches106132293_a_che_s
aitches123014363aitche_s
archers124414573_archers
arches114822043_arche_s
archils12510533_archils
baches135426943ba_che_s
batched154114243batche_d
batcher144414853batche_r
bathers124720363bat_hers
bathes116524833bat_he_s
bethels1238533bet_hels
bitches144117063bitche_s
botchers153511543botchers
botches143716023botche_s
butchers153710183butchers
butches144315363butche_s
caches137926913ca_che_s
cachets145014263ca_chets
cancels114113313canc_els
carcels114516063carc_els
catcalls1238323catcalls
catchall1546233catchall
catchalls1645493catchalls
catcher143115823catche_r
catchfly2143333catchfly
catchups1744383catchups
catechols1655053catechols
chancels15439083chanc_els
chatchkas23172783chatchkas
chatchkes23174743chatchkes
chattels13286793chat_tels
cratches153012543cratche_s
cutches143216463cutche_s
datchas1347423datch_as
ditchers143610363ditchers
ditches133215713ditche_s
etchers123411293_etchers
etches114217763_etche_s
fathers133916503fat_hers
fetchers16328863fetchers
fetches153413893fetche_s
fitches153516193fitche_s
fitchets16307413fitchets
fitchews19274773fitchews
gathers114315073gat_hers
gauchely1742743gauchely
haceks15447863ha_c_eks
hackees165014103ha_ckees
hackers164619043ha_ckers
hackles162917063ha_ckles
hallels103310133ha_llels
hances115621283hanc_e_s
handheld1644463handheld
handhelds1743763handhelds
handsels12317243handsels
hansels104011653ha_nsels
harshens1437603harshens
hashes125024803ha_she_s
hassels104311013ha_ssels
hatch135719593hatch___
hatchable1944793hatchable
hatcheling1943693hatcheling
hatchelled1943013hatchelled
hatcheries1846523hatcheries
hatching173312213hatching
hatchings18225673hatchings
hatchment1945313hatchment
hatchments2043883hatchments
hatchway2243293hatchway
hatchways2342663hatchways
haters94930403hat__ers
hates86742573hat__e_s
hatfuls1386023hat_fuls
hatless103813443hat_less
hatreds11307813hat_reds
hatters104221523hat_ters
haunches1656963haunche_s
haverels14325753haverels
hazels185710083ha__zels
heathens143210153heat_hens
heathers143914733heat_hers
hitched163312253hitche_d
hitcher153712003hitche_r
hooches153812523hooche_s
hootches1656973hootche_s
hotched163610923hotche_d
hotels94515513hot__els
hunches153913463hunche_s
hutched16359883hutche_d
itches114916213_itche_s
ketches164012193ketche_s
kitchens17195783kitchens
klatches17157133klatche_s
laches116528343la_che_s
larches124416443larche_s
latched133914063latche_d
latchet123117903latche_t
latchkeys2141873latchkeys
lathers104321883lat_hers
lathes95127493lat_he_s
letches124015483letche_s
maches134827233ma_che_s
manches143818623manche_s
manchets15269573manchets
marcels113212373marc_els
marchers153710813marchers
marches143921173marche_s
matched153513963matche_d
matcher143214283matche_r
matchless1644683matchless
matchups1743073matchups
mutches143314283mutche_s
naches114622413na_che_s
nautches1336083nautche_s
notchers13279423notchers
notches123513653notche_s
parcels113712663parc_els
parches143720003parche_s
paschals1566473paschals
patched153514623patche_d
patcher143515143patche_r
patchily1885813patchily
pitchers153211483pitchers
pitches143617753pitche_s
rachets124516833ra_chets
ranchers133311793ranchers
ranches123620113ranche_s
ratchet124218333ratche_t
ratels64518213rat__els
retches123318513retche_s
rotches123515703rotche_s
sachems14348903sa_chems
sachets123914103sa_chets
satcheled1544423satcheled
schatchens2042683schatchens
slatches131511523slatche_s
snatchers14146313snatchers
snatches131410713snatche_s
swatches16169963swatche_s
taches114224173ta_che_s
thatched1735433thatche_d
thatcher1635663thatche_r
vetches153411263vetche_s
watched163012823watche_d
watcher153113403watche_r
watcheye19104273watcheye
watcheyes20103743watcheyes
witches152715793witche_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621826.97020970.2
3Display Results1821820.0762394.7
 (SQL Overall)1786911827.46923924.4
 
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.