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 “snares” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

201 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
snares6532903(None) 
nares55544151_nares
scares85033001scares
shares95236411shares
snakes103919601snakes
snare54429981snare_
snared74824551snared
snarer64620841snarer
snarers74216661snarers
snarfs95113421snarfs
snarks104815731snarks
snarls64016871snarls
snores64324321snores
spares84834551spares
stares66038751stares
antres65021002antres
ares45871022__ares
bares75457132_bares
blares85021632blares
cares77369182_cares
chares115631802chares
dares66146702_dares
enates64026432enates
ensnares856892ensnares
enures63919712enures
fares85852872_fares
flares94521702flares
glares75518872glares
gnarls74210772gnarls
gnarrs7407662gnarrs
gnars66718852gnar_s
hares86255542_hares
inanes62519802inanes
inarms8410092inarms
infares10313022infares
insnares858082insnares
inures63318952inures
knars94416112knar_s
knaves13439522knaves
knawes13328392knawes
lares54852632_lares
mares76457632_mares
nabes75427092_nabes
nacres85614452_nacres
names74833362_names
napes74828462_napes
narcs76122022_narcs
nards65928462_nards
naris55735292_naris
narks96026032_narks
nates55238332_nates
naves87030382_naves
pares77164482_pares
rares55247442_rares
sabes76437462s_abes
sabres85520862sabres
sades65239892s_ades
safes85226722s_afes
sages65339062s_ages
sakes95540752s_akes
sales56055592s_ales
sanes55649072s_anes
sanies63031952sanies
sards64736182s_ards
saree55044662s_aree
sarees65329942s_arees
sarges75128592s_arges
saris54544952s_aris
sarks96632462s_arks
saros55238062s_aros
sates54949322s_ates
saves85838632s_aves
saxes125229342s_axes
scales84529312scales
scapes105122262scapes
scare75334462scare_
scared95227292scared
scarer84524612scarer
scarers94618512scarers
scarey115016982scarey
scarfs114714682scarfs
scarps104718602scarps
scars75433532scar_s
scarts85321492scarts
scarves124511622scarves
scores84725922scores
seared75232842seared
searer65432022searer
searest73322022searest
sears54744912sear_s
senates73322612senates
senores73218112senores
seres55448892s_eres
shades105924532shades
shakes135024592shakes
shales94731252shales
shames114726222shames
shapes115124952shapes
shards104319172shards
share86437082share_
shared105829062shared
sharer95025482sharer
sharers104720622sharers
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
shaves125224932shaves
shires95225572shires
shores94830412shores
sires55945372s_ires
skates104219402skates
slakes104021882slakes
slates64934062slates
slaves95023022slaves
smarms105712532smarms
smarts86218002smarts
smazes174311662smazes
snacks124514552snacks
snafus936742snafus
snags64421312sna_gs
snails64816652snails
snake94821112snake_
snaked115017592snaked
snakey135011272snakey
snaps74719562sna_ps
snarf86525422snar_f
snarfed11378752snarfed
snark95419942snar_k
snarky134210842snarky
snarl54921082snar_l
snarled83612362snarled
snarler73610632snarler
snarlers8298752snarlers
snarly93815002snarly
snashes105214752snashes
snathes104816492snathes
snaths95112912snaths
snawed104813732snawed
snaws86116362sna_ws
sneers64016172sneers
snipes83917392snipes
snore55424952snore_
snored74819542snored
snorer64316762snorer
snorers74313802snorers
snorts64116502snorts
snyes85012752sn_yes
soared74324292soared
soarer64522242soarer
soarers74118092soarers
soars54732512soar_s
soaves94218672soaves
sonars64818972sonar_s
sores55454282s_ores
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spales84728102spales
spare75135562spare_
spared95427492spared
sparer84524962sparer
sparers94519612sparers
sparest94616432sparest
sparges104016342sparges
sparks124616362sparks
spars75431542spar_s
sparse84516342sparse
spates85028172spates
spires84628112spires
spores84726612spores
squares163714462squares
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stare54440262stare_
stared75429872stared
starer64027362starer
starers74522312starers
starets73515922starets
stars55836572star_s
starts65423122starts
starves104614552starves
stases64225562stases
states64337082states
staves94525192staves
steres63929532steres
stores65533662stores
sucres84218892sucres
swages104417072swages
swales93920762swales
swards105415132swards
sware85828212sware_
swarfs125612062swarfs
swarms116112172swarms
tares57456562_tares
unarms839242unarms
urares64519092urares
wares88250582_wares

Search took 4 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 Filter178691825510.326548131.9
2DLD Change Limit825512012.65631080.9
3Display Results2012010.0633190.5
 (SQL Overall)1786912013.04558683.4
 
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.