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

513 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
tarpons9261220(None) 
tampons112711551tampons
tarpans92513531tarpans
tarpon82812801tarpon_
aprons8316992_aprons
argons75018202_argons
arpens84814822_arpens
arsons63917212_arsons
barons85025382bar_ons
baryons121010472baryons
capons104119502ca_pons
carbons115418942carbons
cardons104519932cardons
cartons94122472cartons
garcons102411642garcons
garrons82713462garrons
harpins123615702harpins
harpoons1337472harpoons
jargons1558202jargons
lardons83914492lardons
maroons92615552maroons
marrons93216972marrons
pardons103817622pardons
parsons93516872parsons
partons94620512partons
taipans9269552taipans
talions7314092talions
talons64019422ta_lons
tampans113310982tampans
tampions12358112tampions
tampon102911232tampon_
tardyons1244612tardyons
tarns56433952tar__ns
tarocs84615662tar_ocs
taroks106115282tar_oks
taros55640822tar_o_s
tarots66422992tar_ots
tarpan82814292tarpan_
tarps76527112tarp__s
tartans72615822tartans
tarzans16329922tarzans
tauons63412672ta_uons
taxons134211502ta_xons
torpors939372torpors
trapans92812462trapans
turions7311572turions
turnons737862turnons
yapons114411772ya_pons
yaupons12345682yaupons
acarpous1245313acarpous
aeons57624653_a_eons
agons66423783_a_gons
anions64123033_anions
anyons94513503_anyons
apods86316343_a_pods
apos65433823_a_po_s
apron7318833_apron_
arbors84717873_arbors
archons12311583_archons
ardors74416863_ardors
argols74514613_argols
argon65520593_argon_
argots74116023_argots
armors85017813_armors
arpen74418043_arpen_
arpent84822093_arpent
arpents93613083_arpents
arrows92813483_arrows
arson55118833_arson_
arvos86015663_arvo_s
aspens85013353_aspens
atropins10410493atropins
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboons113211073baboons
bacons104917583ba_cons
ballons93916953ballons
barhops14288113barhops
barlows12259973barlows
barns76335143bar__ns
baron78131243bar_on_
barong96015823bar_ong
barongs105310833bar_ongs
barony115915303bar_ony
barrens94414323barrens
barrows123411683barrows
baryon111211613baryon_
barytons1345573barytons
basions94213953basions
batons85519423ba_tons
borons85520543bor_ons
burtons9310853burtons
camions113916133camions
campions143511293campions
campong14318123campong
campongs15356123campongs
campos125217953campo_s
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capon95221873ca_pon_
capos94826073ca_po_s
carbon104919043carbon_
carbos105122263carbo_s
carboys144711783carboys
cardon94120853cardon_
cardoons113411943cardoons
careens94514703careens
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
carious93320283carious
carlins93921913carlins
carns75937563car__ns
carobs104818103car_obs
carols85124983car_ols
caroms105619573car_oms
carpals113414623carpals
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
carping123521083carping
carpings133812383carpings
carpool1139223carpool
carpools1237883carpools
carport11316033carport
carports1238943carports
carps96932253carp__s
carpus105514303carp_us
carrions10312443carrions
carroms11512403carroms
carrots9714623carrots
carryons1337103carryons
carton84522663carton_
cartoons104012803cartoons
cations94524143cations
charpoys1834533charpoys
clarions10310493clarions
cordons104415763cordons
coupons112710553coupons
crampons1436643crampons
cratons94316033cratons
crayons12439233crayons
crepons1139313crepons
croons85418423_croons
dacrons103211033dacrons
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
dalapons1145433dalapons
daltons8310403daltons
dampens12348563dampens
damsons1038013damsons
darkens12409873darkens
darns66927893dar__ns
dragons938383dragons
durions839963durions
earns55927563ear__ns
earphone1348253earphone
earphones1448393earphones
etalons739063eta_lons
falcons1239123falcons
fanions103713073fanions
fanons96115213fa_nons
faros85532023far_o_s
farrows13259783farrows
frons86124043_fr_ons
gabions102410053gabions
gaboons10289893gaboons
gadroons1037013gadroons
gallons83015943gallons
gammons1237973gammons
garcon92912483garcon_
gardens93312093gardens
garron73113493garron_
gascons10289103gascons
gipons9389603_gipons
girons75014373gir_ons
gorgons938853gorgons
gyrons105511223gyr_ons
hadrons113314303hadrons
hagdons1258523hagdons
hairpins1365433hairpins
halons95720713ha_lons
happens14359173happens
harbors12412413harbors
hardens113815023hardens
hardpans1436453hardpans
harkens144112863harkens
harlots103413293harlots
harmins123716713harmins
harmony1538173harmony
harpers124916203harpers
harpies123818313harpies
harpin113614383harpin_
harping134118383harping
harpings14379773harpings
harpoon1238313harpoon
harps105926863harp__s
harrows132611033harrows
hatpins123410643hatpins
herons94820543her_ons
irons55324133_ir_ons
japans1539823ja_pans
jargon1448823jargon_
jargony1834493jargony
jargoons1644663jargoons
jupons15377803_jupons
kampong16294933kampong
kampongs17293033kampongs
kaons95014853ka__ons
kapoks11347263ka_poks
karns96624143kar__ns
karoos102415803kar_oos
kaross101910013kar_oss
karroos1139313karroos
kations114013663kations
kroons103711243_kroons
ladrons83813193ladrons
lagoons839253lagoons
lampions12277973lampions
lampoons12266863lampoons
lapins84520683la_pins
lardon74415063lardon_
lardoons9398483lardoons
largos74815063largo_s
macons104017243ma_cons
macrons113514893macrons
mammons1048513mammons
margins103815193margins
marlins93420473marlins
marmots11311513marmots
maroon83118203maroon_
marplots1245633marplots
marron83717543marron_
marrows122911813marrows
martens93714953martens
martins93322063martins
mascons113411583mascons
masons83916513ma_sons
matrons93517633matrons
maypops16104453maypops
merlons93311273merlons
morions94014633morions
morons84919543mor_ons
narcos86714203narco_s
narrows10258843narrows
nasions73112383nasions
nations74720563nations
natrons73215663natrons
orlons6411013_orlons
orpins83614163_orpins
paeons83915523pa_eons
pappous1057463pappous
paragons11311503paragons
pardon94618733pardon_
pareos87023773pareo_s
pargos95719043pargo_s
parians93519733parians
parlors9312913parlors
parlous9414293parlous
parols84722613par_ols
parous84024163par_ous
parrots9312743parrots
parson83817903parson_
partans94418283partans
parton84720993parton_
parvos116614753parvo_s
patrons93818103patrons
patroons102710603patroons
pereons92815003pereons
perrons93115483perrons
persons93717003persons
pompons1338553pompons
pons65850603___pons
prions84317783_prions
racons84319343ra_cons
racoons93912433racoons
radons74118523ra_dons
rampions12248023rampions
ramsons939563ramsons
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rayons94113343ra_yons
salmons93713253salmons
salons63823683sa_lons
saloons74415303saloons
sampans112411003sampans
sapors84118813sa_pors
sarans64224433sar_ans
sarcous9312933sarcous
sargos74318273sargo_s
sarins63932623sar_ins
sarods74918573sar_ods
sarong73914873sar_ong
sarongs84511803sar_ongs
saros55238063sar_o_s
sarsens7311393sarsens
sartors7314953sartors
sermons9311783sermons
sharpens13377813sharpens
stardoms1136793stardoms
stations82415213stations
taboos83815423ta_boos
tabors84517093ta_bors
tabuns8489223ta_buns
tachyons1644623tachyons
tacos77023553ta_co_s
tactions102912423tactions
tadpole1036143tadpole
tadpoles1135953tadpoles
tailors73212383tailors
tains54936323ta__ins
taipan82410663taipan_
takins105117403ta_kins
talapoins1144673talapoins
talcous939483talcous
talion6317713talion_
talipots1045613talipots
tallols73311353tallols
tallows103313733tallows
talon55824113ta_lon_
tameins9311413tameins
tampan102512323tampan_
tampers113516743tampers
tamping122815813tamping
tampion11298663tampion_
tamponed1336023tamponed
tamps95524083tamp__s
tangos74216303tango_s
tannins72813223tannins
tannoys1055553tannoys
tans46154813ta___ns
taos45541003ta__o_s
tapas74627713ta_p_as
tapers84025813ta_pers
tapes75838603ta_p_es
taping94222393ta_ping
tapirs84113173ta_pirs
tapis75028863ta_p_is
tappers113416543tappers
tappets113610013tappets
tapping123317133tapping
tappings13267713tappings
taproom1147963taproom
taprooms1246663taprooms
taproot9412673taproot
taproots1047253taproots
taps66050673ta_p__s
taramas9612693taramas
tarboosh1343143tarboosh
tardies84225863tardies
tardo65321103tardo__
tardyon1134673tardyon_
tares57456563tar__es
targes74524593tar_ges
targets84314223targets
tariffs1334593tariffs
taring73932283tar_ing
tarmacs1138323tarmacs
tarn46842723tar__n_
taro46846913tar_o__
taroc75721643tar_o_c
tarok97921073tar_o_k
tarot55943933tar_o_t
tarp66936413tarp___
tarragons1044473tarragons
tarres64723043tar_res
tarries73324263tarries
tarring83318303tarring
tars46763953tar___s
tarsals72512603tarsals
tarsias74013373tarsias
tarsus6310513tar_sus
tartan64217513tartan_
tartana73010193tartana
tartanas8258893tartanas
tartars73313403tartars
tarting84222653tarting
tarts57242023tar__ts
tarzan152910753tarzan_
tatsois748373tatsois
tattoos738643tattoos
tauon54816583ta_uon_
taupes8212673taup_es
tautens7317843tautens
tautogs875413tautogs
taverns10317803taverns
tawpies12309873tawpies
taxols13328633ta_xols
taxon124414663ta_xon_
teapots939053teapots
teapoys1235963teapoys
teardowns1343043teardowns
tearooms1047843tearooms
teaspoons1143843teaspoons
teflons1036533teflons
telsons739203telsons
tempos103812293tempo_s
tendons8311473tendons
tenons62916603t_enons
tenpins9410073tenpins
teopans939203teopans
tepoys1137543t_epoys
termors94712773termors
ternions838813ternions
terns55226873ter__ns
terpene92310853terpene
terpenes102111563terpenes
terrors73112203terrors
testons7313553testons
thorons104511913thorons
throbs118311373thr_obs
throes97518673thr_oes
throne98517603thr_one
thrones105715843thr_ones
throng10539973thr_ong
throngs11508163thr_ongs
throws129715233thr_ows
tiepins939463tiepins
tiglons837333tiglons
tigons74112253t_igons
tiros54524893tir_o_s
tompions12267003tompions
tons46553053t___ons
toons55027533t__oons
topos75726393t_opo_s
torchons1337503torchons
toros54336193tor_o_s
torous64319023tor_ous
torpids1037373torpids
torpor839193torpo_r
torsions839183torsions
torsos64815733torso_s
tortoni738033tortoni
tortonis848733tortonis
toyons95512133t_oyons
trains64725343t_rains
trans54933043t_r_ans
trapan82412973trapan_
trapes85024463trap_es
trappous1246013trappous
traps75727483trap__s
travois1037873travois
treens65317873t_reens
trepans92311593trepans
triens65417543t_riens
trigons84312093trigons
triols66117803t_riols
trios55528093t_rio_s
tripods10359053tripods
tripos84014923tripo_s
tritons73814883tritons
trogons83410713trogons
trogs67022603t_r_ogs
trois57226093t_r_ois
trona54118953t_r_ona
tronas63816893t_r_onas
trone55131863t_r_one
trones65629283t_r_ones
troops85712773t_roops
tropes84824353t_ropes
tropins93116303tropins
trots56629943t_r_ots
trows88826183t_r_ows
troys86418613t_r_oys
tsardoms1144133tsardoms
turbans939563turbans
turbos8910783turbo_s
turbots988023turbots
tureens7289873tureens
turgors836823turgors
turion6313163turion_
turkois1135133turkois
turnon638193turnon_
turns55623233tur__ns
turps74918733turp__s
tycoons1235173tycoons
tympans14236813tympans
typhons1537083typhons
typos106015813t_ypo_s
tyros85118593tyr_o_s
tzardoms2043273tzardoms
vapors113812693va_pors
various103113103various
varooms1248883varooms
virions1039873virions
waggons1235503waggons
wagons103911213wa_gons
wanions104011373wanions
wantons103713013wantons
wardens113711903wardens
warisons1136903warisons
warns87231003war__ns
warpers123413583warpers
warping133715183warping
warps107126423warp__s
warrens103810893warrens
weapons12278603weapons
yapoks15346783ya_poks
yapon104613583ya_pon_
yarns85621793yar__ns
yarrows13277853yarrows
yaupon11345493yaupon_
youpons12265983youpons
yupons11398353_yupons
zircons1854963zircons

Search took 9 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.1731032896.0
2DLD Change Limit1340275138.01616719.9
3Display Results5135130.1862758.1
 (SQL Overall)1786915138.37521336.2
 
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.