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

140 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
stairless918562(None) 
stainless9176491stainless
starless81610841sta_rless
airless73712042__airless
hairless1157412_hairless
sailless82410372s_ailless
scarless10189052sca_rless
stackless1555932stackless
staidness1037032staidness
stalkless1333722stalkless
stampless1334542stampless
starlets81610082sta_rlets
stateless937562stateless
tailless8239082_tailless
aidless83612073__aidless
aimless93610813__aimless
barless94317003_ba_rless
brainless1136403brainless
carless95118493_ca_rless
earless74316073_ea_rless
fairness1136563_fairness
fearless1137873fea_rless
gainless9117403_gainless
gearless937373gea_rless
grainless1035893grainless
heirless1146053_heirless
mailless10248583_mailless
oarless73913373_oa_rless
painless10108343_painless
rainless8129703_rainless
sailers73822323s_ai_lers
saltless8259343s_altless
sandless93212343s_andless
sapless93313443s_a_pless
sashless1136603s_ashless
satires72617573satir_e_s
satirises9410193satirises
savorless1243213savorless
scaleless1135513scaleless
scariness11310183scariness
scarlets10178573sca_rlets
seamless10238723sea_mless
seatless83213003sea_tless
sewerless1244303sewerless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shipless13277693s_hipless
shirtless12266413s_hirtless
shitless11249243s_hitless
sinless73014213s__inless
skilless12246763s_killess
skinless12216973s_kinless
skirtless13254423s_kirtless
slipless10246993s_lipless
slitless8268143s_litless
snapless10287463sna_pless
snarlers8298753sna_rlers
soapless10278073soa_pless
soilless8279033s_oilless
spaceless1335733spaceless
spanless10247363spa_nless
spinless10238703s_pinless
stabiles10311403stabile_s
stablers103611153sta_blers
stables93219073sta_ble_s
stablest103312943sta_blest
staddles10258693staddle_s
staginess1038753staginess
staidest939803stai_dest
stainers83212173stai_ners
stainlesses1144163stainlesses
stainlessly1452353stainlessly
staircase1143213staircase
staircases1243463staircases
stairhead1343323stairhead
stairheads1442763stairheads
stairlike1344753stairlike
stairs65416333stair___s
stairsteps1251733stairsteps
stairways1582403stairways
stairwell1261443stairwell
stairwells1361283stairwells
staithes1138953staithe_s
staleness9310783staleness
stales65538293sta__le_s
stalest73720173sta__lest
staplers103111203sta_plers
staples93617213sta_ple_s
starers74522313sta_r_ers
stares66038753sta_r_e_s
starets73515923sta_r_ets
starkers123712393sta_rkers
starkest1239723sta_rkest
starkness1335963starkness
starlet71620123sta_rle_t
starriest9159763starriest
starters83714773sta_rters
startlers9236743startlers
startles82111963startle_s
starvers11459643sta_rvers
starves104614553sta_rve_s
stemless1036653st_emless
sterlets8169273st_erlets
stiflers11238833st_iflers
stifles103013393st_ifle_s
stiles64328773st_i_le_s
stillest8311073st_illest
stillness936103st_illness
stingless1046463stingless
stirpes95011293st_irpe_s
stirrers8266943st_irrers
straitness1046293straitness
strapless1135793strapless
stress66616673st__r_ess
strifeless1343213strifeless
stringless1145353stringless
stripeless1243283stripeless
stuffless1543543stuffless
styleless1243413styleless
sugarless1043673sugarless
tackless14419483_tackless
tactless10288463_tactless
tailers73720183_tai_lers
tailles72516473_taille_s
taintless935733_taintless
tameless10259903_tameless
tankless12267823_tankless
tapeless10218643_tapeless
taxless1436913_ta_xless
tearless848713_tearless
tieless72512563_t_ieless
tipless92610063_t_ipless
tireless82510263_t_ireless
trailless935963trailless
twigless1293663_twigless
twirlers11274303_twirlers
warless104015103_wa_rless
waterless1238013waterless
weariless1234763weariless

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.1561145455.1
2DLD Change Limit1486411407.89018839.2
3Display Results1401400.0632222.2
 (SQL Overall)1786911408.10922036.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.