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

146 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
stainless917649(None) 
stairless9185621stairless
brainless1136402brainless
gainless9117402_gainless
grainless1035892grainless
painless10108342_painless
rainless8129702_rainless
sailless82410372s_ailless
sinless73014212s__inless
skinless12216972s_kinless
spanless10247362spa_nless
spinless10238702s_pinless
stackless1555932stackless
staginess1038752stagin_ess
staidness1037032staidness
stainers83212172stain_ers
stainlesses1144162stainlesses
stainlessly1452352stainlessly
stalkless1333722stalkless
stampless1334542stampless
starless81610842sta_rless
stateless937562stateless
stingless1046462st_ingless
stringless1145352stringless
tailless8239082_tailless
taintless935732_taintless
aidless83612073__aidless
aimless93610813__aimless
airless73712043__airless
awnless1035923__awnless
chinless1337493_chinless
curtainless1351933curtainless
finless102810783__finless
frailness1236543frailness
hairless1157413_hairless
kinless113310273__kinless
mailless10248583_mailless
manless93012933_ma_nless
matiness102114753matin_ess
plainness1155183plainness
planless1036813pla_nless
reinless8139433_reinless
sadness8310613s_adn_ess
sailers73822323s_ai_lers
saltless8259343s_altless
sandless93212343s_andless
sapless93313443s_a_pless
sashless1136603s_ashless
satinets8311733satin_ets
scaleless1135513scaleless
scaliness1149303scalin_ess
scariness11310183scarin_ess
scarless10189053sca_rless
seaminess11310473seamin_ess
seamless10238723sea_mless
seasonless1043373seasonless
seatless83213003sea_tless
sexiness1537943sexin_ess
shadeless1335733shadeless
shadiness1337463shadin_ess
shakiness1637083shakin_ess
shameless1435923shameless
shapeless1435573shapeless
shipless13277693s_hipless
shitless11249243s_hitless
siziness1737423sizin_ess
skilless12246763s_killess
slatiness92511363slatin_ess
slipless10246993s_lipless
slitless8268143s_litless
smallness1174513smallness
snakiness1367473snakin_ess
snapless10287463sna_pless
soapiness1138293soapin_ess
soapless10278073soa_pless
soilless8279033s_oilless
sonless72612613s__onless
spaceless1335733spaceless
spaciness1337083spacin_ess
spineless1136133s_pineless
stabiles10311403stabile_s
stablers103611153sta_blers
stables93219073sta_ble_s
stablest103312943sta_blest
staddles10258693staddle_s
staidest939803stai_dest
stained84215343stain_e_d
stainer73614923stain_e_r
stains64923653stain___s
staithes1138953staithe_s
staleness9310783staleness
stales65538293sta__le_s
stalest73720173sta__lest
stances93715963sta_nce_s
standees93310143sta_ndees
standers93514303sta_nders
stanes64933403sta_n_e_s
stanines85115673stanine_s
staplers103111203sta_plers
staples93617213sta_ple_s
starkness1335963starkness
starlets81610083sta_rlets
starnoses9157153starnoses
startlers9236743startlers
startles82111963startle_s
steadiness1146703steadin_ess
steaminess1236773steamin_ess
stemless1036653st_emless
sternness946093sternness
stiflers11238833st_iflers
stifles103013393st_ifle_s
stiles64328773st_i_le_s
stillest8311073st_illest
stillness936103st_illness
stingers94012743st_ingers
stinkers123111133st_inkers
stinters83312753st_inters
stoniness938343stoniness
strainers9510383strain_ers
straitness1046293straitness
strapless1135793strapless
strifeless1343213strifeless
stringers104210643stringers
stripeless1243283stripeless
stuffless1543543stuffless
styleless1243413styleless
sunless73013693s__unless
tackless14419483_tackless
tactless10288463_tactless
tailers73720183_tai_lers
tailles72516473_taille_s
tallness837103_tallness
tameless10259903_tameless
tankless12267823_tankless
tapeless10218643_tapeless
taxless1436913_ta_xless
thinness11277163_thinness
tieless72512563_t_ieless
tintless8239863_t_intless
tipless92610063_t_ipless
townless1135653_townless
trailless935963trailless
twigless1293663_twigless
vainness1136063_vainness
veinless11136263_veinless
winless103212283__winless

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411467.61019532.3
3Display Results1461460.0632317.5
 (SQL Overall)1786911468.07922118.0
 
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.