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

342 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
crayons1243923(None) 
cratons94316031cratons
crayon114110001crayon_
rayons94113341_rayons
baryons121010472baryons
canons85522062c_anons
canyons124511592canyons
capons104119502c_apons
carbons115418942carbons
cardons104519942cardons
carryons1337102carryons
cartons94122472cartons
claxons1635802claxons
crampons1436642crampons
craton84517192craton_
cravens124010122cravens
crayoned1435002crayoned
crayoner1344862crayoner
crayoners1444502crayoners
crayonist1446252crayonist
crepons1139322crepons
croons85418422cr_oons
crotons93714372crotons
dragons938382dragons
racons84319342_racons
radons74118532_radons
rayon83815702_rayon_
acrasins1039973acrasins
aeons57624653__aeons
agons66423783__agons
amazons1836653amazons
anyons94513503_anyons
archons12311583archons
argons75018203ar_gons
arsons63917213ar_sons
axons125517933__axons
ayins85321613__ayins
azons146518253__azons
bacons104917583_bacons
barons85025383_barons
baryon111211613baryon_
barytons1345573barytons
batons85519423_batons
bayous11411153_bayous
beacons11410733beacons
blazons1836163blazons
bradoons1136763bradoons
brains85125473bra_ins
brans75437433bra__ns
bravoes12418533bravoes
bravos114711403bravo_s
brawns115614083bra_wns
brayers124511903brayers
braying134416313braying
brays106723113bray__s
brazens18418713brazens
bryony1435833br_yony
cabins104418923c_abins
cabobs124311893c_abobs
cahows14399123c_ahows
cains75334303c_a_ins
cairns85313303c_airns
cajon144513903c_ajon_
cajones163311333c_ajones
calos74431903c_alo_s
camions113916133camions
camos95927613c_amo_s
cannons94412883cannons
canoes84725883c_anoes
canon74725303c_anon_
cans65050853c_a__ns
cantons95221203cantons
canyon114512033canyon_
capon95221873c_apon_
capos94826073c_apo_s
carabins12312363carabins
caracols12310413caracols
caravans1338623caravans
carbon104919043carbon_
carbos105122263carbo_s
carboys144711783carboys
cardamons1445203cardamons
cardon94120853cardon_
cardoons113411943cardoons
careens94514703careens
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
carious93320283carious
carlins93921923carlins
carns75937563c_a_rns
carobs104818103c_arobs
carols85124983c_arols
caroms105619573c_aroms
carrions10312453carrions
carroms11512403carroms
carrots9714623carrots
carryon1237033carryon_
carton84522663carton_
cartoons104012803cartoons
caryotins14248043caryotins
cations94524143cations
caymans14349513c_aymans
cays95437673c_ay__s
celadons1137003celadons
ceratins102818733ceratins
chadors1338753chadors
chains114819703cha_ins
chalone12312103chalone
chalones13312173chalones
chamois143512193chamois
chansons1337473chansons
chaos105622863cha_o_s
chayote1536493chayote
chayotes1636503chayotes
chays135319743chay__s
chazans21268123chazans
chitons122611913chitons
chronons1347353chronons
cions75222853c__ions
citrons92913223citrons
clamors11710093clamors
clans75031013cla__ns
clarions10310493clarions
claroes93113743claroes
claros84015113claro_s
classons1037703classons
claxon1536583claxon_
claying133614303claying
claypans1543873claypans
clays105521333clay__s
clons75228133c__lons
cocoons11310563cocoons
codons96119463c_odons
cogons96818113c_ogons
colons86028683c_olons
commons13311043commons
cons66057693c___ons
coons76737283c__oons
cordons104415763cordons
cottons9312193cottons
coupons112710563coupons
craals84113303cra_als
crabs95421393cra__bs
cracks144817003cra_cks
cradles103114133cradles
crafts115312743cra_fts
crags85622573cra__gs
crakes124921813cra_kes
crambes1339963crambes
cramboes1436543cramboes
crambos1336783crambos
cramoisy1543703cramoisy
crampon1336943crampon_
crampoons1544063crampoons
cramps125615563cra_mps
crams96229153cra__ms
crane75331603cra__ne
cranes84330753cra_nes
craning103620303craning
crank114819613cra__nk
crankous1435973crankous
cranks125015313cra_nks
crannog1044243crannog
crannogs1143783crannogs
cranny114210273cra_nny
crapes104727693cra_pes
craping124018713craping
crapola1136913crapola
crapolas1247403crapolas
craps95328643cra__ps
crases85532313cra_ses
crashes124618403crashes
crasis85020473cra_sis
crass76328043cra__ss
craters95021893craters
crates85736063cra_tes
crating103725203crating
cratonic1239123cratonic
cravats1237413cravats
craven114113933craven_
cravers124416563cravers
craves115825393cra_ves
craving134015733craving
cravings14428223cravings
crawls114712083cra_wls
craws105723123cra__ws
crayfish1944253crayfish
crayoning1535243crayoning
crayonists1544133crayonists
crazes174720133cra_zes
crazies183413853crazies
crazing193914583crazing
creatins103617513creatins
creations112614543creations
creators102814423creators
credos94612853credo_s
crepon1039943crepon_
cresols939653cresols
cretins93216423cretins
crimsons1245633crimsons
crocs95722433cr__ocs
crone75231333cr__one
crones84729243cr__ones
crony105918673cr__ony
crooks124914413cr_ooks
croon75522783cr_oon_
crops96125243cr__ops
cross75124503cr__oss
croton84415453croton_
croutons1036753croutons
crowns115615113cr_owns
crows105727313cr__ows
cruors838643cr_uors
crying123612283cr_ying
cryogens1444723cr_yogens
cryonic1437833cr_yonic
cryonics1555413cr_yonics
crypts13397743cr_ypts
curacoas1246033curacoas
curators10311723curators
cyanins122910013cyanins
cyans105714813c__yans
cytons111710183c_ytons
deacons10310393deacons
dragon838843dragon_
dragoons1045013dragoons
drains73719403dra_ins
draying123813843draying
drays95819773dray__s
dromons1038193dromons
erasions8310983erasions
etalons739073etalons
fanons96115213_fanons
flacons1238053flacons
flagons1137973flagons
fraying143413433fraying
frayings15325993frayings
frays116920103fray__s
frons86124043fr__ons
garcons102411643garcons
garrons82713463garrons
grabens10367003grabens
gradins93416233gradins
grains74223093gra_ins
grans64832543gra__ns
gratins84119183gratins
graying124115883graying
grayout1148513grayout
grayouts1244693grayouts
grays95621333gray__s
grisons838993grisons
halons95720713_halons
irons55324133ir__ons
jargons1558203jargons
kaons95014853_ka_ons
kayoes134710823_kayoes
kayos127714703_kayo_s
klaxons1833263klaxons
krakens1034293krakens
kroons103711243kr_oons
lardons83914493lardons
layins93817653_layins
macons104017243_macons
maroons92615553maroons
marrons93216973marrons
masons83916513_masons
mayors115714193_mayors
mayos105521933_mayo_s
octagons1144493octagons
orations81515803orations
orators7313823orators
organons945583organons
orisons7310563orisons
orlons6411013or_lons
paeons83915523_paeons
paragons11311513paragons
pardons103817623pardons
parsons93516873parsons
partons94620513partons
payors114312643_payors
pinyons12299003pinyons
praos74923563pra_o_s
prawns11509023pra_wns
prayers124212853prayers
praying133717323praying
prays105022433pray__s
prions84317783pr_ions
prisons9313223prisons
protons93118003protons
racon75422143_racon_
racoons93912433_racoons
radon64620503_radon_
rains55140233_ra_ins
ramona8412413_ramona
ramonas9311093_ramonas
ramous8417113_ramous
ramsons939563_ramsons
ratans63819373_ratans
rations74123433_rations
ratoons73815473_ratoons
ratos55528773_rato_s
rattons73815323_rattons
ravens93916883_ravens
ravins94622563_ravins
rawins95617623_rawins
rayahs12579193_rayahs
rayas85922053_ray_as
raying105027193_raying
rays77642353_ray__s
razors154711663_razors
reasons72514943reasons
recons84922993_recons
redons75222183_redons
rhytons13295883_rhytons
ronyons10258433ronyons
ryots85313783_r_yots
sabayons1343963sabayons
salons63823693_salons
seasons72614233seasons
talons64019443_talons
tardyons1244613tardyons
tarpons92612213tarpons
tauons63412673_tauons
taxons134211503_taxons
toyons95512133_toyons
trains64725343tra_ins
trans54933043tra__ns
trapans92812463trapans
travois1037883travois
trays85623433tray__s
treasons848683treasons
trigons84312093trigons
tritons73814883tritons
trogons83410723trogons
uranous7310733uranous
wagons103911213_wagons
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
yapons114411773_yapons
zayins18409713_zayins

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 Limit1340273426.98319193.3
3Display Results3423420.1262714.3
 (SQL Overall)1786913427.51523777.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.