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

259 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
coronal9411576(None) 
corona83817401corona_
coronae94214891coronae
coronals103312901coronals
coronas93916911coronas
coronel94515221coronel
carinal94318242carinal
carnal83919212car_nal
clonal8310912c_lonal
colonel94213282colonel
colonial10411342colonial
coral76033452cor__al
cordial10312952cordial
corneal94414502corneal
cornel84020052cor_nel
cornual94210172cornual
corolla938622corolla
coronach1545762coronach
coronally1448412coronally
coronary1347692coronary
coronate103018212coronate
coronels104012142coronels
coroner94218202coroner
coronet94227172coronet
corporal1248512corporal
corral83616252cor_ral
coryzal2154822coryzal
ecotonal1046252ecotonal
hormonal1346632hormonal
sororal7310652sororal
zoonal1558082zo_onal
adrenal838263adrenal
agonal7410053_agonal
ammonal1137023ammonal
anconal939423anconal
aortal65217513aor_tal
atonal6514023_atonal
auroral7310473auroral
axonal1347653_axonal
azonal1568273_azonal
baronial1049483baronial
bizonal1845563bizonal
boral75831703bor__al
boreal84817213bor_eal
boron76727143boron__
boronic11311163boronic
borons85520543boron_s
borstal939043borstal
bromal10313653_bromal
canal75428043c__anal
cantonal1038903cantonal
caporal11410943caporal
caracal11312513caracal
carbonyl1595383carbonyl
cardinal1139573cardinal
carina84325333carina_
carinae94318593carinae
carinas93622413carinas
carol75128613caro__l
carousal1056283carousal
carpal103716253car_pal
ceramal1138843ceramal
cercal10314123cer_cal
cereal8315833cer_eal
chloral12169983chloral
choral115118493c_horal
chordal13449883chor_dal
choreal124412223chor_eal
chorial124214143chor_ial
choroidal1544673choroidal
chroma132912473chroma_
chromas142512693chromas
chromyl17275233chromyl
chronaxy2343253chronaxy
chronic14311423chronic
chronon1237353chronon
clinal8311553c_linal
coaeval1245183coaeval
coal66939253c__o_al
coastal9411043coastal
coaxal15387303co_axal
coaxial16157003coaxial
coccal9310223co_ccal
cocoa98517883coco_a_
cocoas104915743coco_as
cocomat13413623cocomat
coconut11511473coconut
cocoyam1644893cocoyam
codon86522853codon__
codons96119463codon_s
coequal1844933coequal
coeval1138893co_eval
cognac1157273co_gnac
cogon89120903cogon__
cogons96818113cogon_s
coital84117053co_ital
coitional1148693coitional
cojones163512103cojones
colon78630193colon__
colone85425003colon_e
colonels104210453colonels
colones96124433colones
coloni85619203colon_i
colonials1147903colonials
colonic115015713colonic
colons86028683colon_s
colonus94413443colonus
colony115417273colon_y
colossal1045553colossal
columnal1244413columnal
comal95125133c__omal
comical13312223comical
communal1446353communal
conceal113313013conceal
conchal144211583conchal
confocal1546303confocal
confrontal1553783confrontal
congeal104011683congeal
conical11316203conical
conoidal1149013conoidal
cool66940493co_o__l
coon67248943co_on__
cooncan1147233co_oncan
coons76737283co_on_s
copal95621783c__opal
corals85325143cor__als
coranto9311893coranto
corban10314693cor_ban
corbans11313173corbans
corbeil11859213corbeil
corbel103715973cor_bel
corbina111911453corbina_
corbinas12229403corbinas
cordials1139633cordials
cordoba1255743cordoba_
cordobas1345803cordobas
cordon95017293cordon__
cordoned12229613cordoned
cordons104415763cordon_s
cordovan1444293cordovan
coria75828323cor_ia_
coring94433963corin_g
cormel103815603cor_mel
corn69945813cor_n__
cornball1247053cornball
cornea84018933cor_nea
corneas94717003corneas
corned95224523cor_ned
cornels94716663cor_nels
corner84625623cor_ner
cornet84436733cor_net
cornily12410853cor_nily
cornmeal1245853cornmeal
corns76034763cor_n_s
cornu75921323cor_n_u
cornua85411903cor_nua
cornus84816563cor_nus
corny106023273cor_n_y
corody12149703coro_dy
corollas1039213corollas
coronachs1644253coronachs
coronated123313323coronated
coronates1110816923coronates
coroners104016223coroners
coronets103814363coronets
coronoid1148943coronoid
corotate102813933corotate
corpora1139353corpora_
corporals1347273corporals
corporeal1344983corporeal
corrals93713853cor_rals
corrival1346153corrival
corsac10410173cor_sac
cortical12412213cortical
cortina91915973cortina_
cortinas102212453cortinas
corvina12229503corvina_
corvinas13238023corvinas
coryza2074583coryza_
coryzas2134803coryzas
costal85419513co_stal
cotidal1038463cotidal
coxal146116673c__oxal
craal74117753c_r_aal
cranial92114683c_ranial
credal9311673c_redal
crenel84213063c_renel
croak115216633c_ro_ak
crone75231333c_ron_e
crones84729243c_rones
crony105918673c_ron_y
croon75522783croon__
crooned103813343crooned
crooner93714043crooner
croons85418423croon_s
crural8610633c_rural
curial84019153cur_ial
curtal83914543cur_tal
cyclonal1544603cyclonal
doornail943573doornail
dorsal74613943dor_sal
formal113215203for_mal
frontal1038363_frontal
gooral7310463go_oral
goral65125753gor__al
horal86328683hor__al
horizonal2153003horizonal
isogonal944673isogonal
journal1484963journal
koruna1035483koruna_
korunas1135443korunas
krona93611793_krona_
loral55927823lor__al
loreal63814313lor_eal
matronal1048113matronal
morainal1047203morainal
moral75533433mor__al
moron76925423moron__
moronic11311863moronic
morons84919543moron_s
mortal84616853mor_tal
motional1058673motional
neuronal846893neuronal
nominal92712373nominal
nonoral7313603nonoral
nonroyal1145753nonroyal
nontonal849743nontonal
normal83213533nor_mal
notional849403notional
nounal639813no_unal
oogonial945253oogonial
oral47638123_or__al
ordeal779253_ordeal
ordinal838643_ordinal
patronal1048653patronal
peroneal1049173peroneal
peroral9314793peroral
personal102311573personal
phonal11310383_phonal
pleonal937243pleonal
portal84218463por_tal
renal55929503__renal
rorqual1663573rorqual
royal85014703__royal
scrotal938493scrotal
seconal9310073seconal
serosal7311153serosal
stromal93010593stromal
tarnal63716503tar_nal
tonal53724303__tonal
toroidal966393toroidal
torsional945033torsional
trinal6516963_trinal
trona54118953_trona_
tronas63816903_tronas
umbonal1144383umbonal
urinal6614123_urinal
vernal93514213ver_nal
zonal145116853__zonal

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.406440125.6
2DLD Change Limit1340272596.85619548.9
3Display Results2592590.0962697.9
 (SQL Overall)1786912597.35824285.3
 
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.