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

289 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
claxon153658(None) 
claxons1635801claxons
klaxon1733851klaxon
axon115524302__axon
blazon1736762blazon
cajon144513902c_ajon
canon74725302c_anon
capon95221872c_apon
celadon1036912celadon
clamor1049452clamor
clan65633922cla__n
clarion9311662clarion
claro75018692claro_
claros84015112claros
classon937692classon
clon66232482cl__on
craton84517192craton
crayon114110002crayon
flacon1138632flacon
flagon1037982flagon
flaxen16518572flaxen
klaxons1833262klaxons
taxon124414662_taxon
aeon45634613__aeon
agon56531883__agon
alamo7418143alamo_
alamos8415003alamos
alan46844083ala__n
alanin6317273alanin
alation72920553alation
alexin132311483alexin
amazon1736833amazon
anon46134853__anon
axion1211316913__axion
axone125918473__axone
axons125517933__axons
azon135725053__azon
bacon95620593_bacon
ballon84117493ballon
baron78131243_baron
baton75822423_baton
beacon10511373beacon
blain75421793bla_in
blawn106813703bla_wn
blazons1836163blazons
cabin94820943c_abin
cabob114616813c_abob
cahow135110943c_ahow
cain65643913c_a_in
cairn75717513c_airn
caldron1038153caldron
calkin123515493calkin
callan83619603callan
callow114714663callow
calo64936443c_alo_
calos74431903c_alos
calx135722793calx__
calxes154113033calxes
calzone1848623calzone
camion103917193camion
camo85731753c_amo_
camos95927613c_amos
can57760143c_a__n
cannon84514443cannon
canoe75627253c_anoe
canons85522063c_anons
canton85722993canton
canyon114512033canyon
capo85829213c_apo_
capons104119503c_apons
capos94826073c_apos
carbon104919043carbon
cardon94120853cardon
carn66245433c_a_rn
carob95325223c_arob
carol75128613c_arol
carom95025563c_arom
carton84522663carton
cation83925503cation
celadons1137003celadons
chador1238673chador
chain105723673cha_in
chalone12312103chalone
chalot113020133chalot
chanson1238043chanson
chao95727313cha_o_
chaos105622863cha_os
chazan20269133chazan
chiton112612393chiton
chon96627793c__hon
ciao64924183cia_o_
cion613330913c__ion
citron83112983citron
clach124617823cla_ch
clachan1437183clachan
clachs133511323clachs
clack134720173cla_ck
clacks144516343clacks
clad76225823cla__d
clade85821013cla_de
clades94920463clades
cladode1134613cladode
clads85722733cla_ds
clag75924573cla__g
clags85621123cla_gs
claim95616913cla_im
claims105211573claims
clam86332293cla__m
clamant11312433clamant
clammy15356333clammy
clamors11710093clamors
clamour1196333clamour
clamp115517653cla_mp
clamps124515083clamps
clams95127673cla_ms
clang86019313cla_ng
clangor10426683clangor
clangs95113613clangs
clank114719523cla_nk
clanks124615183clanks
clanky15469073clanky
clans75031013cla_ns
clap86429043cla__p
claps95626183cla_ps
clapt98027173cla_pt
claque17338563claque
claret84026573claret
clarions10310493clarions
claroes93113733claroes
clary105719613cla_ry
clash106219033cla_sh
clasp95517193cla_sp
clasps104512093clasps
claspt104513413claspt
class75525483cla_ss
classons1037703classons
classy11379043classy
clast76030583cla_st
clasts84817293clasts
clause84311503clause
clave105420153cla_ve
claver113816973claver
claves115020063claves
clavi104912923cla_vi
clavus11347353clavus
claw95624343cla__w
clawed125115073clawed
clawer114512783clawer
clawing133812673clawing
claws106020833cla_ws
clay95927413cla__y
clayed125013043clayed
clayey14407663clayey
claying133614303claying
claypan1434313claypan
clays105521333cla_ys
clean75420413cl_ean
clod76124613cl__od
clog76123243cl__og
clone75728163cl__one
clonk114417443cl__onk
clons75228133cl__ons
cloot76127053cl_oot
clop86929893cl__op
clot66542423cl__ot
cloven114211513cloven
clown105214733cl_own
cloy96623833cl__oy
coax136922983coax__
coaxal15387303coaxal
coaxed165612513coaxed
coaxer153912793coaxer
coaxes154715633coaxes
coaxing173511703coaxing
cocoon10312263cocoon
codon86522853c_odon
cogon89120903c_ogon
colon78630193c_olon
common12310803common
con510268023c___on
coon67248943c__oon
cordon95017293cordon
cotton8312993cotton
coupon102810993coupon
crampon1336943crampon
cratons94316033cratons
craven114113933craven
crayons12439233crayons
crepon1039943crepon
croon75522783c_roon
croton84415453croton
cullion91910233cullion
cyan96419623cya__n
cyanin113911453cyanin
cyano105512493cyano_
cyton101511463c_yton
dalapon1044893dalapon
dalton7311273dalton
deacon9510423deacon
dragon838843dragon
elain55324703ela_in
elan46734243ela__n
elation73620453elation
elevon977953elevon
etalon648973etalon
exon117116803__exon
falcon11310293falcon
fanon84619013_fanon
flacons1238053flacons
flagons1137973flagons
flamen115215993flamen
flan76134183fla__n
flavin1239303flavin
flavone1335523flavone
flavor1236663flavor
flax147325633flax__
flaxes165015353flaxes
flaxy189012293flax_y
flexion1735073flexion
flexor1634503flexor
fluxion1735043fluxion
gallon73715813gallon
glamor958193glamor
gluon6311223gl_uon
halon86124863_halon
kaon87521023_ka_on
labor75117313_labor
laden65022193_laden
ladron73413323_ladron
lagan66520343_lagan
lagoon7410483_lagoon
lain46146283_la_in
lapin75222923_lapin
lardon74415063_lardon
laten54328343_laten
lauan55216793_lauan
lawn75925633_la_wn
lax107651523_lax__
laxer125420333_laxer
laxes125430093_laxes
laxly15610103_laxly
layin84720333_layin
lemon75618183_lemon
lion46334443_l_ion
llano5910603llano_
llanos6108333llanos
logon615922313_logon
loon47344793_l_oon
macon94519953_macon
mason74820183_mason
monaxon1644913monaxon
octagon1045243octagon
paeon74819493_paeon
plafond1344183plafond
plain74823303pla_in
plan65833943pla__n
plasmon11257983plasmon
platan83913693platan
platen84518203platen
platoon938953platoon
pleon74216383pl_eon
plexor1535253plexor
pluton838853pluton
polaron939843polaron
racon75422143_racon
radon64620503_radon
rayon83815703_rayon
reason62616333reason
relaxin14239183relaxin
salmon84614183salmon
salon55228553_salon
saloon64418023saloon
saxony1636233_saxony
season62714903season
slain54923573sla_in
slalom888173slalom
talion6317713talion
talon55824113_talon
tauon54816583_tauon
taxol124011363_taxol
taxons134211503_taxons
telamon936523telamon
ulan46527393ula__n
wagon94312953_wagon
waxen154911813_waxen
weakon13357623weakon
weapon11288113weapon
weason93210823weason
yapon104613583_yapon

Search took 6 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.376475242.0
2DLD Change Limit1127162895.32621163.3
3Display Results2892890.0933107.5
 (SQL Overall)1786912895.79530835.4
 
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.