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

234 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
latchets13341001(None) 
hatchets163310381hatchets
latches123320121latche_s
latchet123117901latchet_
ratchets133110261ratchets
batchers153613272batchers
batches144019612batche_s
cachets145014262ca_chets
catchers153114062catchers
catches144320772catche_s
fitchets16307412fitchets
hatchels16368672hatchels
hatchers163113172hatchers
hatches153420272hatche_s
hatchet153317562hatchet_
klatches17157132klatche_s
laches116528342la_che_s
lancets93411162lanc_ets
larches124416442larche_s
latched133914062latche_d
latchkeys2141872latchkeys
lathers104321882lat_hers
lathes95127492lat_he_s
letches124015482letche_s
manchets15269572manchets
matchers153012432matchers
matches143219782matche_s
patchers153413302patchers
patches143320382patche_s
planchets16236742planchets
rachets124516832ra_chets
ratches123620462ratche_s
ratchet124218332ratchet_
sachets123914102sa_chets
satchels13328162satchels
slatches131511522slatche_s
watchers163511792watchers
watches153017372watche_s
aches106132293_a_che_s
aitches123014363aitche_s
altheas1038223alt_heas
archers124414573_archers
arches114822043_arche_s
baches135426943ba_che_s
batched154114243batche_d
batcher144414853batche_r
bathers124720363bat_hers
bathes116524833bat_he_s
bitches144117063bitche_s
blanchers16307433blanchers
blanches153311603blanche_s
blathers134713793blat_hers
blotches1537433blotche_s
botchers153511543botchers
botches143716023botche_s
brachets154311983brachets
butchers153710183butchers
butches144315363butche_s
caches137926913ca_che_s
cachet134526413ca_chet_
catcher143115823catche_r
catchiest1638313catchiest
catchments1944453catchments
catchups1744383catchups
cathects1545793cat_hects
clutches15307923clutche_s
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
flatlets1147373flat_lets
fletchers17335533fletchers
fletches16308853fletche_s
flitches16388463flitche_s
gathers114315073gat_hers
gauchest1436293gauchest
glitches14296653glitche_s
hatcheck2244013hatcheck
hatchecks2343593hatchecks
hatched163414463hatche_d
hatchel153510753hatche_l
hatcher153314723hatche_r
hatchery19326383hatchery
hatchments2043883hatchments
hitchers16379993hitchers
hitches153616273hitche_s
hotches153814363hotche_s
hutches153613523hutche_s
itches114916213_itche_s
jackets205011373ja_ckets
ketches164012193ketche_s
kitchens17195783kitchens
klatsches1842223klatsche_s
labrets939363la_brets
lacers85225253la_c_ers
laces76141763la_c_e_s
laciest93819033la_ciest
lackers134120543la_ckers
lackeys16458263la_ckeys
lactates10311223lactates
laichs115110893laich__s
lancelets1144833lancelets
lancers93616643lanc_ers
lances84824103lanc_e_s
lancet84223573lanc_et_
lanciers10308543lanciers
languets987243languets
lappets11329123la_ppets
larchen12479623larche_n
lashers104121833la_shers
lashes94831003la_she_s
latch104620463latch___
latching143712023latching
latchkey2042913latchkey
lateens74210553lat_eens
lateness82614073lateness
latens64620213lat__ens
latents75214313lat_ents
latest63822703lat__est
latests73910313lat_ests
latexes1438313latexe_s
lathe85626713lat_he__
lathed104718453lat_he_d
lather95124353lat_he_r
lathery133911123lat_hery
lathiest11312653lathiest
lathis95516173lat_h_is
laths86022403lat_h__s
latices9313763latice_s
latkes104715873lat_ke_s
lattens75014673lat_tens
lattes65324203lat_te_s
laughers1235923laughers
launchers1454333launchers
launches1387903launche_s
lazarets1744803lazarets
leachers133712813leachers
leaches123319343leache_s
leathers114215083leat_hers
lechers123313963l_echers
leches115421313l_eche_s
leeches123911933leeche_s
letched133912053letche_d
lethes94818083let_he_s
lichees123512783l_ichees
lichens123510683l_ichens
liches114724293l_iche_s
lichts113712383l_ich_ts
litchis1238373litch_is
lithest10513913lit_hest
loaches123613983loache_s
loathers113310443loat_hers
loathes103513243loat_he_s
lockets134612203l_ockets
lunchers13349563lunchers
lunches124115443lunche_s
lurchers13307153lurchers
lurches123311663lurche_s
lychees15516783l_ychees
lyches144213613l_yche_s
lynchers16285453lynchers
lynches15378873lynche_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
placets113911223pla_c_ets
plackets1646583pla_ckets
planches153111863planche_s
planchet152511963planchet_
platelets1165763platelets
rachet115028973ra_chet_
rackets134916873ra_ckets
ranchers133311793ranchers
ranches123620113ranche_s
ratcheted1554783ratcheted
retches123318513retche_s
rochets124213473_rochets
rotches123515703rotche_s
sachems14348903sa_chems
sachet114725773sa_chet_
satchel123310303satche_l
satinets8311733satinets
slathers113914783slat_hers
snatchers14146313snatchers
snatches131410713snatche_s
swatches16169963swatche_s
taches114224173ta_che_s
tackets134914363ta_ckets
thatchers1744583thatchers
thatches1637513thatche_s
unlatches1444293unlatche_s
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.423422437.4
2DLD Change Limit1461622347.50019488.3
3Display Results2342340.0763078.9
 (SQL Overall)1786912347.99922339.2
 
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.