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

133 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
sheetless123582(None) 
cheekless1873882cheekless
cheerless1495292cheerless
feetless1137382_feetless
heatless113011462_heatless
heedless12278812_heedless
heelless11257652_heelless
scentless1135112scentless
seatless83213002s_eatless
seedless9319512s_eedless
sheerlegs1343292sheerlegs
sheerness1236272sheerness
sheeters113111862sheet_ers
shiftless15265302shiftless
shirtless12266412shirtless
shitless11249242sh_itless
shoeless1137802shoe_less
sleepless1144552sleepless
sweetness1245682sweetness
wheatless1534002wheatless
wheelless1543762wheelless
assetless943573assetless
beatless103311593_beatless
beefless1335493_beefless
beetlers1037393_beetlers
beetles9312083_beetle_s
beltless10297713_beltless
chartless1435703chartless
checkless2044233checkless
crestless1146783crestless
debtless1135653_debtless
deedless10318253_deedless
eventless1244603eventless
feeless103511103_fee_less
fleetness1244753fleetness
fretless1138063_fretless
greedless1144893greedless
haltless11308443_haltless
hatless103813443_h_atless
headless12289863_headless
heartless1236393_heartless
heathless1535593_heathless
heelers103815623_hee_lers
heirless1146053_heirless
helmless1334273_helmless
helpless1335063_helpless
herbless1336663_herbless
hiltless11297123_hiltless
hitless103211193_h_itless
hueless1058823_hue_less
hurtless11307783_hurtless
keelless12236193_keelless
meatless103410863_meatless
meetness1036653_meetness
needless9308333_needless
netless739863__netless
peerless1037513_peerless
peltless10267373_peltless
pleatless1134613pleatless
poetless1038723_poetless
restless82713163_restless
saltless8259343s_altless
seamless10238723s_eamless
seeress7311573s_ee_ress
seethes103613743s_eethe_s
selfless1135013s_elfless
settlers8289023s_ettlers
settles73916003s_ettle_s
sewerless1244303sewerless
sexless1467243s__exless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shearlegs1342493shearlegs
sheathers1557553sheathers
sheathes14610193sheathe_s
sheeneys14294903shee_neys
sheenies111411543sheenie_s
sheeniest12158353sheeniest
sheerest11310083shee_rest
sheeted113813043sheet_e_d
sheeter103814913sheet_e_r
sheetfed1544143sheetfe_d
sheetings13256713sheetings
sheetlike1644333sheetlike
sheets93918503sheet___s
sheeves133911953shee_ve_s
shellers112812573sh_ellers
shelterless1452043shelterless
shelters113412813shelt_ers
shelties111111383sheltie_s
shipless13277693sh_ipless
shoetrees1244353shoetrees
shoreless1236633shoreless
shortness1236733shortness
showerless1642543showerless
shtetels1143233shtet_els
shtetls1034583shtetl__s
shuttlers1254123shuttlers
shuttles1136553shuttle_s
sightless1385923sightless
sinewless1244363sinewless
skeeters12298963skeet_ers
skirtless13254423skirtless
sleekness1344543sleekness
sleetiest938553sleetiest
sleeveless1341973sleeveless
slitless8268143s_litless
soleless8910033sole_less
speechless1742323speechless
spotless1037043s_potless
spoutless1134243spoutless
stateless937563stateless
steeples1038013steeple_s
steepness1145723steepness
stemless1036653s_temless
sweetens11255433sweet_ens
sweetest1137173sweet_est
sweeties11159723sweetie_s
teethless1243703_teethless
tentless8229843_tentless
textless15245793_textless
thewless1433923th_ewless
treeless839283tree_less
ventless11249053_ventless
vestless11258843_vestless
weedless12287963_weedless
wheedlers1643193wheedlers
wheedles1534643wheedle_s
wheelers14287733whee_lers
wheeples1634743wheeple_s
whelpless1742053whelpless
zestless17247433_zestless

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 Limit1486411336.72022119.2
3Display Results1331330.0602216.7
 (SQL Overall)1786911337.21624763.2
 
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.