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

370 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
coronet9422717(None) 
cornet84436731cor_net
coronel94515221coronel
coroner94218201coroner
coronets103814361coronets
baronet91022202baronet
carnet84732872car_net
coconut11511462coconut
cojones163512102cojones
colone85425002colone_
colonel94213282colonel
colones96124432colones
cordoned12229612cordoned
cordonnet1246702cordonnet
cornea84018922cor_nea
corned95224522cor_ned
cornel84020052cor_nel
corner84625622cor_ner
cornets94820572cor_nets
corona83817402coron_a
coronae94214892coronae
coronal94115762coronal
coronas93916902coronas
coronate103018212coronate
coronels104012142coronels
coroners104016222coroners
coroneted12278322coroneted
corset85636222cor_set
corslet9318062corslet
corvet114626932cor_vet
crone75231332c_rone_
crones84729242c_rones
crooned103813342crooned
crooner93714042crooner
crownet123714112crownet
hornet94926432hor_net
acorned10238263acor_ned
aproned10311503aproned
baronets101410903baronets
bayonet121212213bayonet
boloney1247763boloney
bonnet85524633bo_nnet
borane84620213borane_
boranes93720403boranes
borne77926793bor_ne_
boron76727143boron__
boronic11311163boronic
borons85520543boron_s
botonee9311833botonee
brunet84419293_brunet
burgonet1148103burgonet
burnet84326173bur_net
cabinet11318903cabinet
cajones163311333cajones
canzonet19410583canzonet
carcanet12316343carcanet
caret75360563car__et
carnets93918403car_nets
carney115315703car_ney
caroled103717683caroled
caroler93816753caroler
caromed123713623caromed
carpet104530093car_pet
cartoned111312833cartoned
cermet10321153cer_met
chorine123218363chorine_
chorines132917253chorines
chrome133214813chrome_
chromed153510923chromed
chromes142914933chromes
chronic14311413chronic
chronon1237353chronon
circlet11311473circlet
clarinet10317293clarinet
clarionet1149833clarionet
clone75728163c_lone_
cloned94518803c_loned
cloner84418093c_loner
clones84526563c_lones
closet85226603c_loset
coagent10313973coagent
coannex1635503coannex
cobnut10311313co_bnut
cockney1835873cockney
cocoanut1246903cocoanut
cocomat13413623cocomat
coconuts1246323coconuts
cocooned1337293cocooned
cocotte1138603cocotte
codon86522853codon__
codons96119463codon_s
codrove1336423codrove_
coffret15310073coffret
cogent9321003cogen_t
cogon89120903cogon__
cogons96818113cogon_s
cohort1110720263coho_rt
cohost115217213coho_st
cohune1189423cohune_
cohunes1249713cohunes
coigne94612193coigne_
coigned11418663coigned
coignes103912153coignes
coined94523603co_ined
coiner84323783co_iner
cojoined1856293cojoined
collet84030363co_llet
cologne1039353cologne_
cologned1237153cologned
colognes11310603colognes
colon78630193colon__
colonels104210453colonels
coloni85619203colon_i
colonic115015713colonic
colonies103620013colonies
colonist102617923colonist
colons86028683colon_s
colonus94413443colonus
colony115417273colon_y
colored10313473colored
colorer9312523colorer
comet95946073c__omet
comment1310317703comment
commoner142710633commoner
commonest1549253commonest
comose105016843comose_
compone136517193compone_
component15411083component
concent114422513concent
condone102616293condone_
condoned122612023condoned
condoner112913393condoner
condones112817393condones
cone67256963c__one_
coned86040053c__oned
cones76457423c__ones
coney105932883c__oney
confront13411603confron_t
conine84528553conine_
conines93827793conines
connect113515743co_nnect
conned95119703co_nned
conner84423963co_nner
connote9311613connote
consent93723113consent
conte76633203c__onte
content94326153content
convent123919413convent
cooed84534343co_o_ed
cooee74531023co_o_ee
cooeed95917863co_oeed
cooees85621893co_oees
cooer74831013co_o_er
cooey105828223co_o_ey
cooked135921363co_oked
cooker124722453co_oker
cookey155414333co_okey
cooled95224583co_oled
cooler84824713co_oler
coolest9318643co_olest
coon67248943co_on__
coons76737283co_on_s
cooped114821603co_oped
cooper104221123co_oper
coopt95929853co_o_pt
coot67860383co_o__t
cooter85128613co_oter
copout10418773copo_ut
coquet174318013co_quet
coranto9311893coranto
corbel103715973cor_bel
corbie103618203corbie_
corbies113520113corbies
cordate10315213cordate
corded105923353cor_ded
corder94322873cor_der
cordite10315253cordite
cordon95017293cordon__
cordonnets1343533cordonnets
cordons104415763cordon_s
core67263113cor__e_
cored85044223cor__ed
corer75538873cor__er
cores76361853cor__es
coring94433963corin_g
corked135020783cor_ked
corker124720853cor_ker
corkier133114303corkier
corkiest143114793corkiest
cormel103815603cor_mel
corn69945813cor_n__
corneal94414503cor_neal
corneas94716993cor_neas
cornels94716663cor_nels
corners94723313cor_ners
cornetcy1544303cor_netcy
cornfed1337383cornfed
cornier93017083cornier
corniest102117303corniest
cornpone1246933cornpone_
cornpones1347103cornpones
corns76034763cor_n_s
cornu75921323cor_n_u
cornua85411903cor_nua
cornus84816563cor_nus
cornute939633cor_nute
cornuto937023cor_nuto
corny106023273cor_n_y
corodies11313693corodies
corody12149703coro_dy
corolla938623corolla
coronach1545763coronach
coronals103312893coronals
coronary1347693coronary
coronated123313323coronated
coronates1110816923coronates
coronoid1148943coronoid
corotate102813933corotate
corpse104013403corpse_
corpses113913803corpses
correct11513983correct
corrie83621213corrie_
corries94026783corries
corrode101310573corrode_
corroded12147513corroded
corrodes111310333corrodes
corrupt1149093corrupt
corse75036183cor_se_
corselet10414573corselet
corses84433463cor_ses
corsets94819803cor_sets
corslets1038273corslets
cortex15311463cor_tex
coruler9311713coruler
corvee114320093cor_vee
corvees124613793corvees
corves115122523cor_ves
corvets124715023cor_vets
corvine122113643corvine_
coset75748843c__oset
cosine83823513cosine_
cosines94122673cosines
cosset84125863co_sset
cottoned1138033cottoned
count74932053co_un_t
couplet114717943couplet
courant9317973couran_t
courante1049953courante
covet105638943c__ovet
cowrote12289673cowrote_
coyote11411783coyote_
coyotes12410703coyotes
cozened19349183cozened
cozener18328953cozener
crane75331603c_rane_
craned96121653c_raned
cranes84330753c_ranes
crenel84213063c_renel
crochet143616663crochet
crocket154615673crocket
croft105622683c_ro_ft
cronies9622503c_ronies
crony105918673c_ron_y
crooked143910943crooked
crooker134111093crooker
crookest1436683crookest
croon75522783croon__
crooners103911393crooners
croons85418423croon_s
croquet1859683croquet
crore74922863c_rore_
crores86121163c_rores
croute84617273c_route
crowed124717293c_rowed
crower114117553c_rower
crowned133912423crowned
crowner124012593crowner
crownets13407673crownets
croze164719453c_roze_
crozer175112843c_rozer
crozes174417663c_rozes
cruet74831843c_r_uet
cruset84425093c_ruset
curet75447643cur__et
current9313693current
curvet114720243cur_vet
cygnet1237893c_ygnet
drone65324983_drone_
droned84616863_droned
droner74717673_droner
drones75023433_drones
ecotone938583ecotone_
ecotones1039493ecotones
fordone1149373fordone_
forget106326393for_get
forgone1139343forgone_
forint9325023forin_t
fornent10312933for_nent
forwent13310533forwent
front85029223_fron_t
garnet73928413gar_net
gobonee1077783gobonee
gooney106612313go_oney
gorget87123863gor_get
gurnet74920873gur_net
hormone12410503hormone_
hormones13311163hormones
horned105718703hor_ned
hornets104113553hor_nets
horrent10313553horrent
ionone6313443ionone_
ionones7313883ionones
irone55126363_irone_
ironed74916013_ironed
ironer64216443_ironer
irones64724013_irones
jaconet16311483jaconet
krone94018733_krone_
kronen10348913_kronen
kroner104612573_kroner
looney94712403lo_oney
loriner7511883loriner
mooned94216643mo_oned
mooner85317833mo_oner
moonlet92413273mo_onlet
moonset92413043mo_onset
mordent10313993mordent
moron76925423moron__
moronic11311863moronic
moronity1347333moronity
morons84919543moron_s
morose85116243morose_
nonet54540843__nonet
ochone11311293ochone_
orgone71110913_orgone_
orgones81010793_orgones
orient6322533_orient
ozone14310613_ozone_
ozones1539393_ozones
porose84818743porose_
portent93619643portent
projet15315183_projet
prone75332623_prone_
pyrone112714473pyrone_
pyrones123113303pyrones
roset55945243__roset
sarsnet7314813sarsnet
scorned10229953scor_ned
scorner9259763scor_ner
solonets838233solonets
solonetz1744853solonetz
sonnet65923503so_nnet
sooner64220463so_oner
soonest7415593so_onest
sorbent92915233sorbent
sorbet83924073sor_bet
sorned74820043sor_ned
sorner64720383sor_ner
soroses73117483soroses
throne98517603throne_
throned115412173throned
thrones105715843thrones
torment9316173torment
torose64317693torose_
torot56139943toro__t
torrent7313413torrent
trone55131863_trone_
trones65629283_trones
worset96726583wor_set
zooned164011083zo_oned

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 Limit1340273707.81017160.9
3Display Results3703700.1262936.5
 (SQL Overall)1786913708.09222082.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.