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

91 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
thornless124363(None) 
hornless1137361_hornless
shoreless1236632shoreless
thorniest1236482thorniest
thorniness13264342thorniness
thowless1434612tho_wless
townless1135652t_ownless
boonless10328353_boonless
charmless1633583charmless
chartless1435703chartless
chinless1337493ch_inless
chorales133712883chorale_s
chortlers14305663chortlers
chortles133611323chortle_s
cordless11299963_cordless
coreless103013833_coreless
crownless1443423crownless
doorless936713door_less
downless1236363_downless
fernless1136063_fernless
fordless12289003_fordless
forkless15267433_forkless
formless13248083_formless
gormless11235443_gormless
harmless1337403_harmless
harness102413933_harn_ess
herbless1336663_herbless
holeless1189363_holeless
homeless131110143_homeless
hoodless12289733_hoodless
hoofless14258013_hoofless
hookless151238363_hookless
hoopless13279263_hoopless
hopeless13118303_hopeless
hornets104113553_horn_ets
hornfels1443793_hornfels
horniest112814043_horniest
horniness12309143_horniness
horseless1237223_horseless
hotness1038613_hotn_ess
hurtless11307783_hurtless
hymnless1632803_hymnless
lordless9277483_lordless
lornness836493_lornness
moonless10278043_moonless
normless10235923_normless
nounless837253_nounless
odorless934173odor_less
orbless937493__orbless
otherness1245513othern_ess
poorness1036363poorn_ess
portless10310643_portless
scoreless1155603scoreless
shirtless12266413shirtless
shoeless1137803sho_eless
shortness1236733shortness
sonless72612613_so_nless
tearless848713tear_less
termless1036233t_ermless
thankless1633203thankless
thawless1434083th_awless
thewless1433923th_ewless
thinness11277173th_inness
tholes94919783tho__le_s
thoraces13118943thorace_s
thoraxes1896363thoraxe_s
thorites11312393thorite_s
thornbush1751213thornbush
thorned11479403thorn_e_d
thornier1135323thornie_r
thornlike1643003thornlike
thorns95314103thorn___s
thorpes125010353thor_pe_s
thrones105715843thron_e_s
thumbless1643433thumbless
tireless82510263t_ireless
toadless936313t_oadless
toeless72612393t_o_eless
tombless1236783t_ombless
toneless8610393t_oneless
tonlets73212503t_o_nlets
toolless836343t_oolless
toothless1244683toothless
topless92511123t_o_pless
townlets1134773t_ownlets
toyless10268713t_o_yless
turfless1135533t_urfless
whortles14306743whortle_s
wordless12258843_wordless
workless15276803_workless
wornness1136363_wornness

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.423422437.4
2DLD Change Limit148641916.56022658.7
3Display Results91910.0332757.6
 (SQL Overall)178691917.01625469.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.