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

193 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
spancels124527(None) 
spancel1147361spancel_
spaniels1045961spaniels
cancels114113312_cancels
chancels15439082chancels
panels84716522_pan_els
parcels113712662_parcels
pencels113610052_pencels
seances93015342seance_s
spacers113813872spa_cers
spaces104722632spa_ce_s
spanceled1443692spanceled
spandrels1243252spandrels
spangles1138892spangles
spaniel948922spaniel_
spankers14369862spankers
spanless10247362spanless
spanners103710772spanners
spencers12269192spencers
spences113413922spence_s
spinels94512442spin_els
stances93715962stance_s
angels74416173__angels
cancel105316683_cancel_
cancers114018583_cancers
cannels93413363_cannels
carcels114516063_carcels
chancel144011773chancel_
chancers154313493chancers
chances145218093chance_s
channels13388493channels
dancers103413093_dancers
dances95120653_dance_s
empanels1244823empan_els
espanoles1143943espanoles
evangels1243733evangels
fiancees1335103fiancees
fiances12310673fiance_s
flannels1134843flannels
glancers11408003glancers
glances104113143glance_s
hances115621283_hance_s
hansels104011653_hansels
impanels1245233impan_els
lancers93616643_lancers
lances84824103_lance_s
lancets93411163_lancets
mangels103614493_mangels
mantels94515043_mantels
marcels113212373_marcels
nances83618643_nance_s
nuances938523nuance_s
pacers105124543_pa_cers
paces96741113_pa_ce_s
panaceas1236763_panaceas
pancreas1235393_pancreas
panders103423733_panders
panel76023623_pan_el_
panes76148693_pan_e_s
panfuls1237173_panfuls
pangens103112063_pangens
panicles121010113_panicles
paniers94717333_paniers
panners93621273_panners
pannes85522853_panne_s
panzers184012013_panzers
parcel103915473_parcel_
parrels94713493_parrels
pascals11610013_pascals
passels93913023_passels
pastels95215183_pastels
pencel103812913_pencel_
pencils113011773_pencils
pincers113916503_pincers
ponces104720843_ponce_s
prancers123210333prancers
prances113618773prance_s
rances84625443_rance_s
repanels1036783repan_els
saices84221803s_aice_s
samiels939763s_amiels
sandals82715203s_andals
sanders84025943s_anders
sanely93114613s_an_ely
sanes55649073s_an_e_s
sangers84421943s_angers
sanicles10149943s_anicles
sanies63031953s_anie_s
sanseis73011603s_anseis
santols73513323s_antols
satchels13328163s_atchels
saucers93712133s_aucers
sauces84919503s_auce_s
saurels749303s_aurels
scalpels12345883scalpels
scandals1136993scandals
scanners10379703scanners
scarcely1534313scarcely
sconces113811453sconce_s
scrannels1143513scrannels
seance83716683seance__
shanteys14395513shanteys
simnels976103simn_els
skankers11316483skankers
slanders94014013slanders
sonances10310263sonance_s
space95325673spa_ce__
spaced114517253spa_ce_d
spaceless1335733spa_celess
spacer104917793spa_ce_r
spacey136212533spa_ce_y
spackle15369573spa_ckle
spackles16319953spa_ckles
spaders104214473spa_ders
spades94222583spa_de_s
spadices1336093spadice_s
spaes76029973spa__e_s
spahees1238263spa_hees
spails84817823spa__ils
spales84728103spa_le_s
spallers102910733spallers
spalls84217343spa__lls
spammers14378693spammers
spanceling1543943spanceling
spancelled1543003spancelled
spandex1735833spande_x
spandexes1943453spandexes
spandrel1144063spandrel_
spandrils1244163spandrils
spangle1038403span_gle
spangled1236153spangled
spangly1336473span_gly
spanked143111733spanke_d
spanker133612353spanke_r
spanks124514123span__ks
spanned104111223spanne_d
spanner94312563spanne_r
spans74528733span___s
spansule1043623spansule
spansules1143613spansules
sparely123410673spa_rely
sparers94519613spa_rers
spares84834553spa_re_s
spargers11389733spargers
sparges104016343sparge_s
sparkers144111313sparkers
sparkles143210493sparkles
sparsely1335123sparsely
spates85028173spa_te_s
spathes125116533spathe_s
spatters103914703spatters
spatzles1935303spatzles
spavies123012943spavie_s
spawners13396493spawners
spazzes1735263spazze_s
speels85116393sp__eels
spence103813793spence__
spencer113610973spence_r
spenders113211743spenders
spenses92913573spense_s
spicers113815553sp_icers
spices104326033sp_ice_s
spiegels1133873spiegels
spiels85317953sp__iels
spinals93911863spin_als
spindles112710353spindles
spinel85317333spin_el_
spines85132033spin_e_s
spinets94714813spin_ets
spinless10238703spinless
spinners103810863spinners
spinneys13335553spinneys
spinules10249333spinules
splicers12338113splicers
splices113914383splice_s
spondees1136483spondees
spongers1137603spongers
sponges10311043sponge_s
sprucely1543123sprucely
spruces113810503spruce_s
stammels12495563stammels
stance84316913stance__
stanchers14206813stanchers
stanches132312793stanches
stanchly1644443stanchly
standees93310143standees
standers93514303standers
stanes64933403stan_e_s
stanols739733stan_ols
stencils1046403stencils
subpanels1344393subpan_els
trances93919643trance_s
usances967373usance_s

Search took 9 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.420425454.8
2DLD Change Limit1461621937.65619091.2
3Display Results1931930.0802412.5
 (SQL Overall)1786911938.15621909.1
 
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.