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

272 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
coronae9421489(None) 
corona83817401corona_
coronal94115761coronal
coronas93916911coronas
coronate103018211coronate
carinae94318582carinae
colone85425002colon_e
cornea84018922cor_nea
coronach1545762coronach
coronals103312892coronals
coronary1347692coronary
coronated123313322coronated
coronates1110816922coronates
coronel94515222coronel
coroner94218202coroner
coronet94227172coronet
corotate102813932corotate
crone75231332c_ron_e
aortae65115473aor_tae
aurorae739663aurorae
baronage1147073baronage
baronne938263baronne
borane84620213boran_e
borne77926793bor_n_e
boron76727143boron__
boronic11311163boronic
borons85520543boron_s
botonee9311833botonee
bronze173610923_bronze
carbonade1446543carbonade
carbonate13410513carbonate
cardiae10713703cardiae
carina84325323carina_
carinal94318233carinal
carinas93622403carinas
carinate103320243carinate
carnage10311743car_nage
carnal83919203car_nal
carnie84421093car_nie
caroche1469243caroche
carouse9614423carouse
carronade1246093carronade
catenae9311373catenae
choanae1236863choanae
chorine123218363chorin_e
chroma132912473chroma_
chromas142512693chromas
chromate15312783chromate
chrome133214813chro_me
chronaxie2153813chronaxie
chronaxy2343253chronaxy
chronic14311423chronic
chronon1237353chronon
clonal8310913c_lonal
clone75728163c_lon_e
cocoa98517883coco_a_
cocoas104915743coco_as
cocomat13413623cocomat
coconut11511473coconut
cocotte1138603cocotte
cocoyam1644893cocoyam
codon86522853codon__
codons96119463codon_s
codrove1336423codro_ve
cognac1157273co_gnac
cognate10312203co_gnate
cogon89120903cogon__
cogons96818113cogon_s
cohobate1547013cohobate
cohune1189423cohun_e
coigne94612193coign_e
coinage10310553co_inage
cojones163512103cojones
colocate12313433colocate
cologne1039353cologne
colon78630193colon__
colonel94213283colonel
colones96124433colones
coloni85619203colon_i
colonial10411343colonial
colonic115015713colonic
colonies103620013colonies
colonise102514283colonise
colonize192312773colonize
colonnade1243083colonnade
colons86028683colon_s
colonus94413443colonus
colony115417273colon_y
comae97128423c__omae
comanage1346343comanage
commonage1645733commonage
comose105016843como_se
compone136517193compon_e
conchae143911643conchae
condone102616293condon_e
cone67256963c__on_e
conge85227593c__onge
conine84528553conin_e
connate9315753co_nnate
connote9311613connote
conte76633203c__onte
cooee74531023co_o_ee
cookie123716043co_okie
coolie83821603co_olie
coombe124110093co_ombe
coon67248943co_on__
cooncan1147233co_oncan
coons76737283co_on_s
coontie9311423co_ontie
cootie84223093co_otie
coprince1447093coprince
copulae112810613copulae
coracle112011723coracle
coral76033453cor__al
coranto9311893coranto
corban10314693cor_ban
corbans11313173corbans
corbie103618203cor_bie
corbina111911453corbina_
corbinas12229393corbinas
cordage11310063cordage
cordate10315223cordate
cordial10312943cordial
cordite10315263cordite
cordoba1255743cordoba_
cordobas1345803cordobas
cordon95017293cordon__
cordoned12229613cordoned
cordonnet1246703cordonnet
cordons104415763cordon_s
cordovan1444293cordovan
core67263113cor___e
corelate10516013corelate
coria75828323cor_ia_
coring94433963corin_g
corkage1438373corkage
corn69945813cor_n__
corncake1645263corncake
corneal94414503corneal
corneas94717003corneas
corned95224523cor_ned
cornel84020053cor_nel
corner84625623cor_ner
cornet84436733cor_net
cornfed1337383cor_nfed
cornice11612933cornice
cornier93017093cor_nier
cornpone1246933cornpon_e
corns76034763cor_n_s
cornu75921323cor_n_u
cornua85411903cor_nua
cornual94210173cornual
cornus84816563cor_nus
cornute939643cornute
corny106023273cor_n_y
corodies11313693corodies
corody12149703coro_dy
corolla938623corolla
corollas1039213corollas
corollate1148123corollate
coronachs1644253coronachs
coronally1448413coronally
coronaries12410233coronaries
coronels104012143coronels
coroners104016223coroners
coroneted12278323coroneted
coronets103814363coronets
coronoid1148943coronoid
corotated122810053corotated
corotates112714283corotates
corpora1139353corpora_
corporal1248513corporal
corporate13410903corporate
corpse104013403cor_pse
corrade101111043corrade
corral83616253cor_ral
corrie83621223cor_rie
corrode101310573corrode
corsac10410173cor_sac
corsage1039803corsage
corse75036183cor__se
cortege1098943cortege
cortina91915973cortina_
cortinas102212443cortinas
corvee114320093cor_vee
corvina12229503corvina_
corvinas13238013corvinas
corvine122113643corvine
coryza2074583coryza_
coryzal2154823coryzal
coryzas2134803coryzas
cosine83823513cosin_e
costae85319683co_stae
cottae84615703co_ttae
courante1049953courante
cowbane1437673cowbane
cowrote12289673cowro_te
coxae146115183c__oxae
coyote11411783coyo_te
cozenage2094783cozenage
crane75331603c_ran_e
crenate93317113c_renate
cringe93515483c_ringe
croak115216633c_ro_ak
crones84729243c_rones
cronies9622503c_ronies
crony105918673c_ron_y
croon75522783croon__
crooned103813343crooned
crooner93714043crooner
croons85418423croon_s
crore74922863c_ro_re
crosse85216303c_rosse
croupe105114433c_roupe
crouse84619363c_rouse
croute84617273c_route
croze164719453c_ro_ze
curiae84518373cur_iae
drone65324983_dron_e
ecotonal1046253ecotonal
ecotone938583ecoton_e
fordone1149383fordon_e
forename1347853forename
forgone1139343forgon_e
geocoronae1351883geocoronae
gobonee1077783gobonee
goonie73615563go_onie
hormonal1346633hormonal
hormone12410503hormon_e
ionone6313443ionon_e
irone55126363_iron_e
koruna1035483koruna_
korunas1135443korunas
krona93611793_krona_
krone94018733_kron_e
loonie64216453lo_onie
loricae938253loricae
morae75831193mor__ae
moron76925423moron__
moronic11311863moronic
morons84919543moron_s
morose85116243moro_se
morulae958963morulae
novenae1046323novenae
ochone11311293ochon_e
ocreae83310273ocr_eae
odonate848403_odonate
orange74016323_orange
orgone71110913_orgon_e
ornate6315133_or_nate
oroide7311703_oroide
ozonate1646863_ozonate
ozone14310613_ozon_e
personae102410553personae
porose84818743poro_se
pronate9418873_pronate
prone75332623_pron_e
pyrone112714473pyron_e
scoriae9310903scor_iae
serosae7310243serosae
soroche1237183soroche
sororal7310653sororal
sororate8411173sororate
throne98517603thron_e
toonie63617993to_onie
torose64317693toro_se
torulae758553torulae
trona54118953_trona_
tronas63816903_tronas
trone55131863_tron_e
zonae145116443__zonae
zoonal1558083zo_onal

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272728.15616432.9
3Display Results2722720.0932924.7
 (SQL Overall)1786912728.40521260.1
 
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.