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

101 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
mason7482018(None) 
macon94519951macon
mascon103612741mascon
masons83916511masons
meson74118311meson
aeon45634612_aeon
agon56531882_agon
amazon1736832amazon
anon46134852_anon
arson55118832arson
axon115524302_axon
azon135725052_azon
bacon95620592bacon
baron78131242baron
basin75026922basin
basion84315852basion
baton75822422baton
bison75716982bison
boson76019732boson
cajon144513902cajon
canon74725302canon
capon95221872capon
damson938062damson
fanon84619012fanon
gascon9339722gascon
halon86124862halon
hyson1138692hyson
kaon87521022ka_on
macons104017242macons
macron103615672macron
magot8326392magot
mahoe10315572mahoe
main65345522ma_in
major145212922major
mako105622362mako_
makos116518362makos
malison939692malison
mammon939642mammon
man57465872ma__n
mano66536812mano_
manor78023932manor
manos74933622manos
mansion9611542mansion
maroon83118202maroon
marron83717542marron
mas58175822mas__
masa65034722mas_a
masas75630412masas
mascons113411582mascons
mascot104016072mascot
maser75029972maser
mash96039402mas_h
mashy136016502mashy
mask105227362mas_k
masks115320532masks
masoned1039802masoned
masonic1139912masonic
masonry1244122masonry
mass66044942mas_s
massa75518922massa
masse75125292masse
massy104518962massy
mast65959962mas_t
masts77035762masts
matin75132852matin
matron83918312matron
maun65727212ma_un
maven104816892maven
mavin105722952mavin
mawn94424142ma_wn
mayan105616902mayan
mayo96524302mayo_
mayor106616622mayor
mayos105521932mayos
melon73922082melon
mesons83215842mesons
miso67229902miso_
misos76523292misos
mon57561582m__on
moon67140812m_oon
moron76925422moron
muon65722732m_uon
muton73817002muton
nasion63914082nasion
paeon74819492paeon
parson83817902parson
racon75422142racon
radon64620502radon
ramson8310462ramson
rayon83815702rayon
reason62616332reason
salon55228552salon
sasin54626572sasin
season62714902season
son37761952__son
talon55824112talon
tauon54816582tauon
taxon124414662taxon
wagon94312952wagon
weason93210822weason
yapon104613582yapon

Search took 3 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 Limit538001012.12625305.7
3Display Results1011010.0137769.2
 (SQL Overall)1786911012.45272875.6
 
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.