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

156 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
stackless155593(None) 
stalkless1333721stalkless
tackless14419481_tackless
backless162910632_backless
shacklers18336032shacklers
shackles173010592shackle_s
slackness1535432slackness
sockless14267792s_ockless
spaceless1335732spaceless
spackles16319952spackle_s
stackers143413562stack_ers
stainless9176492stainless
stairless9185622stairless
stampless1334542stampless
starkness1335962starkness
starless81610842sta_rless
stateless937562stateless
sticklers15227392sticklers
stickles142512102stickle_s
suckless14288822s_uckless
tacklers143010772_tacklers
tackles133816522_tackle_s
tactless10288462_tactless
tankless12267822_tankless
trackless15246722trackless
barkless14318023_barkless
beakless14297383bea_kless
blacklegs1843913blacklegs
blackness1735663blackness
bractless1335543bractless
cacklers163710703_cacklers
cackles153717203_cackle_s
checkless2044233checkless
clickless1743983clickless
crackles164111273crackle_s
faceless13269173_faceless
feckless17225783_feckless
fleckless1842893fleckless
flockless1843163flockless
frockless1843453frockless
graceless12226893graceless
grackles15309183grackle_s
hacklers173710303_hacklers
hackles162917063_hackle_s
jacklegs2233953_jacklegs
knockless1442443knockless
laceless10239853_laceless
leakless12246983lea_kless
luckless14265893_luckless
mackles154415753_mackle_s
matchless1644683matchless
neckless14236433_neckless
packness1636933_packness
peakless14236683pea_kless
placeless1335613placeless
rankless12268233_rankless
reckless14257973_reckless
retackles1545363retackle_s
rockless14297293_rockless
sackers133820223s_ack_ers
sailless82410373s_ailless
saltless8259343s_altless
sandless93212343s_andless
sapless93313443s_a_pless
sashless1136603s_ashless
scaleless1135513scaleless
scarless10189053sca_rless
seamless10238723sea_mless
searchless1543373searchless
seatless83213003sea_tless
shackle16409543shackle__
shackled18277603shackle_d
shackler17317973shackle_r
shackoes17367853shackoe_s
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
sickles133417543s_ickle_s
sickness1437833s_ickness
slackens14367713slack_ens
slackers143812743slack_ers
slackest14289393slack_est
slickness1535903slickness
smackers16318713smack_ers
snackers143010223snack_ers
snapless10287463sna_pless
soapless10278073soa_pless
spaciness1337083spaciness
spackle15369573spackle__
spackled17297803spackle_d
spanless10247363spa_nless
sparklers15315643sparklers
sparkles143210493sparkle_s
sparklets15275843sparklets
speckles16268133speckle_s
spiceless1335923spiceless
stabiles10311403stabile_s
stablers103611153sta_blers
stables93219073sta_ble_s
stablest103312943sta_blest
stacked143416123stack_e_d
stacker134416263stack_e_r
stacks124317263stack___s
stackups1643313stack_ups
stactes91914633stac_te_s
staddles10258693staddle_s
staginess1038753staginess
staidness1037033staidness
stakes103927293sta_k_e_s
staleness9310783staleness
stales65538293sta__le_s
stalest73720173sta__lest
stalkers12369853stalk_ers
stalkiest1347903stalkiest
staplers103111203sta_plers
staples93617213sta_ple_s
starkers123712393stark_ers
starkest1239723stark_est
starlets81610083sta_rlets
startlers9236743startlers
startles82111963startle_s
stemless1036653st_emless
stickers142913033stick_ers
stickies142211973stickie_s
stickiest15229603stickiest
stickiness1635903stickiness
stickle132410973stickle__
stickled15298973stickle_d
stickler14259573stickle_r
stingless1046463stingless
stockers143411073stock_ers
stockiest15207753stockiest
stockiness1645243stockiness
strapless1135793strapless
strickles1567813strickle_s
stuffless1543543stuffless
styleless1243413styleless
sucklers14379963s_ucklers
suckles134516743s_uckle_s
tackers134319623_tack_ers
tackets134914363_tack_ets
tackiest143112433_tackiest
tackiness1557693_tackiness
tackle123815733_tackle__
tackled143913183_tackle_d
tackler134013323_tackle_r
tailless8239083_tailless
tameless10259903_tameless
tapeless10218643_tapeless
taxless1436903_ta_xless
thankless1633203thankless
ticklers14339303_ticklers
tickles133416853_tickle_s
traceless11228643traceless
tuskless1234213_tuskless
wickless1736083_wickless

Search took 7 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.1531167915.0
2DLD Change Limit1486411566.70622165.4
3Display Results1561560.0602600.0
 (SQL Overall)1786911566.91925826.1
 
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.