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

159 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
spadones113725(None) 
padrones112711042_padrones
spades94222582spad__es
spadices1336092spadices
spadixes1834112spadixes
spumones1254952spumones
abalones1038753abalones
adobes94411533__adobes
adonis7314063__adonis
adores74420723__adores
agones75719863__agones
amarones10311353amarones
amidones11348663amidones
apagoges12144693apagoges
apodoses1136653apodoses
atones65225773__atones
axones134614513__axones
cajones163311333_cajones
chalones13312173chalones
cladodes1245323cladodes
condones112817393condones
dadoes85616533_dado_es
dapsones1138383dapsones
epazotes1943773epazotes
epidotes1147023epidotes
epigones1138023epigones
espanoles1143943espanoles
flavones1435833flavones
gradines103615253gradines
ladrones92710973_ladrones
madrones112912283_madrones
opalines10311423opalines
paddies113715723_paddies
paddles113515643_paddles
padles95221123_pad_les
padouks1434873_padouks
padres95016983_pad_res
padrone102512073_padrone_
paeons83915523_paeon_s
pandores11312453_pandores
panes76148693_pa__nes
pannes85522853_pa_nnes
pardoned12189333_pardoned
pardoner11189443_pardoner
pardoners12208213_pardoners
pardons103817623_pardon_s
paroles95025883_paroles
patines95225763_patines
pavanes123612653_pavanes
peones83821043_p_eones
phones114121213_p_hones
pinones94717073_pinones
pones74547043_p__ones
pyrones123113303_pyrones
radomes10311053_radomes
radons74118533_radon_s
sabines94318483s_abines
saddens9309603s_addens
saddles95415743s_addles
sades65239893s_ad__es
sadhes104715373s_ad_hes
sadness8310613s_ad_ness
salines74029413s_alines
salons63823693s_alon_s
sanes55649073s_a__nes
sapotes9313943s_apotes
saprobes1237033saprobes
sardines92815573sardines
sarodes84216143s_arodes
sarongs84511803s_arongs
saroses73619333s_aroses
savines104417633s_avines
sawbones13126643sawbones
saxonies1537913s_axonies
scones84521303s__cones
seadogs958643seado_gs
seadromes1246093seadromes
seasoned948113seasoned
seasoner857693seasoner
seasoners946263seasoners
seasons72614233season_s
shades105924533shad__es
shadiness1337463shadiness
shadings13327433shadings
shadoofs1554233shadoofs
shadowed1644473shadowed
shadower1544863shadower
shadowers1644303shadowers
shadows1437193shado_ws
shakoes144510023shako_es
skatoles1236143skatoles
someones1039063someones
sones55444143s___ones
sordines92414073sordines
spaces104722633spa__ces
spaciness1337083spaciness
spacings13287043spacings
spackles16319953spackles
spade84423323spad__e_
spaded103816753spad__ed
spader94317133spad__er
spaders104214473spad_ers
spadilles1244993spadilles
spading113114383spadin_g
spado83713703spado___
spaeings11276253spaeings
spaes76029973spa___es
spahees1238263spa_hees
spaldeens1241793spaldeens
spales84728103spa__les
spandexes1943453spandexes
spangles1138893spangles
spanks124514123spa__nks
spanned104111223spa_nned
spanner94312563spa_nner
spanners103710773spa_nners
spans74528733spa__n_s
spareness1139863spareness
spares84834553spa__res
sparges104016343spa_rges
sparkles143210493sparkles
sparoids11218713sparoids
spates85028173spa__tes
spathes125116533spa_thes
spatzles1935303spatzles
spavies123012953spa_vies
spavined1434333spavined
spavins12419323spavin_s
spawned13316803spa_wned
spawner12347363spa_wner
spawners13396493spa_wners
spawns11577923spa_wn_s
spazzes1735263spa_zzes
sphenes123013163sp_henes
spines85132033sp__ines
splines94718893sp_lines
splodges1234153splodges
splores91910953sp_lores
spodes94817433sp__odes
spokes124417213sp__okes
sponges10311043sp__onges
spooned103412443sp_ooned
spooney12418243sp_ooney
spooneys13314583sp_ooneys
spoonies101911753sp_oonies
spoons84116023sp_oon_s
spores84726613sp__ores
spraddles13194283spraddles
spumone1154383spumone_
spumonis1264113spumonis
staddles10258693staddles
stades74626243stad__es
stanes64933403sta__nes
stanines85115673stanines
stones65130033s__tones
subtones10311383subtones
subzones1947223subzones
sulfones1147683sulfones
swaddles13296453swaddles

Search took 10 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621598.64016916.9
3Display Results1591590.0632523.8
 (SQL Overall)1786911599.12619580.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.