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

129 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
spadixes183411(None) 
spadices1336091spadices
radixes15259342_radixes
spades94222582spad__es
spadilles1244992spadilles
spadix1636112spadix__
spadones1137252spadones
spandexes1943452spandexes
spavies123012942spavi_es
admixes1765963__admixes
apatites10311293apatites
apomixes1934853apomixes
gradines103615253gradines
ladies75124883_ladi_es
maxixes1535253_maxixes
opalines10311423opalines
paddies113715723_paddies
paddles113515643_paddles
padis86227143_padi__s
padles95221123_pad_les
padres95016983_pad_res
pandies104224503_pandi_es
panmixes1934913_panmixes
paries84742513_pari_es
parises94827183_parises
patines95225763_patines
pavises125315493_pavises
paxes144928423_pa__xes
pixes144323173_p__ixes
podites103014733_podites
radices102314263_radices
readies83324713readi_es
roadies83317443roadi_es
sabines94318483s_abines
saddles95415743s_addles
sades65239893s_ad__es
sadhes104715373s_ad_hes
sadis64930853s_adi__s
sadisms10359113s_adisms
sadists83310853s_adists
saices84221803s_a_ices
salines74029413s_alines
samites93118713s_amites
sanies63031953s_ani_es
sardines92815563sardines
satires72617573s_atires
savines104417633s_avines
saxes125229343s_a__xes
scabies11613333scabi_es
seasides938743seasides
shades105924533shad__es
shadier113111153shadi_er
shadiest121711273shadi_est
shadiness1337463shadiness
shadings13327433shadings
shandies122714103shandi_es
shavies134213203shavi_es
sixes124526363s___ixes
skydives1952133skydives
soddies92312853soddi_es
sordines92414073sordines
spaces104722633spa__ces
spacier114011633spaci_er
spaciest122310893spaci_est
spaciness1337083spaciness
spacings13287043spacings
spacious1237813spacious
spackles16319953spackles
spade84423323spad__e_
spaded103816753spad__ed
spader94317133spad__er
spaders104214473spad_ers
spadille1145193spadille
spading113114383spadi_ng
spaeings11276253spaeings
spaes76029973spa___es
spahees1238263spa_hees
spahis11310383spahi__s
spails84817823spa_i_ls
spaits85017473spa_i_ts
spales84728103spa__les
spangles1138893spangles
spaniel948923spani_el
spaniels1045963spaniels
spares84834553spa__res
sparges104016343spa_rges
sparids103512123spari_ds
sparkles143210493sparkles
spates85028173spa__tes
spathes125116533spa_thes
spatzles1935303spatzles
spavie113611383spavi_e_
spaviet123011923spavi_et
spavined1434333spavined
spavins12419323spavi_ns
spazzes1735263spa_zzes
species11314133speci_es
speises93813933sp_eises
sphinxes20334403sphinxes
sphynxes23292423sphynxes
spices104326033sp__ices
spies76037623sp__i_es
spikes124520713sp__ikes
spiles84227913sp__iles
spines85132033sp__ines
spires84628113sp__ires
spites84127333sp__ites
splices113914383sp_lices
splines94718893sp_lines
spodes94817433spod__es
spraddles13194283spraddles
sprites94220333sp_rites
stabiles10311403stabiles
staddles10258693staddles
stades74626243stad__es
stadias8411113stadi_as
stadiums1145703stadiums
stanines85115673stanines
statices102712343statices
statives112710793statives
steadies9311123steadi_es
studies82413863studi_es
subfixes20207493subfixes
suffixes21196353suffixes
swaddles13296453swaddles
swamies123712063swami_es
toadies82914863toadi_es
updives1334713up_dives
wadies105121203_wadi_es

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621296.53022383.2
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.02925422.0
 
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.