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

194 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
satchels1332816(None) 
hatchels16368671hatchels
satchel123310301satchel_
batchers153613272batchers
batches144019612batche_s
catchers153114052catchers
catches144320762catche_s
hatchel153510752hatchel_
hatchers163113172hatchers
hatches153420272hatche_s
hatchets163310382hatchets
latches123320122latche_s
latchets133410012latchets
matchers153012432matchers
matches143219782matche_s
patchers153413302patchers
patches143320382patche_s
ratches123620462ratche_s
ratchets133110262ratchets
sachems14348902sa_chems
sachets123914102sa_chets
satcheled1544422satcheled
slatches131511522slatche_s
snatchers14146302snatchers
snatches131410712snatche_s
swatches16169962swatche_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
catchalls1645483catchalls
catcher143115823catche_r
catchfly2143333catchfly
catchups1744373catchups
catechols1655043catechols
cratches153012543cratche_s
cutches143216453cutche_s
datchas1347423datch_as
ditchers143610363ditchers
ditches133215713ditche_s
etchers123411293_etchers
etches114217763_etche_s
fathers133916503fat_hers
fetchers16328863fetchers
fetches153413893fetche_s
fitches153516193fitche_s
fitchets16307413fitchets
fitchews19274773fitchews
gathers114315063gat_hers
gauchely1742743gauchely
hatcheck2244013hatcheck
hatchecks2343593hatchecks
hatched163414463hatche_d
hatcheled1844223hatcheled
hatcher153314723hatche_r
hatchery19326383hatchery
hatchet153317563hatche_t
hitchers16379993hitchers
hitches153616273hitche_s
hotches153814363hotche_s
hutches153613523hutche_s
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
matchless1644673matchless
matchups1743063matchups
mutches143314283mutche_s
naches114622413na_che_s
nautches1336073nautche_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
saccules1237033saccules
sachem134012223sa_che_m
sachet114725773sa_che_t
sackers133820223sa_ckers
sacrals93311793sa_crals
sadhes104715373sa_dhe_s
saices84221803saic_e_s
salchows1644203salchows
samiels939763sa_miels
sashes94728483sa_she_s
satchelful1861203satchelful
satchelfuls195903satchelfuls
satchelsful196833satchelsful
sateens73710753sat_eens
sates54949323sat__e_s
satinets8311733satinets
satires72617573satire_s
saucers93712133sauc_ers
sauces84919503sauc_e_s
sauchs115112233sauch__s
sauciers1076733sauciers
saurels749293sa_urels
scathes124515713scat_he_s
schatchens2042683schatchens
schuls11299853s__chuls
scotches15179473scotche_s
scratchers1744283scratchers
scratches1647313scratche_s
scutchers16175643scutchers
scutches15168883scutche_s
searchers14197353searchers
searches132112903searche_s
seiches12513813seiche_s
shtetels1143223shtetels
sithens1039383sit_hens
sketchers1834513sketchers
sketches1746823sketche_s
slathers113914773slat_hers
smutches15177273smutche_s
snatched14157633snatche_d
snatcher13167753snatche_r
snathes104816493snat_he_s
snitchers14166043snitchers
snitches13148983snitche_s
spancels1245273spanc_els
spathes125116533spat_he_s
stackers143413563stackers
stactes91914633stacte_s
stammels12495563stammels
stanchers14206803stanchers
stanches132312793stanche_s
starches131912913starche_s
stashes103916163stashe_s
steels64117983s_t_eels
stipels9418953s_tipels
stitchers14146993stitchers
stitches131410593stitche_s
streels73811343s_treels
swathers144512073swat_hers
swathes134115513swat_he_s
switchers17146633switchers
switches16159133switche_s
taches114224173ta_che_s
thatchers1744573thatchers
thatches1637513thatche_s
vetches153411263vetche_s
watched163012823watche_d
watcher153113403watche_r
watcheye19104273watcheye
watcheyes20103743watcheyes
witches152715793witche_s

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 Limit1461621948.29617618.4
3Display Results1941940.0802425.0
 (SQL Overall)1786911948.53220943.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.