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

206 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
azaleas163699(None) 
azalea1537001azalea_
azoles154614612azole_s
galeas74618512_galeas
aaliis6312903a_aliis
aals49941143a_al__s
abacas104414723aba_cas
abakas123911743aba_kas
abasers95311973abasers
abases85720773abase_s
abasias9711013abasias
abaters95115203abaters
abates85825033abate_s
abayas114011703aba_yas
abeles84719393abele_s
abelias93213563abelias
ables75935543a_ble_s
abulias93210693abulias
acacias11510403acacias
acaleph1453443acaleph
acalephs1542993acalephs
aculeus937513aculeus
adages8412953adage_s
addles84216603addle_s
agamas97413453aga_mas
agapes95212413agape_s
agates76121343agate_s
agaves104611513agave_s
ageless8310343ageless
agleam9158623a_gleam
aglets73915683a_glets
aidless83612073aidless
aiglets84012913aiglets
aimless93610813aimless
airless73712043airless
aisles64721143aisle_s
akelas10311193akel_as
alamedas1145443alamedas
alas46358123__al_as
alaskas1136683alaskas
alates64833973alate_s
albas75925393__albas
alecs76620733__alecs
alefs87319663__alefs
ales47067103__ale_s
alfalfas1441953alfalfas
alfas87219043__alfas
algas65624933__algas
alias55834603__alias
allees64521483a_llees
alleys95113303a_lleys
almas76629773__almas
altheas1038233altheas
amalgam1244923amalgam
amalgams1343203amalgams
amazes175613473amaze_s
amblers115213563amblers
ambles105121863amble_s
amoles84122193amole_s
amulets939923amulets
anabas8314083ana_bas
anableps1243123anableps
anadems1036143anadems
analects1047703analects
analemmas13103583analemmas
analgias9107803analgias
analogs82810453analogs
aneles64626293anele_s
anglers84014823anglers
angles74426703angle_s
ankles104818383ankle_s
anklets114310413anklets
anlas55626933a_nl_as
anoles64827433anole_s
antlers74014743antlers
apneas83211383a_pneas
apnoeas946353apnoeas
apples104315763apple_s
applets115710063applets
arables91814973arable_s
arames84622573arame_s
areas55935773__areas
argalas84011093argal_as
argles75218483argle_s
arles56735743a_rle_s
armless9369943armless
armlets94610063armlets
artless73712513artless
asanas6514113asa_nas
ashlers10319583ashlers
ashless10318453ashless
atalayas1144783atalayas
ataxias14189343ataxias
atlas55821583a_tl_as
auklets11298573auklets
awakens14416153awakens
awakes135012473awake_s
aweless1038723aweless
awless939263a_wless
awnless1035923awnless
axillas14278963axillas
axles125219473a_xle_s
azans146516883aza__ns
azides165113803azide_s
azines155517073azine_s
azlons154110423az_lons
azole145118033azole__
azotes154312223azote_s
azulejo2341483azulejo
azulejos2441293azulejos
azures15510183azure_s
balas76937213_bal_as
balers85626933_balers
bales76250083_bale_s
balsas86417523_balsas
befleas1236973befleas
braless92910563braless
cabalas113516003cabal_as
calesa8412473_calesa
calesas9411833_calesas
callas84526753_callas
catalpas1246733catalpas
cavallas1366843cavallas
chalehs15268803chalehs
chalets122813473chalets
challas124414123challas
coalas87418963coal_as
coalers94419353coalers
czardas1934673czardas
dales66439743_dale_s
dazzlers1733233dazzlers
dazzles1636413dazzle_s
dealers84118613dealers
defleas1147223defleas
dialers83614303dialers
fleas86423663__fleas
galas65731643_gal_as
galateas937153galateas
galea64722943_galea_
galeae74717453_galeae
galenas83310343_galenas
gales65442483_gale_s
gazanias1845733gazanias
halalas104214083halal_as
halers94926913_halers
hales85449843_hale_s
halmas117017893_halmas
halvas124714173_halvas
hawalas13348353hawal_as
healers104319463healers
jacales16310323jacale_s
kabalas133911063kabal_as
kales95730983_kale_s
kalpas124112943_kalpas
kamalas13339123kamal_as
koalas104011663koal_as
lazarets1744803lazarets
leas45954183___leas
males75049793_male_s
masalas9312053masal_as
nalas55528363_nal_as
naleds7469133_naleds
nyalas936903nyal_as
ozalids1794063ozalids
palea75028663_palea_
paleae84820293_paleae
paleal84716673_paleal
pales75753803_pale_s
palets85122313_palets
panaceas1236763panaceas
pleas75627033__pleas
qabalas18289503qabal_as
queleas1636723queleas
rales54947493_rale_s
reales64934123reale_s
saleps85014903_saleps
sales56055593_sale_s
salpas85116923_salpas
salsas65316133_salsas
scalers93817263scalers
scales84529313scale_s
sealers74323553sealers
shales94731253shale_s
spales84728103spale_s
stales65538293stale_s
swales93920763swale_s
talas55935893_tal_as
talers64628143_talers
tales55451373_tale_s
tamales93216153tamale_s
thalers106212263thalers
vales85434263_vale_s
valets93715623_valets
vealers103214293vealers
walers94824463_walers
wales86142833_wale_s
wallas95719393_wallas
whalers13529703whalers
whales124716943whale_s
yamalkas1743103yamalkas
zamias174212923_zamias
zanzas1487053_zanzas
zarebas1836303_zarebas
zaxes215113823_zaxe_s
zazens1435833_zazens
zoeas145815613_z_oeas

Search took 8 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.423422437.4
2DLD Change Limit1340272066.62320236.6
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.12625075.9
 
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.