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

406 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
atonal651402(None) 
agonal7410051agonal
axonal1347651axonal
azonal1568271azonal
tonal53724301_tonal
aboral8314372aboral
actinal9312292actinal
ammonal1137012ammonal
amoral8314622amoral
anal48037522a__nal
anconal939422anconal
annal56520762a_nnal
anodal72512112anodal
apodal9289822apodal
atabal839742atabal
atoll57913922ato_ll
atonable1038792atonable
atonally1148632atonally
atone56527982aton_e
atoned75417542atoned
atoner64817192atoner
atones65225772atones
atonia63816512atonia
atonias73315992atonias
atonic83420472atonic
atony87218852aton_y
atrial65418942atrial
avowal1246322avowal
cantonal1038902cantonal
clonal8310912clonal
matinal9312602matinal
matronal1048112matronal
national8311532national
patronal1048652patronal
phonal11310382phonal
rational8412542rational
stomal85213312stomal
tarnal63716502tarnal
total55321822_total
zonal145116852_zonal
zoonal1558082zoonal
aal39058673a___al
aboil72217543abo_il
abolla8410193abolla
aboma91114603aboma_
abomas101113583abomas
acetal84314903acetal
acinar8310483acinar
actual8311023actual
adenyl1035023adenyl
adonis7314063adonis
adrenal838263adrenal
aecial84817313aecial
aeon45634613aeon__
aeonian738353aeonian
aeonic83517043aeonic
aeons57624653aeon_s
aerial64625713aerial
affinal1336443affinal
afoul8510193afo_ul
aftosa996573aftosa_
aftosas10147143aftosas
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
antennal856353antennal
antonym1246513antonym
antral65719413antral
anural65714743anural
aortal65217513aortal
apical10913903apical
apneal83411123apneal
apnoeal956193apnoeal
apogeal1045613apogeal
appal95315223a_ppal
appeal103911613appeal
apteral9311523apteral
areal55928733a_real
arena55323813arena_
arenas65021993arenas
argal65023383a_rgal
aroma71220143aroma_
aromas81018613aromas
arousal748633arousal
arsenal739383arsenal
artal55525473a_rtal
arval86017013a_rval
asana5315483asana_
asanas6514113asanas
asocial998653asocial
asternal858313asternal
astony9510523aston_y
astral66919283astral
atabals938413atabals
ataman81013063ataman
atap66722453at__ap
atingle848253atingle
atlas55821583at_las
atlatl637873atlatl
atma68121773at_ma_
atman75520143at_man
atmans84413963atmans
atmas75721013at_mas
atolls65511353atolls
atom67824523ato__m
atomic104115603atomic
atomical1248903atomical
atoms76817563ato_ms
atomy107415193ato_my
atonalism1148463atonalism
atonalist9411823atonalist
atonality1247073atonality
atoneable1145853atoneable
atoners75013953atoners
atonics93613713atonics
atonies75320953atonies
atoning83514873atoning
atop66124753ato__p
atopic103514143atopic
atopy106813393ato_py
atria56022333atria_
attar56516693at_tar
audial7312993audial
aural54428963a_ural
auroral7310473auroral
automan9310883automan
automat9414873automat
autonym1246633autonym
autumnal1042393autumnal
avowals1335013avowals
awol75620673awo__l
axal116520493a__xal
axial124515193a_xial
axon115524303axon__
axone125918473axon_e
axonemal1743543axonemal
axones134614513axones
axonic154312723axonic
axons125517933axon_s
azon135725053azon__
azonic175513153azonic
azons146518253azon_s
banal75925993_banal
baritonal1144673baritonal
baronial1049483baronial
basinal9310033basinal
bathyal1544823bathyal
baton75822423baton__
batons85519423baton_s
binal75323823_binal
bizonal1845563bizonal
boral75831703_boral
bromal10313653bromal
canal75428043_canal
caporal11410943caporal
carinal94318223carinal
carnal83919203carnal
catena8312473catena_
catenae9311363catenae
catenas9313103catenas
cathodal14155403cathodal
catnap1098383cat_nap
choral115118493choral
clinal8311553clinal
coal66939253_co_al
comal95125133_comal
copal95621783_copal
coral76033453_coral
coronal94115763coronal
coxal146116673_coxal
datival1135583datival
diaconal1196133diaconal
diagonal1095653diagonal
domal85619203_domal
dona55529633_dona_
donas65926473_donas
dotal64919623_dotal
ecotonal1046253ecotonal
eternal72910893eternal
etna46415263et_na_
etnas54713933et_nas
factional1478763factional
fatal84819373fat__al
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
kathodal16153403kathodal
krona93611793krona_
lacunal9136553lacunal
lagoonal943093lagoonal
laminal94113633laminal
lateral7313563lateral
latina65621143latina_
latinas74416463latinas
latosol745283latosol
lienal63912783lienal
litoral7610763litoral
local74820273_local
loral55927823_loral
loyal84513483_loyal
maternal1047803maternal
mayoral1237683mayoral
modal85919233_modal
molal75120343_molal
monad85519473_monad
monas74732153_monas
moral75533433_moral
motional1058673motional
natal53921493nat__al
nationals948863nationals
natural739513natural
nodal64717793_nodal
nona46929063_nona_
nonas55126653_nonas
nontonal849733nontonal
nonyl849773_nonyl
nopal75517103_nopal
notal55221353_notal
notional849393notional
nounal639813nounal
oatmeal944973oatmeal
opal66923523__opal
optional1047643optional
oral47638123__oral
oval77119523__oval
ovational1246853ovational
paginal10269493paginal
pastoral10310483pastoral
paternal1038333paternal
patina86022193patina_
patinae95414403patinae
patinas96318523patinas
penal75228373_penal
pinnal84814273pinnal
pleonal937243pleonal
ramona8412413ramona_
ramonas9311093ramonas
ratal55025113rat__al
rationale949463rationale
rationals949933rationals
regnal74812933regnal
renal55929503_renal
retinal75318353retinal
retotal739843retotal
rhinal9510183rhinal
royal85014703_royal
seasonal847263seasonal
seconal9310073seconal
shoal83920263sho_al
signal73711483signal
skoal93811453sko_al
sonar56523423_sonar
spinal84915313spinal
sponsal946333sponsal
sporal82915453sporal
stanol6310723stanol
statal61613223statal
stational948503stational
steal56125473st_eal
sternal73411903sternal
stoa45425913sto_a_
stoae55024263sto_ae
stoai55417863sto_ai
stoas55126023sto_as
stoat57135953sto_at
stoical9310273stoical
stoma75918273stoma_
stomas84816323stomas
stonable1039843stonable
stone55431183ston_e
stoned75923143stoned
stoner65823203stoner
stones65130033stones
stoney96217353stoney
stonily1049433stonily
stony85818643ston_y
stool55619893sto_ol
storax1389783storax
stromal93010583stromal
tamal73522613_tamal
tarsal63315273tarsal
tatouay1044113tatouay
teal45546503_t_eal
tenail64516103_tenail
tepal76319583_tepal
tetanal738023tetanal
thenal92712413thenal
tical76021493_tical
tidal64516443_tidal
tincal83913353_tincal
tineal66216153_tineal
toad55830183_to_ad
today96416953_today
toea46732333_toea_
toeas55726423_toeas
toenail738773_toenail
toga57027413_toga_
togae67020113_togae
togas67823003_togas
toil46536283_to_il
tokay125513053_tokay
tola45236333_tola_
tolan55124013_tolan
tolar55524113_tolar
tolas54532773_tolas
toll45535263_to_ll
tolyl84710093_tolyl
toman75724053_toman
tombal102311023_tombal
ton310265103_ton__
tonally10311373_tonally
tondi65716143_tondi
tondo69718683_tondo
tone46953743_ton_e
toned65435343_toned
toner55336243_toner
tones56048663_tones
toney86027413_toney
tong56434353_ton_g
tonga65619683_tonga
tongas74315513_tongas
tongs65928463_tongs
tonic74727653_tonic
tonne54921433_tonne
tons46553053_ton_s
tonsil6311873_tonsil
tonus56324303_tonus
tony75635153_ton_y
tool46735683_to_ol
topaz16315323_topaz
tora47545993_tora_
torah87125273_torah
toras55540373_toras
totals63115163_totals
towel84920523_towel
trial54926353_trial
trinal6516953trinal
trona54118953trona_
tronas63816893tronas
tubal75517203_tubal
tuna45127843_tuna_
tunas54224123_tunas
typal105311153_typal
umbonal1144383umbonal
urinal6614123urinal
vaginal11288403vaginal
vatical1239983vatical
veinal93812963veinal
venal85523213_venal
vernal93514213vernal
vinal85725813_vinal
vocal104715643_vocal
zoeal144813783_zoeal
zona136321963_zona_
zonae145116443_zonae

Search took 9 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.1431249587.4
2DLD Change Limit1127164067.71614608.1
3Display Results4064060.1432839.2
 (SQL Overall)1786914068.00222330.8
 
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.