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

135 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
shoreless123663(None) 
scoreless1155601scoreless
shoeless1137801sho_eless
coreless103013832_coreless
holeless1189362_holeless
homeless131110142_homeless
hopeless13118302_hopeless
hornless1137362_hornless
horseless1237222_horseless
shadeless1335732shadeless
shameless1435922shameless
shapeless1435572shapeless
shirtless12266412shirtless
shortness1236732shortness
shovelers15174942shovelers
showerless1642542showerless
smokeless1543552smokeless
soleless8910032s_oleless
soreness8914792s_oreness
thornless1243632thornless
boneless10310213_boneless
careless102813633_careless
charmless1633583charmless
chartless1435703chartless
cheerless1495293cheerless
chorales133712883chorale_s
chortlers14305663chortlers
chortles133611323chortle_s
codeless112010113_codeless
cordless11299963_cordless
cureless10319703_cureless
doorless936713door_less
fireless112810593_fireless
forceless1435723_forceless
fordless12289003_fordless
forelegs1236613_forelegs
forkless15267433_forkless
formless13248083_formless
gormless11235443_gormless
groveless13235363groveless
harmless1337403_harmless
herbless1336663_herbless
hideless12278713_hideless
hiveless14227933_hiveless
hoodless12289733_hoodless
hoofless14258013_hoofless
hookless151238363_hookless
hoopless13279263_hoopless
houseless1237473_houseless
hueless1058823_h_ueless
hurtless11307783_hurtless
ireless72312243__ireless
lordless9277483_lordless
loveless1168573_loveless
moreness10911573_moreness
moveless1367753_moveless
normless10235923_normless
noseless839513_noseless
noteless839403_noteless
odorless934173odor_less
orbless937493__orbless
poleless1089873_poleless
popeless1288473_popeless
portless10310643_portless
rhymeless1741673rhymeless
savorless1243213savor_less
scaleless1135513scaleless
scarless10189053scar_less
senseless945973senseless
sewerless1244303sewerless
sharpness1434943sharpness
sheerlegs1343293sheerlegs
sheerness1236273sheerness
sheetless1235823sheetless
shereefs1433863shere_efs
shiftless15265303shiftless
shipless13277693sh_ipless
shitless11249243sh_itless
shoalest1168913sho_alest
shoreline1246623shoreline
shorelines1346143shorelines
shores94830413shor__e_s
shorls94516203shor_l__s
shorteners1345083shorteners
shortens11288993shor_tens
shortest11310783shor_test
shorties11414583shortie_s
shortlist1246683shortlist
shortlists1344083shortlists
shoveled15195353shovele_d
shoveler14165583shovele_r
shovellers16173783shovellers
shovels13378393shovel__s
showerers1545073showerers
showiness1576073showiness
skirtless13254423skirtless
smileless1134693smileless
smogless1134053smo_gless
snorkelers1442273snorkelers
snowless1145633sno_wless
soapless10278073s_oapless
sockless14267793s_ockless
sodaless936113s_odaless
soilless8279033s_oilless
soleness8814263s_oleness
songless9218823s_ongless
sonless72612613s_o_nless
sorceress1144013s_orceress
sorels63921163s_orel__s
soulless8218763s_oulless
soupless10268463s_oupless
sourceless1273013sourceless
spaceless1335733spaceless
spareness1139863spareness
spiceless1335923spiceless
spineless1136133spineless
sporules1037703sporule_s
spotless1037043spo_tless
spoutless1134243spoutless
starless81610843star_less
stateless937563stateless
styleless1243413styleless
sureness8912903s_ureness
thowless1434613tho_wless
tireless82510263_tireless
toeless72612393_to_eless
toneless8610393_toneless
voteless1137493_voteless
wholeness1545373wholeness
whortles14306743whortle_s
wireless11249633_wireless
wordless12258843_wordless
workless15276803_workless
yokeless1535303_yokeless
zoneless1737823_zoneless

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.453394461.4
2DLD Change Limit1486411357.40620070.3
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.90522604.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.