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

279 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
azonal156827(None) 
agonal7410051agonal
atonal6514021atonal
axonal1347651axonal
zonal145116851_zonal
aboral8314372aboral
ammonal1137012ammonal
amoral8314622amoral
anal48037522a__nal
anconal939422anconal
annal56520762a_nnal
anodal72512112anodal
apodal9289822apodal
avowal1246322avowal
azon135725052azon__
azonic175513152azonic
azons146518252azon_s
bizonal1845562bizonal
clonal8310912clonal
phonal11310382phonal
tonal53724302_tonal
zoeal144813782_zoeal
zona136321962_zona_
zonae145116442_zonae
zoonal1558082zoonal
aal39058673a___al
aboil72217543abo_il
abolla8410193abolla
aboma91114603aboma_
abomas101113583abomas
acetal84314903acetal
acinar8310483acinar
actinal9312293actinal
actual8311023actual
adenyl1035023adenyl
adonis7314063adonis
adrenal838263adrenal
aecial84817313aecial
aeon45634613aeon__
aeonian738353aeonian
aeonic83517043aeonic
aeons57624653aeon_s
aerial64625713aerial
affinal1336443affinal
afoul8510193afo_ul
agnail739523a_gnail
agon56531883agon__
agone65924553agon_e
agones75719863agones
agonic93515143agonic
agons66423783agon_s
agony96415653agon_y
agora6914333agora_
agorae7511203agorae
agoras7613343agoras
ajowan1634893ajowan
alanyl955483alanyl
albinal937813albinal
algal66518213a_lgal
alodial899953alodial
aloha8513613aloha_
alohas9411703alohas
alone55732963alon_e
along65419493alon_g
ammonals1245393ammonals
among85813303amon_g
ana39559823a__na_
anas46649863a__nas
anconeal1045593anconeal
anginal8310163anginal
anil46437433a__nil
animal85016253animal
anna45529013a_nna_
annals66415923a_nnals
annas55824883a_nnas
anneal64812293anneal
annona648873annona_
annonas738793annonas
annual64710703annual
annul55813383a_nnul
anoa45634473ano_a_
anoas57226493ano_as
anomaly1238843anomaly
anon46134853anon__
anonym1136383anonym
anorak1038923anorak
antral65719413antral
anural65714743anural
aortal65217513aortal
apical10913903apical
apneal83411123apneal
apnoeal956193apnoeal
apogeal1045613apogeal
appal95315223a_ppal
appeal103911613appeal
areal55928733a_real
arena55323813arena_
arenas65021993arenas
argal65023383a_rgal
aroma71220143aroma_
aromas81018613aromas
arousal748633arousal
arsenal739383arsenal
artal55525473a_rtal
arval86017013a_rval
asana5315483asana_
asanas6514113asanas
asocial998653asocial
astral66919283astral
atabal839743atabal
atoll57913923ato_ll
atonable1038793atonable
atonally1148633atonally
atone56527983aton_e
atoned75417543atoned
atoner64817193atoner
atones65225773atones
atonia63816513atonia
atonias73315993atonias
atonic83420473atonic
atony87218853aton_y
atrial65418943atrial
audial7312993audial
aural54428963a_ural
auroral7310473auroral
avowals1335013avowals
awol75620673awo__l
axal116520493a__xal
axial124515193a_xial
axon115524303axon__
axone125918473axon_e
axonemal1743543axonemal
axones134614513axones
axonic154312723axonic
axons125517933axon_s
azan136521783az__an
azans146516883azan_s
azine146721413azin_e
azines155517073azines
azlon144312873azlon__
azlons154110423azlon_s
azo128233393azo___
azoic162912063azo_ic
azole145118033azo_le
azoles154614613azoles
azote144416343azo_te
azoted16388593azoted
azotes154312223azotes
azoth17389903azo_th
azoths18366203azoths
azotic172711623azotic
banal75925993_banal
baronial1049483baronial
basinal9310033basinal
binal75323823_binal
boral75831703_boral
bromal10313653bromal
canal75428043_canal
cantonal1038903cantonal
canzona1836073canzona_
canzonas1935383canzonas
caporal11410943caporal
carinal94318223carinal
carnal83919203carnal
choral115118493choral
clinal8311553clinal
coal66939253_co_al
comal95125133_comal
copal95621783_copal
coral76033453_coral
coronal94115763coronal
coxal146116673_coxal
diaconal1196133diaconal
diagonal1095653diagonal
domal85619203_domal
dona55529633_dona_
donas65926473_donas
dotal64919623_dotal
faunal94711593faunal
final83922033_final
floral94313813floral
foal76630923_fo_al
focal104917673_focal
fontal9313143_fontal
frontal1038363frontal
global937663global
goal55829303_go_al
gonad75216053_gonad
gooral7310463gooral
goral65125753_goral
honan85319773_honan
horal86328673_horal
hymnal1434913hymnal
joual12311653_joual
krona93611793krona_
lacunal9136553lacunal
lagoonal943093lagoonal
laminal94113633laminal
lienal63912783lienal
local74820273_local
loral55927823_loral
loyal84513483_loyal
matinal9312603matinal
matronal1048113matronal
mayoral1237683mayoral
modal85919233_modal
molal75120343_molal
monad85519473_monad
monas74732153_monas
moral75533433_moral
national8311533national
nodal64717793_nodal
nona46929063_nona_
nonas55126653_nonas
nonyl849773_nonyl
nopal75517103_nopal
notal55221353_notal
nounal639813nounal
opal66923523__opal
oral47638123__oral
oval77119523__oval
ozonate1646863ozonate
ozone14310613ozon_e
ozones1539393ozones
ozonic17308943ozonic
paginal10269493paginal
patronal1048653patronal
penal75228373_penal
pinnal84814273pinnal
pleonal937243pleonal
ramona8412413ramona_
ramonas9311093ramonas
rational8412543rational
regnal74812933regnal
renal55929503_renal
rhinal9510183rhinal
royal85014703_royal
seasonal847263seasonal
seconal9310073seconal
shoal83920263sho_al
signal73711483signal
skoal93811453sko_al
sonar56523423_sonar
spinal84915313spinal
sponsal946333sponsal
sporal82915453sporal
stomal85213313stomal
tarnal63716503tarnal
thenal92712413thenal
total55321823_total
trinal6516953trinal
trona54118953trona_
tronas63816893tronas
umbonal1144383umbonal
urinal6614123urinal
vaginal11288403vaginal
veinal93812963veinal
venal85523213_venal
vernal93514213vernal
vinal85725813_vinal
vocal104715643_vocal
zeal135530333_z_eal
zoa128529993_zo_a_
zocalo1735803_zocalo
zoea137118423_zoea_
zoeae144412483_zoeae
zoeas145815613_zoeas
zonally1938003_zonally
zonary1838793_zonary
zonate154114923_zonate
zone135231083_zon_e
zoned154020263_zoned
zoner144520343_zoner
zones145528043_zones
zonk175018623_zon_k
zonks184815173_zonks
zonula1537223_zonula
zonule1577483_zonule
zoril143916693_zoril

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162799.14012332.2
3Display Results2792790.0933000.0
 (SQL Overall)1786912799.35919093.0
 
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.