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

306 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
weapon1128811(None) 
weakon13357621weakon
weapons12278601weapons
weason93210821weason
beacon10511372beacon
capon95221872_capon
deacon9510422deacon
reason62616332reason
season62714902season
teapot8416762teapot
teapoy1138112teapoy
wagon94312952w_agon
weaken13349602weaken
weakons14287802weakons
wean75734352wea__n
weaponed1445492weaponed
weaponry1642022weaponry
weasons102310582weasons
yapon104613582_yapon
aeon45634613__aeon
agon56531883__agon
amazon1736833amazon
anon46134853__anon
apo511142123__apo_
apod78123183__apod
apos65433823__apos
apron7318833__apron
axon115524303__axon
azon135725053__azon
bacon95620593_bacon
baron78131243_baron
baton75822423_baton
beacons11410733beacons
bean66443863bea__n
beano75421553beano_
beanos85516513beanos
beaten84617063beaten
beckon14309383beckon
bedpan1137583bedpan
belon73924113be_lon
beton76022063be_ton
bioweapon1651153bioweapon
blazon1736763blazon
cajon144513903_cajon
canon74725303_canon
capo85829213_capo_
capons104119503_capons
capos94826073_capos
celadon1036913celadon
cheapen14407623cheapen
cheapo134810083cheapo_
cheapos14418513cheapos
claxon1536583claxon
coupon102810993coupon
crampon1336943crampon
craton84517193craton
crayon114110003crayon
crepon1039933crepon
daemon9279593daemon
dalapon1044893dalapon
deacons10310393deacons
deaden83714323deaden
deadpan11225233deadpan
deafen10389673deafen
dean56039483dea__n
decagon1135863decagon
decapod1335433decapod
deepen9339193deepen
demon86520313de_mon
depone93616553de_pone
depot85727923de_pot
despond1137513despond
despot93413293despot
devon95113683de_von
dragon838843dragon
earn46737553_ea_rn
eaten55323053_eaten
ebon66821103_e_bon
eikon939463_eikon
eon36052083_e__on
epos66723733_e_pos
etalon648973etalon
exon117116803_e_xon
expo1349183_expo_
expos1449203_expos
fanon84619013_fanon
felon84619293fe_lon
flacon1138633flacon
flagon1037983flagon
gipon84212413_gipon
halon86124863_halon
headpin1336003headpin
heap96432893heap__
heaped124516903heaped
heaper114119523heaper
heaping133015853heaping
heaps105223223heap_s
heapy135914983heap_y
heaven123912603heaven
hempen1338963hempen
hereon93914363hereon
heron85025503he_ron
hexagon1843823hexagon
hexapod2043653hexapod
japan14411233_japan
jean116629283jea__n
jeon116821443je__on
jeton124815403je_ton
jetton1338033jetton
jupon14479193_jupon
kaon87521023_ka_on
kapok10448783_kapok
kelson1038153kelson
keppen14346563keppen
klaxon1733853klaxon
lapin75222923_lapin
leaden74515223leaden
lean46345243lea__n
leap66032683leap__
leaped94317773leaped
leaper88118943leaper
leaping103215993leaping
leaps75522933leap_s
leapt75027473leap_t
learn55322663lea_rn
leaven95013073leaven
legion75712983legion
lemon75618183le_mon
lepton82510803lepton
lesion64715063lesion
lesson64412043lesson
leukon1036143leukon
macon94519953_macon
mason74820183_mason
meadow1237403meadow
mean65538093mea__n
megapod1344893megapod
megaron10248303megaron
megaton10269853megaton
melon73922083me_lon
melton8311553melton
menazon1846053menazon
merlon83012353merlon
meson74118313me_son
metopon11137073metopon
neap66927013neap__
neaps75618323neap_s
neaten64214543neaten
negaton8299143negaton
nekton1036583nekton
nelson638423nelson
neocon836713neocon
neon47026423ne__on
neuron6310373neuron
newton936983newton
paeon74819493_paeon
peahen113410133peahen
pean66147173pea__n
peasen84815963peasen
pelon74423213pe_lon
pennon8310643pennon
peon65635243pe__on
pepo87622153pe_po_
pepos96620083pe_pos
pereon83517453pereon
perron83216623perron
person83517873person
pompon1238943pompon
racon75422143_racon
radon64620503_radon
rayon83815703_rayon
readorn8310473readorn
reagin74915533reagin
reap65934743reap__
reaped94122453reaped
reaper84223143reaper
reaping103621213reaping
reaps75626193reap_s
reasons72514943reasons
reavow1235723reavow
reckon123010543reckon
recon75624243re_con
redon65424883re_don
region74614903region
reopen8311573reopen
repin75324703re_pin
repo66027543re_po_
repos74725793re_pos
repot75132623re_pot
respond1039113respond
respot83117633respot
rewon86920573re_won
salon55228553_salon
sapor75119253_sapor
seadog838743seadog
seaman84015903seaman
seamen84518563seamen
seaport9315593seaport
seasons72614233seasons
seawan94111223seawan
sepoy10314303se_poy
sermon8413553sermon
seton55223543se_ton
sexpot1539543sexpot
sexton133610793sexton
shapen114414653shapen
talon55824113_talon
tampon102911233tampon
tarpon82812803tarpon
tauon54816583_tauon
taxon124414663_taxon
teabox1536013teabox
teapots939053teapots
teapoys1235963teapoys
teaspoon1044413teaspoon
teflon937453teflon
telamon936523telamon
telson6310293telson
tempo95214973tempo_
tempos103812293tempos
tendon7312033tendon
tenon53320513te_non
tenpin8310583tenpin
teopan839353teopan
tepoy10312163te_poy
teston6313303teston
trapan82412973trapan
treason748763treason
upon65817583__upon
vapor104013093_vapor
waggon1136393waggon
wagons103911213w_agons
wahoo112413083w_ahoo
wain75840203w_a_in
waken124818473w_aken
wan66761943w_a__n
wanion93213063wanion
wanton94413813wanton
wap86553373w_ap__
waps96642083w_ap_s
warn75239323w_a_rn
waxen154911813w_axen
wazoo173011173w_azoo
weak117126303wea__k
weakens14367063weakens
weaker134015443weaker
weakly1636483weakly
weal75838683wea__l
weald95615023wea_ld
wealds10459103wealds
weals85428743wea_ls
wealth12379223wealth
weaned103816153weaned
weaner93816773weaner
weaning114117193weaning
weans85326743wea_ns
weaponeer1442343weaponeer
weaponing1545383weaponing
weaponize2364403weaponize
wear75836723wea__r
wearer94319403wearer
wearing113318863wearing
wears86030303wea_rs
weary115620613wea_ry
weasand1135503weasand
weasel93410523weasel
weave115218533wea_ve
weaved133913483weaved
weaver123916613weaver
weaves123616373weaves
weaving143211623weaving
weazand2043613weazand
weblog1234223weblog
wedeln10326693wedeln
ween75835463we__en
weep95131653weep__
weeper114313303weeper
weepie11258793weepie
weeping133613673weeping
weeps104120563weep_s
weepy134212593weep_y
weldor10317653weldor
welkin1337313welkin
wen66249603we___n
wept95635053we_p_t
whamo135511263whamo_
whap125119643whap__
whaps135115163whap_s
wheaten1336403wheaten
whereon13196503whereon
wigeon1037223wigeon
won66252063w___on
wonton93410963wonton
wrap96821973wrap__
wraps105617153wrap_s
wrapt105123183wrap_t
xenon122612453xe_non
yapok14468153_yapok
yapons114411773_yapons
yaupon11345493yaupon
yean75834583yea__n
yearn86316433yea_rn
youpon11366003youpon
yupon10469483_yupon
zealot15313473zealot
zeatin15412823zeatin

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.1401276364.3
2DLD Change Limit1127163065.40620850.2
3Display Results3063060.0963187.5
 (SQL Overall)1786913065.64231671.6
 
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.