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

134 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
strapless113579(None) 
sapless93313442s__apless
snapless10287462s_napless
soapless10278072s_oapless
stampless1334542stampless
staplers103111202st_aplers
staples93617212st_aple_s
starless81610842st_arless
straplesses1353282straplesses
strappers1346742strappers
stripeless1243282stripeless
tramless1037502_tramless
braless92910563_bra_less
capless114312763__capless
cropless1237793_cropless
dripless1135243_dripless
flapless1335343_flapless
gapless10349993__gapless
hapless123311333__hapless
napless93110283__napless
rayless10239003__rayless
sarapes94617743sarap_e_s
satrapies1147713satrapie_s
scarless10189053s_carless
scrapers125510533scrap_ers
scrapes116217663scrap_e_s
scrapies124612473scrapie_s
scrappers1545863scrappers
scrapples1534793scrapple_s
scrawlers1434753scrawlers
scruples1237433scruple_s
seamless10238723s_eamless
seatless83213003s_eatless
serapes95218103serap_e_s
shapeless1435563s_hapeless
sharpness1434933sharpness
shipless13277693s_hipless
sleepless1144553sleepless
slipless10246993s_lipless
sodaless936113soda_less
soupless10268463s_oupless
spanless10247363s_panless
sprawlers1433903sprawlers
stablers103611153st_ablers
stables93219073st_able_s
stablest103312943st_ablest
stackless1555933stackless
stainless9176493stainless
stairless9185623stairless
stales65538293st_a_le_s
stalest73720173st_a_lest
stalkless1333723stalkless
stapes85028733st_ap_e_s
staple84415823st_aple__
stapled103613703st_aple_d
stapler93913633st_aple_r
starkness1335963starkness
starlets81610083st_arlets
startlers9236743startlers
startles82111963startle_s
stateless937563stateless
stealers83412203stea_lers
steeples1038013steeple_s
steepness1145723steepness
stemless1036653st_emless
stingless1046463stingless
stipplers1334453stipplers
stipples1247023stipple_s
stopples1236953stopple_s
storables1146283storable_s
straddlers12203823straddlers
straddles11216403straddle_s
strafers11379913stra_fers
strafes104516003stra_fe_s
stragglers12305253stragglers
straggles11328503straggle_s
strainers9510383strainers
straitens946233straitens
straitest949173straitest
straitness1046293straitness
strakes114218073stra_ke_s
stranders10389933stranders
strangers104112163strangers
stranges94516763strange_s
strangest103210843strangest
stranglers11396823stranglers
strangles103011553strangle_s
strapped1357823strappe_d
strapper1258093strappe_r
strappiest1444373strappiest
straps87721783strap___s
strass67117223stra___ss
strasses81311443strasse_s
strawiest1237213strawiest
strayers113510143stra_yers
streamlets1243073streamlets
stress66616673str___ess
stressless942763stressless
strifeless1343213strifeless
stringless1145353stringless
stripers103911593strip_ers
stripes95320573strip_e_s
stripiest1138013stripiest
strippers1355773strippers
strollers937543strollers
strophes13310603strophe_s
stroppers1356713stroppers
stuffless1543543stuffless
styleless1243413styleless
sugarless1043673sugarless
tapeless10218643_t_apeless
taxless1436913_t_axless
tearless848713_tearless
thawless1434083_thawless
tipless92610063_t_ipless
toadless936313_toadless
topless92511123_t_opless
traceless11228643_traceless
trackless15246723_trackless
trailers82912923_trailers
trailless935963_trailless
tramplers13305883_tramplers
tramples122610203_trample_s
trapes85024463_trap_e_s
trapeses1039153_trap_eses
trapnest10310923_trapnest
trapnests1144433_trapnests
trappers123711043_trappers
trawlers113310203_trawlers
trawleys14284383_trawleys
treadless1036003_treadless
treeless839283_treeless
triples94616873_triple_s
triplets103510263_triplets

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411346.73322076.5
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.23224708.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.