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

268 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
weapons1227860(None) 
weakons14287801weakons
weapon11288111weapon_
weasons102310581weasons
beacons11410732beacons
capons104119502_capons
deacons10310392deacons
reasons72514942reasons
seasons72614232seasons
teapots939052teapots
teapoys1235962teapoys
wagons103911212w_agons
weakens14367062weakens
weakon13357622weakon_
weans85326742wea__ns
weaponed1445492weaponed
weaponry1642022weaponry
weason93210822weason_
yapons114411772_yapons
aeons57624653__aeons
agons66423783__agons
amazons1836643amazons
apods86316343__apods
apos65433823__apo_s
aprons8316993__aprons
axons125517933__axons
azons146518253__azons
bacons104917583_bacons
barons85025383_barons
batons85519423_batons
beacon10511373beacon_
beanos85516513beano_s
beans75734693bea__ns
beckons15279143beckons
bedpans1237173bedpans
belons84119413be_lons
betons84919553be_tons
bioweapons1751133bioweapons
blazons1836163blazons
canons85522063_canons
capon95221873_capon_
capos94826073_capo_s
celadons1137003celadons
cheapens15305943cheapens
cheapos14418513cheapo_s
claxons1635803claxons
coupons112710553coupons
crampons1436643crampons
cratons94316033cratons
crayons12439233crayons
crepons1139313crepons
daemons10269233daemons
dalapons1145433dalapons
deacon9510423deacon_
deadens93410693deadens
deadpans12205173deadpans
deafens11317253deafens
deans66131393dea__ns
decagons1235893decagons
decapods1444623decapods
deepens10307813deepens
demons94917723de_mons
depone93616553de_pone
depones103717093de_pones
depots94716343de_pots
despond1137513despond
desponds1246243desponds
despots10319683despots
devons104512253de_vons
dragons938383dragons
earns55927563_ea_rns
ebons74316093_e_bons
eikons1038503_eikons
eons46638713_e__ons
epos66723733_e_po_s
etalons739063etalons
exons125813343_e_xons
expos1449203_expo_s
fanons96115213_fanons
felons93615763fe_lons
flacons1238053flacons
flagons1137973flagons
gipons9389603_gipons
halons95720713_halons
headpins1436103headpins
heapers123616673heapers
heaping133015853heaping
heaps105223223heap__s
heavens13439303heavens
herons94820543he_rons
hexagons1943943hexagons
hexapods2143403hexapods
japans1539823_japans
jealous1438093jealous
jeans126022113jea__ns
jetons134512613je_tons
jettons1437273jettons
jupons15377803_jupons
kaons95014853_ka_ons
kapoks11347263_kapoks
kelsons1137323kelsons
klaxons1833263klaxons
lapins84520683_lapins
leadens83610983leadens
leans55536253lea__ns
leapers93716663leapers
leaping103215993leaping
leaps75522933leap__s
learns65513743lea_rns
leavens10409303leavens
legions84611783legions
lemons84415053le_mons
leptons91910413leptons
lesions73813863lesions
lessons73811013lessons
leukons1135753leukons
macons104017243_macons
masons83916513_masons
meadows1337333meadows
means75831223mea__ns
megapods1444893megapods
megatons11279693megatons
melons84117713me_lons
meltons9410923meltons
menazons1945733menazons
merlons93311273merlons
mesons83215843me_sons
metopons12107023metopons
neaps75618323neap__s
neatens73310403neatens
negatons9299273negatons
nektons1136393nektons
nelsons738003nelsons
neocons936913neocons
neons55818683ne__ons
neurons7410443neurons
newtons1036803newtons
paeons83915523_paeons
peahens12307573peahens
peans75437643pea__ns
pennons939713pennons
peons75327183pe__ons
pepos96620083pe_po_s
pereons92815003pereons
perrons93115483perrons
persons93717003persons
pompons1338553pompons
pons65850603___pons
racons84319343_racons
radons74118523_radons
rayons94113343_rayons
readorns938273readorns
reagins84215643reagins
reapers93520453reapers
reaping103621213reaping
reaps75626193reap__s
reason62616333reason_
reavows1335273reavows
reckons13269653reckons
recons84922993re_cons
redons75222183re_dons
regions83613473regions
reopens939373reopens
repins84924313re_pins
repos74725793re_po_s
repots85621003re_pots
respond1039113respond
responds1136913responds
responsa1043573responsa
response1037743response
respots92912763respots
salons63823683_salons
sapors84118813_sapors
seadogs958643seadogs
seaport9315593seaport
seaports1038463seaports
season62714903season_
seawans10379943seawans
sepoys1138473se_poys
sermons9311783sermons
setons64620173se_tons
sexpots1636293sexpots
sextons143710413sextons
talons64019423_talons
tampons112711553tampons
tarpons92612203tarpons
tauons63412673_tauons
taxons134211503_taxons
teapot8416763teapo_t
teapoy1138113teapo_y
teaspoons1143843teaspoons
teflons1036533teflons
telsons739203telsons
tempos103812293tempo_s
tendons8311473tendons
tenons62916603te_nons
tenpins9410073tenpins
teopans939203teopans
tepoys1137543te_poys
testons7313553testons
trapans92812463trapans
treasons848673treasons
vapors113812693_vapors
waggons1235503waggons
wagon94312953w_agon_
wahoos122310593w_ahoos
wains86930863w_a_ins
wakens135012043w_akens
wanions104011373wanions
wans76452263w_a__ns
wantons103713013wantons
waps96642083w_ap__s
warns87231003w_a_rns
wazoos18288553w_azoos
weaken13349603weaken_
wealds10459103wea_lds
weals85428743wea__ls
wealths13365813wealths
wean75734353wea__n_
weaners104613833weaners
weaning114117193weaning
weaponeer1442343weaponeer
weaponeers1542003weaponeers
weaponing1545383weaponing
weaponize2364403weaponize
weaponizes2464253weaponizes
weaponless1542003weaponless
weaponries1543073weaponries
wearers104615903wearers
wearies103020223wearies
wearing113318863wearing
wears86030303wea__rs
weasand1135503weasand
weasands1244563weasands
weasels10468503weasels
weavers133714463weavers
weaves123616373wea_ves
weaving143211623weaving
weazand2043613weazand
weazands2143333weazands
weblogs1334223weblogs
wedelns11325243wedelns
weens85224053we__ens
weepers123511973weepers
weepies122811743weepies
weeping133613673weeping
weepings14346483weepings
weeps104120563weep__s
weldors11238003weldors
welkins1437173welkins
wens76337933we___ns
whaps135115163whap__s
wheatens1454663wheatens
wigeons1136983wigeons
wons74942043w___ons
wontons103310533wontons
wraps105617153wrap__s
xenons132710483xe_nons
yapoks15346783_yapoks
yapon104613583_yapon_
yaupons12345683yaupons
yeans86624883yea__ns
yearns9509543yea_rns
youpons12265983youpons
yupons11398353_yupons
zealots1636763zealots
zealous1637813zealous
zeatins16311733zeatins

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.1561145455.1
2DLD Change Limit1340272687.59317651.4
3Display Results2682680.0932881.7
 (SQL Overall)1786912687.84222786.4
 
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.