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

331 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
spinless1023870(None) 
sinless73014211s_inless
skinless12216971skinless
spanless10247361spanless
spineless1136131spineless
chinless1337492chinless
finless102810782_finless
gainless9117402gainless
kinless113310272_kinless
painless10108342painless
rainless8129702rainless
reinless8139432reinless
sailless82410372sailless
shipless13277692shipless
shitless11249242shitless
skilless12246762skilless
slipless10246992slipless
slitless8268142slitless
soilless8279032soilless
sonless72612612s_onless
spiceless1335922spiceless
spielers10319652spielers
spiles84227912spi_le_s
spillers103311702spillers
spindlers12286452spindlers
spindles112710352spindle_s
spinels94512442spin_els
spines85132032spin_e_s
spinets94714812spin_ets
spiniest102813222spiniest
spininess1137962spininess
spinners103810862spinners
spinneys13335552spinneys
spinules10249332spinule_s
spotless1037042spotless
stainless9176492stainless
stingless1046462stingless
sunless73013692s_unless
veinless11136262veinless
winless103212282_winless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
aptness9268573aptn_ess
ashiness1138963ashin_ess
awnless1035923_awnless
bibless11439173_bibless
boonless10328353boonless
brainless1136403brainless
brimless1235273brimless
brineless1136243brineless
dopiness11289973dopin_ess
downless1236363downless
dripless1135243dripless
evilness1135043evilness
exitless1534883exitless
fernless1136063fernless
grainless1035893grainless
gunless8299633_gunless
hairless1157413hairless
heirless1146053heirless
hipless12399923_hipless
hipness12277383hipn_ess
hitless103211193_hitless
hornless1137363hornless
hymnless1632803hymnless
iciness938863icin_ess
inkless11348713__inkless
inlets63915573__inlets
innless7288293_innless
jointless1634323jointless
kindless13289243_kindless
kingless13288693_kingless
lidless8309273_lidless
lineless82711943_lineless
lintless82710013_lintless
lipless9259553_lipless
mailless10248583mailless
manless93012933_manless
mindless11319443_mindless
moonless10278043moonless
mopiness12259063mopin_ess
nounless837253nounless
openness1035473openness
opines84820703opin_e_s
paneless102611763_paneless
pegless1038053_pegless
piglets103311793_piglets
pileless1088623_pileless
piles74742613_pi_le_s
pileus84514943_pi_leus
pincers113916503_pincers
pinders103720473_pinders
pines76048863_pin_e_s
pingers104020743_pingers
piniest93121133_piniest
pinkens13419643_pinkens
pinkers134118603_pinkers
pinkest132812623_pinkest
pinkeys16378213_pinkeys
pinkness1436513_pinkness
pinners93518603_pinners
pinoles93418703_pinole_s
pintles94118723_pintle_s
piolets93513193_piolets
pipeless12107663_pipeless
pipiness1238003pipin_ess
pithless13117023_pithless
pitiless10127333_pitiless
planless1036813planless
pointless1135703pointless
princess12266803princess
printless1137513printless
raspiness1137303raspin_ess
ribless93410343_ribless
rimless9369363_rimless
rindless92510193_rindless
ropiness102311073ropin_ess
runless72810423_runless
sadness8310613sadn_ess
sailers73822323sai_lers
saltless8259343saltless
sandless93212343sandless
sapless93313443s_apless
sappiness1337433sappin_ess
sashless1136603sashless
scarless10189053scarless
scentless1135113scentless
scumless1254993scumless
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
seiners74219273sein_ers
seines65029903sein_e_s
selfless1135013selfless
seniles72618023senile_s
sexiness1537943sexin_ess
sexless1467243s_exless
shiftless15265303shiftless
shiners104015943shin_ers
shines95028913shin_e_s
shinglers13246443shinglers
shingles123111113shingle_s
shiniest113212493shiniest
shininess1237333shininess
shinleaf1442953shinleaf
shinleafs1541813shinleafs
shinneys14275093shinneys
shirtless12266413shirtless
shoeless1137803shoeless
shyness1344993shyn_ess
sidlers83414233s_idlers
sidles74721153s_idle_s
sighless1276553sighless
sillers73822103s_illers
sines55954823s_in_e_s
sinewless1244363s_inewless
sinews94210623s_in_ews
singers83824703s_ingers
singes74326853s_inge_s
singles83520433s_ingle_s
singlets93611473s_inglets
sinkers113618543s_inkers
sinlessly1254203s_inlessly
sinners74019023s_inners
sinters74024083s_inters
sinuses73011593s_inuses
siziness1737423sizin_ess
skiffless19243053skiffless
skillets12226823skillets
skinkers11298183skinkers
skinners12347293skinners
skirtless13254423skirtless
slimness1036523slimness
slingers93712683slingers
slyness1035263slyn_ess
smileless1134693smileless
smilers94113853smi_lers
smiles84522293smi_le_s
smileys12336323smi_leys
smogless1134053smogless
snapless10287463snapless
sniglets9276813sniglets
snowless1145633snowless
soapiness1138293soapin_ess
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soleless8910033soleless
songless9218823songless
soppiness1336543soppin_ess
soulless8218763soulless
soundless1035533soundless
soupless10268463soupless
spaceless1335733spaceless
spaciness1337083spacin_ess
spales84728103sp_ale_s
spallers102910733spallers
spancels1245273spancels
spangles1138893spangle_s
spaniels1045963spaniels
spankers14369863spankers
spanners103710773spanners
spellers102812753spellers
spencers12269193spencers
spences113413923spence_s
spenders113211743spenders
spenses92913573spense_s
sphinges14267483sphinge_s
sphinxes20334403sphinxe_s
spicers113815553spi_cers
spices104326033spi_ce_s
spiciest122711603spiciest
spiciness1347053spiciness
spicules12219803spicule_s
spiders103914413spi_ders
spiegels1133873spiegels
spieled104811883spiele_d
spieler93111233spiele_r
spiels85317953spi__els
spiers84421743spi__ers
spies76037623spi__e_s
spikelets1553393spikelets
spikers135311993spi_kers
spikes124520713spi_ke_s
spikiest14259533spikiest
spikiness1536313spikiness
spile75230083spi_le__
spiled94621993spi_le_d
spilled103613623spille_d
spiller92914333spille_r
spills84717463spi_l_ls
spilths12356023spi_lths
spinages11289293spinages
spinals93911863spin_als
spindle103210093spindle__
spindled12287643spindle_d
spindler11297983spindle_r
spindliest1344483spindliest
spine76534423spin_e__
spined95423943spin_e_d
spinel85317333spin_e_l
spinelessly1652513spinelessly
spinelle1046223spinelle
spinelles1146083spinelles
spinet85629753spin_e_t
spinier93715163spinie_r
spinner93912263spinne_r
spinnery13416593spinnery
spinney12438923spinne_y
spinnies103210543spinnies
spinoffs1642773spinoffs
spinors939423spin_ors
spinose937943spin_ose
spinous9310443spin_ous
spinouts1036023spinouts
spins75327983spin___s
spinsters1136613spinsters
spintos939133spin_tos
spinule9299993spinule__
spinulose1142913spinulose
spiraeas10286233spiraeas
spireas94412513spi_reas
spirems11499563spi_rems
spires84628113spi_re_s
spiriest102513453spiriest
spiritless1243743spiritless
spites84127333spi_te_s
spitters104113383spitters
spittles1038333spittle_s
spitzes1849183spitze_s
splines94718893splin_e_s
splinters11277923splinters
spoilers10238633spoilers
spondees1136483spondees
spongers1137603spongers
sponges10311043sponge_s
spoolers10349363spoolers
spoutless1134243spoutless
springers12309983springers
springes114014033springe_s
springlets1344023springlets
sprinklers1642973sprinklers
sprinkles1534923sprinkle_s
sprinters11329363sprinters
spryness1334003spryness
spyglass1442253spyglass
stairless9185623stairless
starless81610843starless
stemless1036653stemless
stiflers11238833stiflers
stifles103013393stifle_s
stiles64328773sti_le_s
stillest8311073stillest
stillness936103stillness
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stringless1145353stringless
suckless14288823suckless
sudsless944353sudsless
sumless92611123s_umless
supineness1245873supineness
supines94216383supin_e_s
swillers11299113swillers
swindlers13306033swindlers
swindles12319503swindle_s
swingers123710423swingers
swinges113413423swinge_s
swingles12319543swingle_s
swinneys14264203swinneys
swiples12339643swiple_s
tailless8239083tailless
taintless935733taintless
thinness11277163thinness
tieless72512563_tieless
tintless8239863_tintless
tipless92610063_tipless
townless1135653townless
twigless1293663twigless
unless62413073__unless
vainness1136063vainness
veinlets11144833veinlets
waspiness1435793waspin_ess
wigless11359673_wigless
windless123310863_windless
wineless112711173_wineless
wingless122910023_wingless
wispiness1435633wispin_ess
witless103310983_witless
zipless18276303_zipless

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.420425454.8
2DLD Change Limit1461623316.44022696.0
3Display Results3313310.1232691.1
 (SQL Overall)1786913316.98325589.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.