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

279 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
soapless1027807(None) 
sapless93313441s_apless
snapless10287461snapless
soupless10268461soupless
capless114312762_capless
coalless1038192coalless
coatless1039692coatless
flapless1335342flapless
foamless13195842foamless
gapless10349992_gapless
goalless935722goalless
hapless123311332_hapless
hoopless13279262hoopless
loamless10235212loamless
napless93110282_napless
oarless73913372_oarless
roadless937702roadless
scarless10189052scarless
seamless10238722seamless
seatless83213002seatless
shapeless1435572shapeless
shipless13277692shipless
slipless10246992slipless
soapers93715922soap_ers
soapiest102412852soapiest
soapiness1138292soapiness
sockless14267792sockless
sodaless936112sodaless
soilless8279032soilless
soleless8910032soleless
songless9218822songless
sonless72612612so_nless
soulless8218762soulless
spanless10247362spanless
stampless1334542stampless
staplers103111202staplers
staples93617212staple_s
starless81610842starless
strapless1135792strapless
toadless936312toadless
topless92511122to_pless
awless939263__awless
barless94317003_barless
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootless103410983bootless
bowless123310313bo_wless
braless92910563bra_less
caplets114914523_caplets
carless95118493_carless
chadless1436403chadless
chaplets1556883chaplets
clawless1334123clawless
coalers94419353coa_lers
codeless112010113codeless
compress1439053compress
cookless14258633cookless
cordless11299963cordless
coreless103013833coreless
costless10310003costless
couplers123311323couplers
couples115317053couple_s
couplets12389873couplets
coxless1637743co_xless
cropless1237793cropless
doorless936713doorless
downless1236363downless
dripless1135243dripless
earless74316073_earless
fatless103212203_fatless
fearless1137873fearless
flagless1235403flagless
flawless1434503flawless
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
gasless8319013_gasless
gearless937373gearless
godless938403go_dless
gormless11235443gormless
hatless103813443_hatless
headless12289863headless
heatless113011463heatless
helpless1335063helpless
hipless12399923_hipless
holeless1189363holeless
homeless131110143homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hopeless13118303hopeless
hopples142810713hopple_s
hornless1137363hornless
hotpress1344303hotpress
humpless15226333humpless
jagless1537103_jagless
jawless1745653_jawless
jobless16237563jo_bless
joyless17226513jo_yless
lawless1037033_lawless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
lipless9259553_lipless
loftless1135903loftless
lordless9277483lordless
lossless835473lossless
loveless1168573loveless
manless93012933_manless
maples104819423_maple_s
matless93014043_matless
mealless10288363mealless
meatless103410863meatless
moonless10278043moonless
moveless1367753moveless
nopales93812523nopale_s
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oppress1135993_oppress
orbless937493_orbless
peakless14236683peakless
planless1036823planless
playless1334863playless
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
popples103011873popple_s
portless10310643portless
pulpless12224953pulpless
pumpless14236373pumpless
rayless10239003_rayless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
rumpless12256543rumpless
sables85026693s_able_s
sadness8310613s_adness
sailers73822323s_ailers
sailless82410373sailless
saleps85014903s_a_leps
sales56055593s_a_le_s
sallets73719653s_allets
saltless8259343saltless
samlets93813553s_amlets
samplers12299403samplers
samples112815453sample_s
sandless93212343sandless
sapiens9310173s_apiens
sappers113518903s_appers
sashless1136603sashless
scaleless1135513scaleless
scalers93817263sca_lers
scales84529313sca_le_s
scalpels12345883scalpels
scalpers123710863scalpers
scapes105122263scap_e_s
scarlets10178573scarlets
scoreless1155603scoreless
scumless1254993scumless
sealers74323553sea_lers
seedless9319513seedless
selfless1135013selfless
sexless1467243s_exless
shadeless1335733shadeless
shales94731253sha_le_s
shameless1435923shameless
shapers124016893shap_ers
shapes115124953shap_e_s
sharpness1434943sharpness
shitless11249243shitless
shoalest1168913shoa_lest
shoeless1137803shoeless
shoreless1236633shoreless
sighless1276553sighless
simples113014943simple_s
simplest122310223simplest
sinless73014213s_inless
skilless12246763skilless
skinless12216973skinless
slappers123710953slappers
sleepless1144553sleepless
slitless8268143slitless
smallest1039403smallest
smallness1174513smallness
smogless1134053smogless
smokeless1543553smokeless
snappers123510173snappers
snarlers8298753snarlers
snowless1145633snowless
soakers114114953soa_kers
soaped95817973soap_e_d
soaper84517873soap_e_r
soapier93411713soapie_r
soaplike1436903soaplike
soaps75120713soap___s
soapsuds1141983soapsuds
soarers74118093soa_rers
soaves94218673soa_ve_s
socles8418453so_cle_s
softness1136433softness
soleness8814263soleness
soles55547923so__le_s
soleus64615613so__leus
soppiest122511943soppiest
soppiness1336543soppiness
soreness8914793soreness
soundless1035533soundless
soupiest102212923soupiest
sourness839543sourness
spaceless1335733spaceless
spales84728103spa_le_s
spallers102910733spallers
spinless10238703spinless
spotless1037043spotless
spoutless1134243spoutless
stablers103611153stablers
stables93219073stable_s
stablest103312943stablest
stackless1555933stackless
stainless9176503stainless
stairless9185623stairless
stales65538293sta_le_s
stalest73720173sta_lest
stalkless1333723stalkless
stapes85028733stap_e_s
staple84415823staple__
stapled103613703staple_d
stapler93913643staple_r
starlets81610083starlets
stateless937563stateless
stemless1036653stemless
stopples1236953stopple_s
suckless14288823suckless
sudsless944353sudsless
sugarless1043673sugarless
sumless92611123s_umless
sunless73013693s_unless
supples11511283supple_s
supplest1248953supplest
suppress1236443suppress
swales93920763swa_le_s
swappers15358083swappers
swiples12339643swiple_s
tapeless10218643_tapeless
taxless1436913_taxless
tearless848713tearless
thawless1434083thawless
tipless92610063_tipless
toeless72612393to_eless
tombless1236783tombless
toneless8610393toneless
toolless836343toolless
topples113111653topple_s
townless1135653townless
toyless10268713to_yless
tramless1037503tramless
voteless1137493voteless
vowless13246603vo_wless
warless104015103_warless
wayless13308243_wayless
womanless1443383womanless
woodless12278453woodless
wordless12258843wordless
workless15276803workless
yokeless1535303yokeless
zipless18276303_zipless
zoneless1737823zoneless

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 Limit1461622798.00018270.3
3Display Results2792790.1102536.4
 (SQL Overall)1786912798.53020948.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.