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

399 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
starless8161084(None) 
scarless10189051scarless
stairless9185621stairless
starlets81610081starlets
barless94317002_barless
carless95118492_carless
earless74316062_earless
fearless1137862fearless
gearless937362gearless
oarless73913372_oarless
sapless93313442s_apless
scarlets10178572scarlets
seamless10238722seamless
seatless83213002seatless
snapless10287462snapless
snarlers8298752snarlers
soapless10278072soapless
spanless10247362spanless
stablers103611142stablers
stables93219072stable_s
stablest103312942stablest
stackless1555932stackless
stainless9176492stainless
stales65538292sta_le_s
stalest73720172sta_lest
stalkless1333722stalkless
stampless1334542stampless
staplers103111182staplers
staples93617212staple_s
starers74522312star_ers
stares66038752star_e_s
starets73515922star_ets
starkers123712392starkers
starkest1239722starkest
starkness1335962starkness
starlet71620122starle_t
starters83714762starters
startlers9236732startlers
startles82111962startle_s
starvers11459642starvers
starves104614552starve_s
stateless937562stateless
stemless1036652stemless
sterlets8169272sterlets
strapless1135782strapless
stress66616672st_r_ess
sugarless1043672sugarless
taxless1436902_taxless
tearless848702tearless
warless104015102_warless
airless73712043_airless
arles56735743__arle_s
armless9369943__armless
artless73712513__artless
awless939263__awless
barbless12318713_barbless
barkless14318023_barkless
barleys125011843_barleys
bathless13127383bathless
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
beatless103311593beatless
braless92910563bra_less
capless114312763_capless
careless102813633_careless
caress85720263_car_ess
carles85435083_carle_s
chadless1436403chadless
charleys1695633charleys
charmless1633573charmless
chartless1435703chartless
clawless1334123clawless
coalless1038193coalless
coatless1039693coatless
dateless9259963dateless
dearness939973dearness
doorless936713doorless
farles96025783_farle_s
farness102912203_farness
fatless103212203_fatless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
foamless13195843foamless
furless103210143_furless
gapless10349993_gapless
garbless11388253_garbless
gasless8319013_gasless
gateless9279953gateless
goalless935723goalless
hairless1157413hairless
hapless123311333_hapless
harmless1337403_harmless
harness102413933_harness
hatless103813443_hatless
headless12289863headless
heartless1236393heartless
heatless113011463heatless
heirless1146053heirless
jagless1537103_jagless
jawless1745653_jawless
largess8408913_largess
lawless1037033_lawless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
loamless10235213loamless
lusterless1043693lusterless
manless93012933_manless
mateless102711293mateless
matless93014043_matless
mealless10288363mealless
meatless103410863meatless
mortarless1243103mortarless
motorless1145723motorless
napless93110283_napless
nathless11127023nathless
nearness838313nearness
odorless934173odorless
parles86334393_parle_s
parleys125212373_parleys
pathless13138043pathless
peakless14236673peakless
pearlers1039023pearlers
peerless1037503peerless
planless1036813planless
playless1334863playless
rayless10239003_rayless
roadless937693roadless
sables85026693s_able_s
sadness8310613s_adness
sailers73822313s_ailers
sailless82410363sailless
saleps85014903s_a_leps
sales56055593s_a_le_s
sallets73719653s_allets
saltless8259343saltless
samlets93813553s_amlets
sandless93212343sandless
sarees65329943s_ar_ees
sarges75128593s_arge_s
saroses73619333s_aroses
sarsens7311393s_arsens
sashless1136603sashless
savorless1243213savorless
scaleless1135513scaleless
scalers93817263sca_lers
scales84529313sca_le_s
scarcest12169173scarcest
scarers94618503scar_ers
scares85033003scar_e_s
scarfers13408463scarfers
scariest101615943scariest
scariness11310183scariness
scarlet91516943scarle_t
scarpers124712513scarpers
scarves124511623scarve_s
scoreless1155603scoreless
scumless1254993scumless
sealers74323553sea_lers
searchless1543373searchless
searest73322023sear_est
seedless9319513seedless
seeress7311573seer_ess
selfless1135013selfless
sewerless1244303sewerless
sexless1467243s_exless
shadeless1335733shadeless
shales94731253sha_le_s
shameless1435923shameless
shapeless1435563shapeless
sharers104720623shar_ers
shares95236413shar_e_s
sharkers154011053sharkers
sharpens13377813sharpens
sharpers133810943sharpers
sharpest1339143sharpest
sharpness1434933sharpness
shearlegs1342493shearlegs
shipless13277693shipless
shirtless12266413shirtless
shitless11249243shitless
shoeless1137803shoeless
shoreless1236633shoreless
sighless1276553sighless
sinless73014213s_inless
skilless12246753skilless
skinless12216973skinless
skirtless13254423skirtless
slipless10246993slipless
slitless8268143slitless
smallest1039403smallest
smallness1174513smallness
smartass1044273smartass
smartens10286663smartens
smartest10310183smartest
smartness1136143smartness
smogless1134053smogless
snarers74216663snar_ers
snares65329033snar_e_s
snarled83612353snarle_d
snarler73610633snarle_r
snarliest91810193snarliest
snarls64016873snarl__s
snowless1145613snowless
soarers74118093soar_ers
sockless14267793sockless
sodaless936113sodaless
soilless8279023soilless
soleless8910033soleless
songless9218823songless
sonless72612613s_onless
soulless8218763soulless
soupless10268463soupless
sourness839543sourness
spaceless1335733spaceless
spales84728103spa_le_s
spallers102910723spallers
spareness1139863spareness
sparers94519613spar_ers
spares84834553spar_e_s
sparest94616423spar_est
spargers11389733spargers
sparges104016333sparge_s
sparkers144111313sparkers
sparklers15315633sparklers
sparkles143210483sparkle_s
sparklets15275833sparklets
sparsest1048813sparsest
spinless10238703spinless
spotless1037043spotless
stabbers12268723stabbers
stabiles10311403stabile_s
stable83921643stable__
stabled103514953stable_d
stableness1248813stableness
stabler94014933stable_r
stablish1348343stablish
stackers143413563stackers
stactes91914633stacte_s
staddles10258693staddle_s
stades74626243sta_de_s
staffers14247083staffers
stagers84116673sta_gers
stages75629493sta_ge_s
staggers10379843staggers
stagiest91613403stagiest
staginess1038753staginess
staidest939803staidest
staidness1037033staidness
stainers83212173stainers
stakes103927293sta_ke_s
stalags838643sta_lags
stale55637103sta_le__
staled74728103sta_le_d
stalely1039213sta_lely
staleness9310783staleness
staler64025823sta_le_r
stalkers12369843stalkers
stalks104614553sta_l_ks
stalled83515683stalle_d
stalls64019923sta_l_ls
stamens93411483sta_mens
stammels12495563stammels
stammers123611523stammers
stampers124211593stampers
stances93715963stance_s
standees93310143standees
standers93514303standers
stanes64933403sta_ne_s
stapes85028733sta_pe_s
staple84415823staple__
stapled103613693staple_d
stapler93913623staple_r
starches131912913starches
stardoms1136793stardoms
stardust946093stardust
stardusts1043153stardusts
stare54440263star_e__
stared75429873star_e_d
starer64027363star_e_r
starfish1438083starfish
starker114114693starke_r
starlike1238813starlike
starling93017123starling
starlings10237923starlings
starlit71512913starl_it
starnose8136683starnose
starnoses9157143starnoses
starred85013453starre_d
starriest9159763starriest
stars55836573star___s
started84217323starte_d
starter73817873starte_r
startle72511123startle__
startled9208553startle_d
startler8248783startle_r
starts65423123star__ts
startsy10536703star_tsy
startups1033893startups
starve94613743starve__
starved114911573starve_d
starver104611993starve_r
stases64225563sta_se_s
stashes103916163stashe_s
staters73922323sta_ters
states64337083sta_te_s
statues74614903statue_s
statuses8409533statuses
staves94525193sta_ve_s
stayers103813633sta_yers
stealers83412193stealers
steles63725663st_ele_s
stereos74314973ster_eos
steres63929533ster_e_s
sterlet71318473sterle_t
sternest8314433sternest
sternness946093sternness
stewardess1442263stewardess
stiflers11238823stiflers
stifles103013383stifle_s
stiles64328763st_ile_s
stillest8311063stillest
stillness936093stillness
stingless1046463stingless
stirpes95011293stirpe_s
stirrers8266923stirrers
stoles63927673st_ole_s
stollens835283stollens
storers75018683stor_ers
stores65533643stor_e_s
storeys10559653stor_eys
stories7324273storie_s
strafers11379903strafers
strafes104515993strafe_s
strakes114218073strake_s
strass67117223st_r_ass
strasses81311433strasses
strayers113510133strayers
streeks11378713st_reeks
streels73811343st_reels
streets73312613st_reets
streps86218063st_r_eps
strews96817093st_r_ews
stuffless1543523stuffless
styleless1243413styleless
stylers10359343st_ylers
styles94418653st_yle_s
stylets10369213st_ylets
suckless14288823suckless
sudsless944353sudsless
sumless92611123s_umless
sunless73013693s_unless
swales93920763swa_le_s
swarmers1346323swarmers
swartness1236113swartness
tables84524883_table_s
tablets94714373_tablets
tackless14419483_tackless
tactless10288463_tactless
tailers73720183_tailers
tailless8239083_tailless
talers64628143_ta_lers
tales55451373_ta_le_s
tallest7317093_tallest
tallness837103_tallness
tameless10259903_tameless
tankless12267823_tankless
tapeless10218643_tapeless
tares57456563_tar_e_s
targes74524593_targe_s
targets84314223_targets
tarres64723043_tarre_s
tartest72517533_tartest
tartlets8289663_tartlets
tartness82210133_tartness
termless1036233_termless
thawless1434083thawless
tieless72512563_tieless
tipless92610063_tipless
tireless82510263_tireless
toadless936303toadless
toeless72612393_toeless
topless92511123_topless
toyless10268713_toyless
tramless1037503tramless
tress55423163_t_r_ess
tugless837383_tugless
turfless1135533_turfless
varlets10411573_varlets
vistaless1254573vista_less
votaress1144223votar_ess
wardless12249303_wardless
wartless11279923_wartless
waterless1238013waterless
wattless11268723wattless
wayless13308243_wayless
weariless1234763weariless

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.1561145455.1
2DLD Change Limit1461623998.75016704.2
3Display Results3993990.1562557.7
 (SQL Overall)1786913999.06219718.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.