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 “macon” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
macon9451995(None) 
bacon95620591bacon
macons104017241macons
macron103615671macron
mascon103612741mascon
mason74820181mason
racon75422141racon
acorn75616622_acorn
aeon45634612_aeon
agon56531882_agon
amazon1736832amazon
ancon75718232ancon
anon46134852_anon
axon115524302_axon
azon135725052_azon
bacons104917582bacons
baron78131242baron
baton75822422baton
beacon10511372beacon
cajon144513902cajon
canon74725302canon
capon95221872capon
con510268022__con
dacron94310692dacron
deacon9510422deacon
falcon11310292falcon
fanon84619012fanon
flacon1138632flacon
garcon92912482garcon
gascon9339722gascon
halon86124862halon
icon66922042_icon
kaon87521022ka_on
limacon1144142limacon
mac78053932mac__
macaw12311762macaw
mace87345792mac_e
maced108528692maced
macer912126942macer
maces97139962maces
mach116134482mac_h
mache125925302mache
macho126120152macho
machos135217492machos
machs125722562machs
macing114221552macing
mack125733652mac_k
macks135127602macks
macle96127002macle
macro94718172macro
macrons113514892macrons
macros104017012macros
macs86742512mac_s
magot8326392magot
mahoe10315572mahoe
main65345522ma_in
major145212922major
mako105622362mako_
makos116518362makos
mammon939642mammon
man57465872ma__n
mano66536812mano_
manor78023932manor
manos74933622manos
maroon83118202maroon
marron83717542marron
mascons113411582mascons
mascot104016072mascot
masons83916512masons
matin75132852matin
matron83918312matron
maun65727212ma_un
maven104816892maven
mavin105722952mavin
mawn94424142ma_wn
mayan105616902mayan
mayo96524302mayo_
mayor106616622mayor
mayos105521932mayos
melon73922082melon
meson74118312meson
micron103714282micron
mon57561582m__on
moon67140812m_oon
moron76925422moron
mucin93116822mucin
mucor94011942mucor
muon65722732m_uon
muton73817002muton
paeon74819492paeon
racons84319342racons
racoon83814472racoon
radon64620502radon
rayon83815702rayon
recon75624242recon
salon55228552salon
taco67031352taco_
tacos77023552tacos
talon55824112talon
tauon54816582tauon
taxon124414662taxon
wagon94312952wagon
yapon104613582yapon

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001031.40638264.6
3Display Results1031030.0137923.1
 (SQL Overall)1786911031.732103170.3
 
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.