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

255 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
claxons163580(None) 
claxon1536581claxon_
klaxons1833261klaxons
axons125517932__axons
blazons1836162blazons
canons85522062c_anons
capons104119502c_apons
celadons1137002celadons
clamors11710092clamors
clans75031012cla__ns
clarions10310492clarions
claroes93113732claroes
claros84015112claro_s
classons1037702classons
clons75228132cl__ons
cratons94316032cratons
crayons12439232crayons
flacons1238052flacons
flagons1137972flagons
klaxon1733852klaxon_
taxons134211502_taxons
aeons57624653__aeons
agons66423783__agons
alamos8415003alamo_s
alanins7315803alanins
alans55636173ala__ns
alations82518893alations
alexins141910663alexins
amazons1836653amazons
axions134713483__axions
axon115524303__axon_
axone125918473__axone
axones134614513__axones
azons146518253__azons
bacons104917583_bacons
ballons93916963ballons
barons85025383_barons
batons85519423_batons
beacons11410733beacons
blains84516373bla_ins
blazon1736763blazon_
cabins104418923c_abins
cabobs124311893c_abobs
cahows14399123c_ahows
cains75334303c_a_ins
cairns85313303c_airns
cajon144513903c_ajon_
cajones163311333c_ajones
caldrons1138063caldrons
calkins133814873calkins
callans94518473callans
callous93516603callous
calos74431903c_alo_s
calxes154113033calx_es
calzone1848623calzone
calzones1948763calzones
camions113916133camions
camos95927613c_amo_s
cannons94412883cannons
canoes84725883c_anoes
canon74725303c_anon_
cans65050853c_a__ns
cantons95221203cantons
canyons124511593canyons
capon95221873c_apon_
capos94826073c_apo_s
carbons115418943carbons
cardons104519943cardons
carns75937563c_a_rns
carobs104818103c_arobs
carols85124983c_arols
caroms105619573c_aroms
cartons94122473cartons
cations94524143cations
celadon1036913celadon_
chadors1338753chadors
chains114819703cha_ins
chalone12312103chalone
chalones13312173chalones
chamois143512193chamois
chansons1337473chansons
chaos105622863cha_o_s
chazans21268123chazans
chitons122611913chitons
cions75222853c__ions
citrons92913223citrons
clachans1546413clachans
clachs133511323cla_chs
clacks144516343cla_cks
clades94920463cla_des
cladode1134613cladode
cladodes1245323cladodes
clads85722733cla__ds
clags85621123cla__gs
claims105211573cla_ims
clamant11312433clamant
clamor1049453clamo_r
clamour1196333clamour
clamours1255993clamours
clamps124515083cla_mps
clams95127673cla__ms
clan65633923cla__n_
clang86019313cla__ng
clangors11417003clangors
clangs95113613cla_ngs
clank114719523cla__nk
clanks124615183cla_nks
claps95626183cla__ps
claques18279013claques
clarets94111103clarets
claries93422203claries
clarion9311663clarion_
claro75018693claro__
clashes124017283clashes
clasps104512093cla_sps
class75525483cla__ss
classes94717943classes
classis93712723classis
classon937693classon_
clasts84817293cla_sts
clauses93813323clauses
clavers124314903clavers
claves115020063cla_ves
clavus11347353cla_vus
clawers123910973clawers
clawing133812673clawing
claws106020833cla__ws
claying133614303claying
claypans1543873claypans
clays105521333cla__ys
cleans85817053cl_eans
clods85320863cl__ods
clogs85519553cl__ogs
clon66232483cl__on_
clone75728163cl__one
clones84526563cl__ones
clonk114417443cl__onk
clonks125013473cl__onks
clonus85212413cl__onus
cloots85113693cl_oots
clops95924853cl__ops
clots75627643cl__ots
clowns114810113cl_owns
cloys104916943cl__oys
coaxers164311083coaxers
coaxes154715633coax_es
coaxing173511703coaxing
cocoons11310563cocoons
codons96119463c_odons
cogons96818113c_ogons
colons86028683c_olons
commons13311043commons
cons66057693c___ons
coons76737283c__oons
cordons104415763cordons
cottons9312193cottons
coupons112710563coupons
crampons1436643crampons
craton84517193craton_
cravens124010123cravens
crayon114110003crayon_
crepons1139323crepons
croons85418423c_roons
crotons93714373crotons
cullions10219223cullions
cyanins122910013cyanins
cyans105714813cya__ns
cytons111710183c_ytons
dalapons1145443dalapons
daltons8310403daltons
deacons10310393deacons
dragons938383dragons
elains64919853ela_ins
elans55527753ela__ns
elations83719123elations
elevons1067573elevons
etalons739073etalons
exons125813343__exons
falcons1239123falcons
fanons96115213_fanons
flacon1138633flacon_
flagon1037983flagon_
flamens124611063flamens
flans85327973fla__ns
flavins1338543flavins
flavone1335523flavone
flavones1435833flavones
flavors1337293flavors
flaxen16518573flaxen_
flaxes165015353flax_es
flexions1844413flexions
flexors1734773flexors
fluxions1844423fluxions
gallons83015953gallons
glamors1068123glamors
glans65125833gla__ns
gluons738503gl_uons
halons95720713_halons
kaons95014853_ka_ons
labors84016413_labors
ladens74516233_ladens
ladrons83813193_ladrons
lagans75717783_lagans
lagoons839253_lagoons
lapins84520683_lapins
lardons83914493_lardons
latens64620213_latens
lauans65113533_lauans
lawns85215423_la_wns
laxes125430093_lax_es
layins93817653_layins
lemons84415053_lemons
lions55923213_l_ions
llanos6108333llano_s
logons79818173_logons
loons55731723_l_oons
macons104017243_macons
masons83916513_masons
monaxons1744813monaxons
octagons1144493octagons
paeons83915523_paeons
plafond1344183plafond
plafonds1443273plafonds
plains85019593pla_ins
plans75731273pla__ns
plasmons12217663plasmons
platans93413123platans
platens94213983platens
platoons1038683platoons
pleons84213343pl_eons
plexors1645423plexors
plutons938343plutons
polarons1039863polarons
racons84319343_racons
radons74118533_radons
rayons94113343_rayons
reasons72514943reasons
relaxins15248683relaxins
salmons93713263salmons
salons63823693_salons
saloons74415323saloons
saxony1636233_saxony
seasons72614233seasons
slaloms9106543slaloms
talions7314113talions
talons64019443_talons
tauons63412673_tauons
taxols13328633_taxols
taxon124414663_taxon_
ulans54921303ula__ns
wagons103911213_wagons
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
yapons114411773_yapons

Search took 7 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 Limit1340272556.31321230.3
3Display Results2552550.0932741.9
 (SQL Overall)1786912556.81226231.8
 
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.