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

307 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
spanless1024736(None) 
spinless10238701spinless
manless93012932_manless
painless10108342_painless
paneless102611762_paneless
planless1036812planless
sandless93212342s_andless
sapless93313442s_apless
scarless10189052scarless
seamless10238722seamless
seatless83213002seatless
sinless73014212s_inless
skinless12216972skinless
snapless10287462snapless
soapless10278072soapless
sonless72612612s_onless
spaceless1335732spaceless
spales84728102spa_le_s
spallers102910732spallers
spancels1245272spancels
spangles1138892spangle_s
spaniels1045962spaniels
spankers14369862spankers
spanners103710772spanners
spineless1136132spineless
spotless1037042spotless
stainless9176492stainless
starless81610842starless
sunless73013692s_unless
aptness9268573aptn_ess
awless939263__awless
awnless1035923_awnless
barless94317003_barless
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
boonless10328353boonless
brainless1136403brainless
braless92910563bra_less
brandless1236123brandless
capless114312763_capless
carless95118493_carless
chadless1436403chadless
chinless1337493chinless
clawless1334123clawless
coalless1038193coalless
coatless1039693coatless
downless1236363downless
earless74316073_earless
epaulets1043733epaulets
espanoles1143943espanole_s
fangless1237663_fangless
fatless103212203_fatless
fearless1137873fearless
fernless1136063fernless
finless102810783_finless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
foamless13195843foamless
gainless9117403gainless
gapless10349993_gapless
gasless8319013_gasless
gearless937373gearless
giantess933893giantess
glandless1134163glandless
goalless935723goalless
grainless1035893grainless
gunless8299633_gunless
handless123512063_handless
hapless123311333_hapless
hatless103813443_hatless
headless12289863headless
heatless113011463heatless
hornless1137363hornless
hymnless1632803hymnless
innless7288293_innless
jagless1537103_jagless
jawless1745653_jawless
kinless113310273_kinless
landless94011173_landless
lawless1037033_lawless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
leanness837373leanness
loamless10235213loamless
maneless102812343_maneless
matless93014043_matless
mealless10288363mealless
meanness1037183meanness
meatless103410863meatless
moonless10278043moonless
napless93110283_napless
nounless837253nounless
oarless73913373_oarless
openness1035473openness
ovalness1134673ovalness
padles95221123_padle_s
pales75753803_pa_le_s
palest83926223_pa_lest
palets85122313_pa_lets
pallets93919303_pallets
panders103423733_panders
panels84716523_pan_els
panes76148693_pan_e_s
pangens103112063_pangens
paniers94717333_paniers
panners93621273_panners
pannes85522853_panne_s
panzers184012013_panzers
parles86334403_parle_s
parleys125212373_parleys
passless10247223_passless
pastless102411203_pastless
pathless13138043_pathless
patness92912283_patness
peakless14236683peakless
pegless1038053_pegless
playless1334863playless
rainless8129703rainless
rankless12268233_rankless
rayless10239003_rayless
realness8410443realness
reinless8139433reinless
roadless937703roadless
runless72810423_runless
sables85026693s_able_s
sadness8310613s_adness
sailers73822323s_ailers
sailless82410373sailless
saleps85014903s_a_leps
sales56055593s_a_le_s
sallets73719653s_allets
saltless8259343saltless
samlets93813553s_amlets
sanders84025943s_anders
saneness82313723s_aneness
sanes55649073s_an_e_s
sanest64426693s_an_est
sangers84421943s_angers
sanies63031953s_anie_s
sanseis73011603s_anseis
sashless1136603sashless
scaleless1135513scaleless
scalers93817263sca_lers
scales84529313sca_le_s
scanners10379703scanners
scantest101710183scantest
scantness1135733scantness
scarlets10178573scarlets
scentless1135113scentless
scumless1254993scumless
sealers74323553sea_lers
seances93015343seance_s
seasonless1043373seasonless
seedless9319513seedless
selfless1135013selfless
sexless1467243s_exless
shadeless1335733shadeless
shales94731253sha_le_s
shameless1435923shameless
shanteys14395513shanteys
shapeless1435563shapeless
shipless13277693shipless
shitless11249243shitless
shoeless1137803shoeless
shyness1344993shyn_ess
sighless1276553sighless
skankers11316483skankers
skilless12246763skilless
slanders94014013slanders
slipless10246993slipless
slitless8268143slitless
slyness1035263slyn_ess
smallest1039403smallest
smallness1174513smallness
smogless1134053smogless
snarlers8298753snarlers
snowless1145633snowless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
soulless8218763soulless
soundless1035533soundless
soupless10268463soupless
spacers113813873spa_cers
spaces104722633spa_ce_s
spaciest122310893spaciest
spaciness1337083spaciness
spackles16319953spackle_s
spaders104214473spa_ders
spades94222583spa_de_s
spaes76029973spa__e_s
spahees1238263spa_hees
spails84817823spail__s
spale74929213spa_le__
spalled103113133spalle_d
spaller92713473spalle_r
spalls84217343spa_l_ls
spammers14378693spammers
spancel1147363spance_l
spandex1735833spande_x
spandexes1943453spandexes
spandrels1243253spandrels
spangle1038403spangle__
spangled1236153spangle_d
spangliest1345153spangliest
spaniel948923spanie_l
spanked143111733spanke_d
spanker133612353spanke_r
spanks124514123span__ks
spanned104111223spanne_d
spanner94312563spanne_r
spans74528733span___s
spansules1143613spansule_s
spareness1139863spareness
sparers94519613spa_rers
spares84834553spa_re_s
sparest94616423spa_rest
spargers11389733spargers
sparges104016343sparge_s
sparkers144111313sparkers
sparklers15315643sparklers
sparkles143210493sparkle_s
sparklets15275843sparklets
sparsest1048813sparsest
spates85028173spa_te_s
spathes125116533spathe_s
spatters103914703spatters
spatzles1935303spatzle_s
spavies123012943spavie_s
spawners13396493spawners
spazzes1735263spazze_s
spellers102812753spellers
spencers12269193spencers
spences113413923spence_s
spenders113211743spenders
spenses92913573spense_s
spiceless1335923spiceless
spielers10319653spielers
spiles84227913sp_ile_s
spillers103311703spillers
spindlers12286453spindlers
spindles112710353spindle_s
spinels94512443spin_els
spines85132033spin_e_s
spinets94714813spin_ets
spiniest102813223spiniest
spininess1137963spininess
spinners103810863spinners
spinneys13335553spinneys
spinules10249333spinule_s
spoilers10238633spoilers
spondees1136483spondees
spongers1137603spongers
sponges10311043sponge_s
spoolers10349363spoolers
spoutless1134243spoutless
sprawlers1433903sprawlers
spryness1334003spryness
spyglass1442253spyglass
stablers103611153stablers
stables93219073stable_s
stablest103312943stablest
stackless1555933stackless
stairless9185623stairless
stales65538293sta_le_s
stalest73720173sta_lest
stalkless1333723stalkless
stampless1334543stampless
stances93715963stance_s
standees93310143standees
standers93514303standers
stanes64933403stan_e_s
staplers103111203staplers
staples93617213staple_s
starlets81610083starlets
stateless937563stateless
stemless1036653stemless
stingless1046463stingless
strapless1135793strapless
suckless14288823suckless
sudsless944353sudsless
sugarless1043673sugarless
sumless92611123s_umless
swales93920763swa_le_s
swankest15105933swankest
tankless12267823_tankless
tapeless10218643tapeless
taxless1436913_taxless
tearless848713tearless
thankless1633203thankless
thawless1434083thawless
toadless936313toadless
townless1135653townless
tramless1037503tramless
unless62413073__unless
usualness993563usualness
veinless11136263veinless
wanness102610683_wanness
warless104015103_warless
wayless13308243_wayless
winless103212283_winless
womanless1443383womanless

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.423422437.4
2DLD Change Limit1461623077.45319611.2
3Display Results3073070.1232495.9
 (SQL Overall)1786913077.99922339.2
 
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.