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

355 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
agonal741005(None) 
atonal6514021atonal
axonal1347651axonal
azonal1568271azonal
aboral8314372aboral
agnail739522ag_nail
agon56531882agon__
agone65924552agon_e
agones75719862agones
agonic93515142agonic
agons66423782agon_s
agony96415652agon_y
agora6914332agora_
agorae7511202agorae
agoras7613342agoras
ammonal1137012ammonal
amoral8314622amoral
anal48037522a__nal
anconal939422anconal
anginal8310162anginal
annal56520762a_nnal
anodal72512112anodal
apodal9289822apodal
avowal1246322avowal
clonal8310912clonal
diagonal1095652diagonal
goal55829302_go_al
gonad75216052_gonad
goral65125752_goral
lagoonal943092lagoonal
paginal10269492paginal
phonal11310382phonal
tonal53724302_tonal
vaginal11288402vaginal
zonal145116852_zonal
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
aga410447233ag__a_
agama85815573agama_
agamas97413443agamas
agapae9388043agapae
agapai9456843agapai
agar58726413ag__ar
agas55938843ag__as
agency1237033agency
agenda837253agenda
agendas936933agendas
agene65621583agen_e
agenes74720253agenes
agent65829643agen_t
agential958153agential
agents74816293agents
agha87417303ag_ha_
aghas97014873ag_has
agin56132713agin__
aging77026353agin_g
agings86312673agings
agita6315423agita_
agitas7310593agitas
agleam9158623agleam
agma77623263ag_ma_
agmas85919873ag_mas
agnails837003ag_nails
agnate73314873ag_nate
ago48845523ago___
agog68019003ago__g
agonies83016623agonies
agonise83112693agonise
agonist82615403agonist
agonize172911403agonize
agorot7414993agorot
agouti7388763agouti
agouty10366913agouty
agria65517143agria_
agrias74315393agrias
ajowan1634893ajowan
alanyl955483alanyl
albinal937813albinal
algal66518213a_lgal
alodial899953alodial
aloha8513613aloha_
alohas9411703alohas
alone55732963alon_e
along65419493alon_g
ammonals1245393ammonals
among85813303amon_g
ana39559823a__na_
anas46649863a__nas
anconeal1045593anconeal
angina7413133angina_
anginas8310953anginas
angora71111573angora_
angoras8811363angoras
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
argental947933argental
argol65317263argo__l
argon65520593argon__
argonaut946773argonaut
argons75018203argon_s
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
augural856403augural
aural54428963a_ural
auroral7310473auroral
avowals1335013avowals
awol75620673awo__l
axal116520493a__xal
axial124515193a_xial
axon115524303axon__
axone125918473axon_e
axonemal1743543axonemal
axones134614513axones
axonic154312723axonic
axons125517933axon_s
azon135725053azon__
azonic175513153azonic
azons146518253azon_s
banal75925993_banal
baronial1049483baronial
basinal9310033basinal
binal75323823_binal
bizonal1845563bizonal
boral75831703_boral
bromal10313653bromal
canal75428043_canal
cantonal1038903cantonal
caporal11410943caporal
carinal94318223carinal
carnal83919203carnal
choral115118493choral
clinal8311553clinal
coal66939253_co_al
cognac1157273cognac
comal95125133_comal
copal95621783_copal
coral76033453_coral
coronal94115763coronal
coxal146116673_coxal
dagoba1074943dagoba_
dagobas1145143dagobas
decagonal1343723decagonal
diaconal1196133diaconal
diagonals11114283diagonals
dognap1035343dognap
domal85619203_domal
dona55529633_dona_
donas65926473_donas
dotal64919623_dotal
egal55119433eg__al
faunal94711593faunal
final83922033_final
floral94313813floral
foal76630923_fo_al
focal104917673_focal
fontal9313143_fontal
frontal1038363frontal
gal46055513_g__al
gaol56925413gao__l
gavial10310083gavial
gayal9312713_gayal
genial74917613_genial
gingal81010143_gingal
glial66715433_glial
global937663global
gnar56021383_g_nar
gnarl65115573_g_narl
gnat56034433_g_nat
gnaw86515743_g_naw
goa47343803_go_a_
goad66830983_go_ad
goals65521293_go_als
goas55239943_go_as
goat56250833_go_at
goban84414073_goban
gonadal956523_gonadal
gonads84511733_gonads
gone55639043_gon_e
gonef95221293_gonef
goner66025163_goner
gong66827193_gon_g
gongs74921613_gongs
gonia64117533_gonia
gonif94320923_gonif
gonof95218653_gonof
gonzo15310243_gonzo
gooral7310463gooral
gorals76917653_gorals
gowan95415743_gowan
graal64316503_graal
gyral94412783_gyral
hexagonal2062663hexagonal
honan85319773_honan
horal86328673_horal
hymnal1434913hymnal
imaginal1144903imaginal
isogonal944673isogonal
jargonel1643683jargonel
joual12311653_joual
krona93611793krona_
lacunal9136553lacunal
laguna7127223laguna_
lagunas8156823lagunas
laminal94113633laminal
lienal63912783lienal
local74820273_local
loral55927823_loral
loyal84513483_loyal
magical1239783magical
mangonel1185763mangonel
marginal1137603marginal
matinal9312603matinal
matronal1048113matronal
mayoral1237683mayoral
modal85919233_modal
molal75120343_molal
monad85519473_monad
monas74732153_monas
moral75533433_moral
nagana748943nagana_
naganas847983naganas
national8311533national
nodal64717793_nodal
nona46929063_nona_
nonagonal1055263nonagonal
nonas55126653_nonas
nonyl849773_nonyl
nopal75517103_nopal
notal55221353_notal
nounal639813nounal
octagonal1242643octagonal
ogival1035873ogival
oogonial945253oogonial
opal66923523__opal
oral47638123__oral
oval77119523__oval
pagoda10487873pagoda_
pagodas11367553pagodas
patronal1048653patronal
penal75228373_penal
pinnal84814273pinnal
pleonal937243pleonal
ramona8412413ramona_
ramonas9311093ramonas
rational8412543rational
reginal84814293reginal
regional9438783regional
regnal74812933regnal
renal55929503_renal
rhinal9510183rhinal
royal85014703_royal
seasonal847263seasonal
seconal9310073seconal
shoal83920263sho_al
signal73711483signal
skoal93811453sko_al
sonar56523423_sonar
spinal84915313spinal
sponsal946333sponsal
sporal82915453sporal
stomal85213313stomal
tarnal63716503tarnal
thenal92712413thenal
total55321823_total
trigonal946233trigonal
trinal6516953trinal
trona54118953trona_
tronas63816893tronas
umbonal1144383umbonal
urinal6614123urinal
vagal94613633vag__al
vagina102710933vagina_
vaginae11377683vaginae
vaginas11298813vaginas
veinal93812963veinal
venal85523213_venal
vernal93514213vernal
vinal85725813_vinal
vocal104715643_vocal
wagon94312953wagon__
wagonage1343293wagonage
wagoned1256223wagoned
wagoner1136093wagoner
wagons103911213wagon_s
zoeal144813783_zoeal
zona136321963_zona_
zonae145116443_zonae

Search took 6 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.1561145455.1
2DLD Change Limit1127163555.40620850.2
3Display Results3553550.1262817.5
 (SQL Overall)1786913555.68831415.4
 
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.