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 “sleepless” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
sleepless114455(None) 
seedless9319512s_eedless
sheetless1235822sheetless
sleekness1344542sleekness
sleepers103110112sleep_ers
sleepiest1136712sleepiest
sleepiness1245132sleepiness
sleeplessly1652212sleeplessly
sleeveless1341972sleeveless
slipless10246992sl_ipless
steeples1038012steeple_s
steepness1145712steepness
beefless1335493_beefless
bleepers12377493bleep_ers
cheekless1873883cheekless
cheerless1495293cheerless
clueless1035883clue_less
deedless10318253_deedless
deepness1136443_deepness
feeless103511103_fee_less
feetless1137383_feetless
flapless1335343fl_apless
fleckless1842893fleckless
fleetness1244753fleetness
fleshless1543993fleshless
glebeless1242953glebeless
greedless1144893greedless
heedless12278813_heedless
heelless11257653_heelless
helpless1335063_helpless
isleless834853isl_e_less
keelless12236193_keelless
leadless9248793_leadless
leafless11246573_leafless
leakless12246983_leakless
legless838013_l_egless
lensless835583_lensless
lipless9259553_l_ipless
needless9308333_needless
peerless1037503_peerless
pleatless1134613pleatless
sapless93313443s__apless
scentless1135113scentless
seamless10238723s_eamless
seatless83213003s_eatless
seepiest102412623s_eepiest
seeress7311573s_ee_ress
selfless1135013s_elfless
sewerless1244303sewerless
sexless1467243s__exless
shapeless1435563shapeless
sheerlegs1343293sheerlegs
sheerness1236273sheerness
shipless13277693s_hipless
shoeless1137803shoe_less
sinewless1244353sinewless
sleekens12274873slee_kens
sleekers12377993slee_kers
sleekest1236153slee_kest
sleekiest1336063sleekiest
sleeper93211563sleep_e_r
sleepier1036783sleepie_r
sleepings12335883sleepings
sleeplike1543463sleeplike
sleepovers1542223sleepovers
sleeps83913323sleep___s
sleepwear1441993sleepwear
sleetiest938553sleetiest
sleevelets1351613sleevelets
sleeves103311343slee_ve_s
slitless8268143sl_itless
snapless10287463s_napless
soapless10278073s_oapless
soleless8910033sole_less
soupless10268463s_oupless
speechless1742323speechless
stampless1334543stampless
steepens10277113steep_ens
steepers103011373steep_ers
steepest1038123steep_est
steeple937323steeple__
steepled1135893steeple_d
stemless1036653s_temless
strapless1135783strapless
sweepers13348163sweep_ers
sweepiest1435673sweepiest
sweetness1245683sweetness
treeless839283tree_less
weedless12287963_weedless
wheelless1543763wheelless
wheeples1634743wheeple_s
whelpless1742053whelpless

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.1531167915.0
2DLD Change Limit148641927.75019179.5
3Display Results92920.0801150.0
 (SQL Overall)178691927.98322383.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.