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

463 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
tampon10291123(None) 
tampan102512321tampan
tampion11298661tampion
tampons112711551tampons
tarpon82812801tarpon
camion103917192camion
campion133011412campion
campo115219762campo_
campong14318122campong
campos125217952campos
capon95221872ca_pon
crampon1336942crampon
dampen114310592dampen
damson938062damson
gammon1138902gammon
kampong16294932kampong
lampion11278302lampion
lampoon11267192lampoon
mammon939642mammon
pompon1238942pompon
rampion11298582rampion
ramson8310462ramson
sampan102511892sampan
taipan82410662taipan
talion6317712talion
talon55824112ta_lon
tamein8313082tamein
tamp86133002tamp__
tampans113310982tampans
tamped114317042tamped
tamper104618512tamper
tamping122815812tamping
tampions12358112tampions
tamponed1336022tamponed
tamps95524082tamp_s
tarpan82814292tarpan
tarpons92612202tarpons
tauon54816582ta_uon
taxon124414662ta_xon
tempo95214972tempo_
tempos103812292tempos
tompion11247102tompion
tympan13257012tympan
yapon104613582ya_pon
yaupon11345492yaupon
aboon74918703_aboon
aeon45634613_a_eon
agon56531883_a_gon
amain74922883_amain
amazon1736823_amazon
ambo88225133_ambo_
ambos95321243_ambos
amen66733153_am_en
amin66042243_am_in
amino75425493_amino
ammo85520133_ammo_
ammono1047373_ammono
ammos94815823_ammos
amnion84812043_amnion
amok10217403_am_ok
among85813303_am_ong
amp77541023_amp__
amped104820513_amped
amping114317563_amping
ample94720303_ample
amply125012913_amply
amps86230343_amp_s
ampul91110853_ampul
ancon75718233_ancon
anion55028813_anion
anon46134853_a_non
anyon85615223_anyon
apo511142123_a_po_
apod78123183_a_pod
apos65433823_a_pos
apron7318833_apron
argon65520593_argon
arpen74418043_arpen
arson55118833_arson
aspen75216093_aspen
ataman81013063atam_an
atman75520143atm_an
avion84218343_avion
axion1211316913_axion
axon115524303_a_xon
azlon144312873_azlon
azon135725053_a_zon
baboon103613913baboon
bacon95620593ba_con
ballon84117493ballon
bamboo12310013bamboo
baron78131243ba_ron
baryon111211613baryon
basion84315853basion
baton75822423ba_ton
cajon144513903ca_jon
cameo95924993cameo_
cameos105818003cameos
camions113916133camions
camo85731753cam_o_
camos95927613cam_os
camp106336453camp__
camped134720233camped
camper124722213camper
camphol1645793camphol
camphor1636133camphor
campi116217783camp_i
camping143118973camping
campions143511293campions
campongs15356123campongs
campout13412853campout
camps116330263camp_s
campus125213923campus
campy145116183camp_y
cannon84514443cannon
canon74725303ca_non
canton85722993canton
canyon114512033canyon
capo85829213ca_po_
capons104119503ca_pons
capos94826073ca_pos
carbon104919043carbon
cardon94120853cardon
carton84522663carton
cation83925503cation
champion17276353champion
common12310803common
compo115318573compo_
compone136517193compone
compony1613011913compony
compos124818803compos
coupon102810993coupon
crampons1436643crampons
crampoon1444543crampoon
crepon1039933crepon
dacron94310693dacron
daemon9279593daemon
dahoon1039053dahoon
daikon11217243daikon
daimon9259713daimon
dalapon1044893dalapon
dalton7311273dalton
daman84821163dam_an
damn75724323dam__n
damp96228843damp__
damped124315583damped
dampens12348563dampens
damper114117753damper
damping133414003damping
damply14337893damply
damps105220413damp_s
damsons1038013damsons
demon86520313dem_on
etalon648973eta_lon
etamin81311853etam_in
etymon1134693etym_on
falcon11310293falcon
fanion94514323fanion
fanon84619013fa_non
gabion93211023gabion
gaboon93211773gaboon
gallon73715813gallon
gambol1138223gambol
gamin84422993gam_in
gammons1237973gammons
gamp98833213gamp__
gamps105323713gamp_s
garcon92912483garcon
garron73113493garron
gascon9339723gascon
gipon84212413_gipon
hadron102913753hadron
hagdon1188283hagdon
halon86124863ha_lon
hambone1439313hambone
hamper134518653hamper
happen134812193happen
harpin113614383harpin
harpoon1238313harpoon
hatpin112610603hatpin
hempen1338963hempen
impone103011853_impone
japan14411233ja_pan
jargon1448823jargon
jomon14610083jom_on
jupon14479193_jupon
kampongs17293033kampongs
kamsin1238323kamsin
kaon87521023ka__on
kapok10448783ka_pok
kation104315683kation
ladron73413323ladron
lagoon7410483lagoon
lamp86233823lamp__
lampad114510033lampad
lampas106615953lampas
lamped114017543lamped
lamping123116003lamping
lampions12277973lampions
lampoons12266863lampoons
lamps95624833lamp_s
lapin75222923la_pin
lardon74415063lardon
lemon75618183lem_on
lumpen104010663lumpen
macon94519953ma_con
macron103615673macron
mambo115215733mambo_
mambos125414493mambos
mammons1048513mammons
maroon83118203maroon
marron83717543marron
mascon103612743mascon
mason74820183ma_son
matron83918313matron
maypop1565143maypop
mon57561573__m_on
moon67140813__moon
muon65722733__muon
nasion63914083nasion
nation64322803nation
natron64116023natron
paeon74819493pa_eon
pampa114913423pamp_a
pampas124913993pampas
pampean1335543pampean
pamper124316663pamper
pardon94618733pardon
parson83817903parson
parton84720993parton
patron84018043patron
pompom1436493pompom
pompons1338553pompons
psammon1342543psammon
racon75422143ra_con
racoon83814473racoon
radon64620503ra_don
ramen75625193ram_en
ramona8412413ram_ona
ramp85934003ramp__
rampant11312173rampant
ramped114617903ramped
ramping123316873ramping
rampions12248023rampions
rampole1139693rampole
ramps96224633ramp_s
ramrod936833ramrod
ramsons939563ramsons
rappen103512713rappen
ration64226013ration
ratoon64417373ratoon
ratton64116123ratton
rayon83815703ra_yon
salmon84614183salmon
salon55228553sa_lon
saloon64418023saloon
sambo95118013sambo_
sambos104315193sambos
samp85733593samp__
sampans112411003sampans
sample104215013sample
samps96124673samp_s
sapor75119253sa_por
shampoo1435373shampoo
simoon858063simoon
stamen84115943stam_en
stamp95217363stamp__
stamped124812813stamped
stamper113714393stamper
stamping133310963stamping
stamps105614023stamp_s
station72717243station
stemson945163stemson
summon1037623summon
taboo73418093ta_boo
taboos83815423taboos
tabor75518393ta_bor
tabun75914373ta_bun
tachyon1544623tachyon
taco67031353ta_co_
tacos77023553ta_cos
taction93213023taction
tadpole1036143tadpole
tailor63412503tailor
tain45548073ta__in
taipans9269553taipans
taken94819143ta_ken
takin94921303ta_kin
talapoin1045003talapoin
talions7314093talions
talipot949723talipot
tallol63612223tallol
tallow93714203tallow
talons64019423ta_lons
tam58663423tam___
tamal73522613tam_al
tamale83717393tamale
tamals84116623tamals
tamari8313383tamari
tamarin9311893tamarin
tambac122210243tambac
tambak14249263tambak
tambour1136343tambour
tambur10358713tambur
tame66343663tam__e
tamed85528513tam_ed
tameins9311413tameins
tamely113711953tamely
tamer75230103tam_er
tamers84224033tamers
tames75242013tam_es
tamest85721293tamest
taming94023433taming
tamis76728723tam_is
tammie104212683tammie
tammy124013223tam_my
tampala1136613tampala
tampers113516743tampers
tamponing1445993tamponing
tams67247933tam__s
tan37167563ta___n
tango66921173tango_
tangos74216303tangos
tannin62613923tannin
tannoy958353tannoy
tanto55724943tanto_
tao38358953ta__o_
taos45541003ta__os
tap57663873ta_p__
tapa65129143ta_p_a
tapas74627713ta_pas
tape64538143ta_p_e
taped85327423ta_ped
taper74829773ta_per
tapes75838603ta_pes
taping94222393ta_ping
tapir75917063ta_pir
tapis75028863ta_pis
tapped113820053tapped
tapper104419613tapper
tappet103820113tappet
tapping123317133tapping
taps66050673ta_p_s
tardo65321103tardo_
tardyon1134673tardyon
tarn46842723ta__rn
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarp66936413tarp__
tarpans92513533tarpans
tarps76527113tarp_s
tartan64217513tartan
tarzan152910753tarzan
tatsoi637263tatsoi
tattoo6310973tattoo
tauons63412673ta_uons
taupe7314163taup_e
taupes8212673taupes
tauten64311893tauten
tautog765713tautog
tavern9428933tavern
tawpie11339143tawpie
taxman15328613taxman
taxmen15367443taxmen
taxol124011363ta_xol
taxons134211503ta_xons
teapot8416763teapot
teapoy1138113teapoy
teaspoon1044413teaspoon
teflon937453teflon
telamon936523telam_on
telson6310293telson
temp85323333temp__
temped113912893temped
tempeh13357463tempeh
temper103914093temper
tempi94912203temp_i
temping122710693temping
temple102811333temple
temps95417133temp_s
tempt95124843temp_t
tempts10439453tempts
tendon7312033tendon
tenon53320513t_enon
tenpin8310583tenpin
teopan839353teopan
tepoy10312163t_epoy
teston6313303teston
thoron94713903thoron
tiepin839343tiepin
tiglon737913tiglon
tigon63914443t_igon
timpana11226123timpana
timpani11266143timpani
timpano11235863timpano
tinpot8312513tinpot
toman75724053tom_an
tomboy1358213tomboy
tomcod1135783tomcod
tompions12267003tompions
ton310265103t___on
toon47740633t__oon
topo66932403t_opo_
topoi76018353t_opoi
topos75726393t_opos
torpor839193torpor
toyon86715673t_oyon
tramp96319773tramp__
tramped124312433tramped
tramper113812153tramper
tramping132711273tramping
trample11299703trample
tramps105114453tramp_s
trampy13499253tramp_y
trapan82412973trapan
trepan82511673trepan
trigon74513103trigon
tripod9399853tripod
tripos84014923tripos
triton63914893triton
trogon73611753trogon
tropin83316753tropin
tumor71110693tum_or
tump85927033tump__
tumped114216233tumped
tumping123114243tumping
tumps95420793tump_s
turion6313163turion
turnon638193turnon
tycoon1136023tycoon
tympana14255853tympana
tympani14275923tympani
tympano14245283tympano
tympans14236813tympans
tympany17254603tympany
typhon1436673typhon
typo95418123t_ypo_
typos106015813t_ypos
upon65817583__upon
vamp115521543vamp__
vamped144211013vamped
vamper134212653vamper
vamping152810233vamping
vamps125415483vamp_s
vampy15539403vamp_y
vapor104013093va_por
waggon1136393waggon
wagon94312953wa_gon
wampum15406053wampum
wampus13499013wampus
wanion93213063wanion
wanton94413813wanton
weapon11288113weapon
yamen104115183yam_en
yamun10419273yam_un
yapok14468153ya_pok
yapons114411773ya_pons
yaupons12345683yaupons
youpon11366003youpon
yupon10469483_yupon

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164636.44017502.5
3Display Results4634630.1533026.1
 (SQL Overall)1786914636.73326539.6
 
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.