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

212 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
amazon173683(None) 
amazons1836651amazons
amadou977612amadou
amain74922912ama_in
amarone9311202amarone
amatol838692amatol
amaze166016602amaz_e
amazed18519312amazed
amazes175613472amazes
amazing1938812amazing
amnion84812052amnion
azon135725052__azon
blazon1736762blazon
macon94519952_macon
mason74820182_mason
abalone938903abalone
abandon1045463abandon
abator84512723abator
aboon74918703a_boon
acajou1595233acajou
action84719683action
adman84517903adma__n
aeon45634613__aeon
again65218123aga_in
agaze156113663agaz_e
agon56531883__agon
alamo7418143alamo_
alamos8415003alamos
alan46844083ala__n
alanin6317273alanin
alation72920553alation
ama510853303ama___
amadous1038503amadous
amah98927493ama__h
amahs107819063ama_hs
amarna839793amarna
amarones10311353amarones
amas67746293ama__s
amass77119683ama_ss
amatols938183amatols
amatory1238643amatory
amazonian2053113amazonian
amazonite2044213amazonite
ambo88225143am_bo_
ambos95321253am_bos
ameban1039103ameban
amen66733153am__en
amidin94015673amidin
amido85720993amido_
amidol9489573amidol
amidone10349313amidone
amigo86515473amigo_
amigos94511213amigos
amin66042253am__in
amino75425503amino_
ammino1069883ammino
ammo85520133am_mo_
ammono1047373am_mono
ammos94815823am_mos
amnio75218053amnio_
amnions93710913amnions
amnios84912523amnios
amok10217403am__ok
among85813303am__ong
amotion9710473amotion
analog7159973analog
ancon75718233a_ncon
anion55028813a_nion
anon46134853__anon
anyon85615223a_nyon
apron7318833a_pron
archon11311753archon
argon65520593a_rgon
arson55118833a_rson
aswoon947013aswoon
ataman81013063ataman
atman75520143atma__n
avion84218343a_vion
awaken13468863awaken
axion1211316913a_xion
axman144813183axma__n
axon115524303__axon
azan136521783__azan
azlon144312873a_zlon
azo128233393__azo_
azons146518253__azons
bacon95620593_bacon
baron78131243_baron
baton75822423_baton
bazoo163815673_bazoo
beacon10511373beacon
blazons1836163blazons
brazen174812453brazen
cabezon2044663cabezon
cajon144513903_cajon
camion103917193cam_ion
campion133011413campion
canon74725303_canon
capon95221873_capon
chazan20269133chazan
claxon1536583claxon
craton84517193craton
crayon114110003crayon
dalapon1044893dalapon
daman84821163dama__n
damson938063dam_son
danazol1743253danazol
deacon9510423deacon
diazin1639163diazin
diazo15310033diazo_
dragon838843dragon
emblazon2143023emblazon
etalon648973etalon
fanon84619013_fanon
flacon1138633flacon
flagon1037983flagon
gammon1138903gam_mon
gazoo153112873_gazoo
halazone2046113halazone
halon86124863_halon
hazan173813613_hazan
imago8118693imago_
imagos9117553imagos
kaon87521033_ka_on
kazoo183311533_kazoo
khazen2233773khazen
klaxon1733853klaxon
lampion11278303lampion
lampoon11267193lampoon
limacon1144143limacon
macons104017243_macons
macron103615673macron
madzoon1996063madzoon
magot8326393_magot
mahoe10315573_mahoe
mahzor2035113mahzor
main65345523_ma_in
major145212923_major
mako105622363_mako_
makos116518363_makos
mammon939643mammon
man57465873_ma__n
mano66536813_mano_
manor78023933_manor
manos74933623_manos
maroon83118203maroon
marron83717543marron
mascon103612743mascon
masons83916513_masons
matin75132853_matin
matron83918313matron
matzo16312893matzo_
matzoh2035483matzoh
matzoon1896473matzoon
matzos1749263matzos
matzot17710983matzot
maun65727213_ma_un
maven104816893_maven
mavin105722953_mavin
mawn94424143_ma_wn
mayan105616903_mayan
mayo96524303_mayo_
mayor106616623_mayor
mayos105521933_mayos
maze155434983_maz_e
mazed175523873_mazed
mazer165722423_mazer
mazes165632173_mazes
mazing184418973_mazing
mazy186419703_maz_y
melon73922083_melon
menazon1846053menazon
meson74118313_meson
mizen164815273_mizen
mon57561583_m__on
moon67140813_m_oon
moron76925423_moron
mozo157719743_mozo_
mozos165516333_mozos
muon65722733_m_uon
muton73817003_muton
paeon74819493_paeon
paragon10311023paragon
parazoan1946553parazoan
racon75422143_racon
radon64620503_radon
rampion11298583rampion
ramson8310463ram_son
rayon83815703_rayon
razor143012603_razor
reason62616333reason
sabaton937713sabaton
sabayon1244233sabayon
sacaton938993sacaton
salon55228553_salon
season62714903season
smaze165012933smaz_e
smazes174311663smazes
talon55824113_talon
tamarin9311923tamarin
tampion11298663tampion
tampon102911233tam_pon
tauon54816583_tauon
taxon124414663_taxon
wagon94312953_wagon
wazoo173011173_wazoo
weakon13357623weakon
weapon11288113weapon
weason93210823weason
yapon104613583_yapon
zacaton1845633zacaton
zazen1337283_zazen

Search took 7 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 Filter1786911127160.470380193.6
2DLD Change Limit1127162126.01618736.0
3Display Results2122120.0603533.3
 (SQL Overall)1786912126.54627297.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.