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 “machete” 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
machete1431088(None) 
machetes1539631machetes
achene11313812_achene
cachet134526412cachet_
cacheted16148232cacheted
cachets145014262cachets
facete115014832fac_ete
mache125925302mach__e
maches134827232mache_s
machine14313492machine
machree1438512machree
manchet143317772manchet_
manchets15269572manchets
marchese15358912marchese
rachet115028972rachet_
racheted14149502racheted
rachets124516832rachets
sachet114725772sachet_
sacheted14127832sacheted
sachets123914102sachets
accede1138293_accede
accrete1137843accrete
aceta74017353_ac_eta
ache96829823_ach__e
ached119227833_ache_d
achenes12313493_achenes
aches106132293_ache_s
achieve1545023_achieve
achiote1239213_achiote
ackee115825363_acke_e
acuate8315633_acuate
acute74720363_ac_ute
adhere10310333_adhere
arete56031353_a_rete
athlete1068083_athlete
baccate131011263baccate
bached145519893bache_d
baches135426943bache_s
brachet144020313brachet_
brachets154311983brachets
cache125122483cach__e
cached145419203cache_d
caches137926913cache_s
cachexy2443283cachexy
catheter1338153catheter
cete64934783__c_ete
cheth135013823__cheth
chute104316463__chute
dacite91115883dac_ite
emaciate1248753emaciate
esthete1047433esthete
excrete1667163excrete
facet106038523fac_et_
faceted13509563fac_eted
facets116316653fac_ets
gamete9313593ga_mete
hachure1545723hachure
hackee154921833hacke_e
hatchet153317563hatchet_
hatchets163310383hatchets
jacket194720673jacket_
jacketed22146533jacketed
jackets205011373jackets
laches116528343lache_s
lactate9312693lactate
latchet123117903latchet_
latchets133410013latchets
leachate1347443leachate
lichee114017973liche_e
lychee143710893lyche_e
macabre1335223macabre
macaque2044053macaque
macchie1647193macchie
mace87345783mac___e
maced108528693mac_e_d
macer912126943mac_e_r
macerate122314073macerate
macers105321273mac_ers
maces97139963mac_e_s
mach116134473mach___
machinate1647953machinate
machined1637303machined
machines15312883machines
macho126120153mach__o
machos135217493mach_os
machrees1545503machrees
machs125722563mach__s
machzor2344263machzor
mackerel1644863mackerel
mackle143716433mac_kle
macle96127003mac__le
macled116718113macle_d
macles107023223macle_s
macrame1338713macrame
maculae113412863maculae
maculate122815623maculate
macule104115273mac_ule
magnate10512703magnate
magnet9320663magnet_
magneto1046743magneto
magnets10311143magnets
mahoe10315573ma_h_oe
maihem1366213maihe_m
maihems1444303maihems
malachite1666023malachite
malate84624553ma_late
maleate94117543maleate
mallee84525593malle_e
mallet84433053mallet_
mallets93318493mallets
mammate104411273mammate
mammee94417853mamme_e
mammet94319253mammet_
mammets103911113mammets
manatee9317663manatee
manche133515103manch__e
manches143818623manche_s
mandate10315573mandate
manege94113203ma_nege
manhole12311343manhole
mannite9312903mannite
maquette1946113maquette
marched153813403marche_d
marchen143312073marche_n
marcher143912973marche_r
marchers153710813marchers
marches143921173marche_s
marchesa15346883marchesa
marchesi15337323marchesi
market123226043market_
marketed1537323marketed
marketer1437383marketer
markets133314033markets
marlite92917073marlite
marmite112413993marmite
mashed125325043mashe_d
masher114123203mashe_r
mashers124621053mashers
mashes115030003mashe_s
mashie11315933mash_ie
masseter1037063masseter
matched153513963matche_d
matcher143214283matche_r
matchers153012433matchers
matches143219783matche_s
mate65154213ma___te
matte75626843ma__tte
maumet103518883maumet_
maumets11369693maumets
mayhem1644923mayhe_m
mayhems1763413mayhems
mete64438133m___ete
miche126219243mich__e
miched143913393miche_d
miches134320733miche_s
moschate1546583moschate
muches134718993muche_s
mycele1335853myc_ele
naches114622413nache_s
naivete1055663naivete
packet144726503packet_
packeted17148283packeted
packets155114773packets
raceme1039733rac_eme
racket125229423racket_
racketed15169123racketed
rackets134916873rackets
rackety16499113rackety
raclette1047643raclette
ratchet124218333ratchet_
ratcheted1554783ratcheted
ratchets133110263ratchets
rochet115423003rochet_
rochets124213473rochets
saccate111311763saccate
sachem134012223sache_m
sachems14348903sachems
scheme1379633_scheme
secrete9311073secrete
tacet75840023tac_et_
tache106222373tach__e
taches114224173tache_s
tachiste1356213tachiste
tacket124627493tacket_
tackets134914363tackets
tracheae1349103tracheae
tracheate1448233tracheate
trachyte1645943trachyte
vacate11314553vac_ate
watcheye19104273watcheye
yacht13417393yach_t_
yachted1634853yachted
yachter1534913yachter
yachts1437023yach_ts

Search took 10 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.313570897.8
2DLD Change Limit1340271948.79615237.3
3Display Results1941940.0802425.0
 (SQL Overall)1786911949.18919446.2
 
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.