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

269 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
clarion931166(None) 
clarions10310491clarions
alation72920552alation
camion103917192c_amion
carbon104919042c_arbon
cardon94120852c_ardon
carrion9312672carrion
carton84522662c_arton
cation83925502c_ation
chariot12316212chariot
chorion12311772chorion
claries93422202claries
clarify1536092clarify
clarioned1245722clarioned
clarionet1149832clarionet
clarity12310912clarity
claro75018692clar_o_
claros84015112clar_os
classon937692classon
claxon1536582cla_xon
elation73620452elation
lardon74415062_lardon
ablation10312433ablation
acylation1448653acylation
alanin6317273alani_n
alations82518893alations
aldrin7311243aldri_n
anion55028813__anion
argon65520593__argon
arson55118833__arson
avion84218343__avion
axion1211316913__axion
baron78131243_bar_on
baryon111211613_baryon
basion84315853_basion
blain75421793bla_i_n
blaring104317113blaring
blazon1736763bla_zon
cabin94820943c_abi_n
cain65643913c_a_i_n
cairn75717513c_a_irn
cajon144513903c_a_jon
caldron1038153caldron
calkin123515493calki_n
calvarian1446863calvarian
camions113916133c_amions
campion133011413campion
cannon84514443c_annon
canon74725303c_a_non
canton85722993c_anton
canyon114512033c_anyon
caparison1343983caparison
capon95221873c_a_pon
caption113513693caption
carbo94923843c_arbo_
carbons115418943c_arbons
carbos105122263c_arbos
carboy134914183c_arboy
cardio9915673c_ardio_
cardons104519943c_ardons
cardoon104813813c_ardoon
careen84119493c_areen
cargo85322073c_argo_
cargos94619183c_argos
carhop133610763c_arhop
caribe103416753c_aribe
caribou1156993c_aribou
caried94528693c_aried
caries85147623c_aries
carillon1046963c_arillon
carina84325333c_arina
caring95137993c_aring
carioca1139683c_arioca
cariole9818343c_ariole
carious93320283c_arious
carlin84421823c_arlin
carman103920743c_arman
carmen104019343c_armen
carn66245433c_ar__n
carob95325223c_ar_ob
carol75128613c_ar_ol
carom95025563c_ar_om
carrions10312453carrions
carrom10513403c_arrom
carrot8423123c_arrot
carryon1237033carryon
cartons94122473c_artons
cartoon94114463c_artoon
cartop104213563c_artop
carven114716663c_arven
casino84317553c_asino
cations94524143c_ations
caution93013523caution
celadon1036913cela_don
cesarian1048183cesarian
cession939813cession
chagrin1337893chagri_n
chain105723673cha_i_n
chalazion23113723chalazion
champion17276353champion
chanson1238043chanson
charier124317903charier
charily15310283charily
charing133721323charing
chariots1339393chariots
charism14712203charism
charity15311023charity
charpoy1735713charpoy
charro114212953charro_
charros124312143charros
chelation1439963chelation
chlorin123113003chlori_n
chorions13310663chorions
ciliation111112493ciliation
cion613330913c___ion
citation10314363citation
citrin82615413citri_n
citron83112983citr_on
clachan1437183clachan
cladism1238553cladism
cladist10311973cladist
claim95616913cla_i_m
claims105211573cla_ims
clamor1049453cla_mor
clan65633923cla___n
clangor10426683clangor
claret84026573clar_et
clarets94111103clarets
clarinet10317293clarinet
clarionets1243903clarionets
clarioning1345183clarioning
clarkia1334873clarkia
clarkias1444793clarkias
claroes93113733claroes
clary105719613clar__y
classons1037703classons
clavation1447003clavation
clavi104912923clavi__
clavicorn1652153clavicorn
clavier1239173clavier
clawing133812673clawing
claxons1635803cla_xons
clayier1248323clayier
claying133614303claying
clayish1547943clayish
claypan1434313claypan
clearing113014883clearing
cleric10612133cleri_c
clerics1149333clerics
clerid9312413cleri_d
clerids1049093clerids
clerisy1246823clerisy
clon66232483cl___on
coaction12310773coaction
coarsen93210323coarsen
coercion1246573coercion
coition9314313coition
collation11313993collation
conation101420883conation
cordon95017293c_ordon
crampon1336943crampon
craton84517193cra_ton
crayon114110003cra_yon
creation102816513creation
croon75522783c__roon
cullion91910233cullion
cumarin1139263cumari_n
curio74221213c_urio_
curios83218333c_urios
cushion1236403cushion
cyanin113911453cyani_n
cyprian1445343cyprian
czardom2144183czardom
czarina1845953czarina
czarism2056423czarism
czarist18710223czarist
delation92318083delation
dilation92215463dilation
durion7510963_durion
eclosion1046893eclosion
elain55324703ela_i_n
elations83719123elations
elision72311103elision
elusion72310953elusion
elution72913823elution
enation73419233enation
erasion7311963erasion
evasion1036753evasion
fanion94514323_fanion
filarian1148313filarian
flacon1138633fla_con
flagon1037983fla_gon
flaring114116803flaring
flatiron1144623flatiron
flavin1239303flavi_n
flexion1735073flexion
florin9312653flori_n
fluxion1735043fluxion
gabion93211033_gabion
garcon92912483_garcon
garron73113493_garron
gelation93014433gelation
glarier84112213glarier
glaring93714883glaring
halation11313853halation
illation8311943illation
jargon1448823_jargon
kation104315683_kation
klaxon1733853kla_xon
ladino73615123_ladino
ladron73413323_ladron
lagoon7410483_lagoon
lain46146283_la_i_n
lampion11278303_lampion
lapin75222923_lapi_n
lardons83914493_lardons
lardoon83410373_lardoon
largo65319783_largo_
largos74815063_largos
lari45839153_lari__
lariat6629043_lariat
larine63927043_larine
laris54737463_lari_s
latino64120473_latino
layin84720333_layi_n
legion75712983_legion
lesion64715063_lesion
lion46334443_l__ion
logion76013723_logion
lotion65716523_lotion
lyricon1243713_lyricon
malarian10311563malarian
maroon83118203_maroon
marron83717543_marron
morion86217733_morion
morrion959003morrion
nasion63914083_nasion
nation64322803_nation
oblation1039863oblation
occasion1244213occasion
oration71617713oration
ovarian1037643ovarian
ovation101510023ovation
pardon94618733_pardon
parian83223963_parian
parson83817903_parson
parton84720993_parton
plain74823303pla_i_n
plasmon11257983plasmon
platoon938953platoon
plosion939113plosion
polaron939843polar_on
prion75119993__prion
ration64226013_ration
relation82619773relation
sarin55239253_sari_n
scalation11311073scalation
scallion1046793scallion
slain54923573sla_i_n
solation8916153solation
station72717243station
suasion739363suasion
talion6317713_talion
tarpon82812803_tarpon
turion6313163_turion
vibrion1245253vibrion
virion9310683_virion
wanion93213063_wanion
warison1037083_warison

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 Limit1340272696.81319672.2
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.31224438.0
 
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.