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

102 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
hymnless163280(None) 
homeless131110142homeless
hornless1137362hornless
humpless15226332humpless
rhymeless1741672rhymeless
aimless93610813aim_less
armless9369943arm_less
awnless1035923_awnless
boonless10328353boonless
chinless1337493chinless
dimness1038843dimn_ess
downless1236363downless
eyeless1058053ey_eless
fameless13259203fameless
fernless1136063fernless
finless102810783_finless
fumeless13236603fumeless
gainless9117403gainless
gumless10228273gum_less
gunless8299633_gunless
hairless1157413hairless
haltless11308443haltless
hamlets123211403ham_lets
handless123512063handless
hapless123311333h_apless
harmless1337403harmless
harness102413933harn_ess
hatless103813443h_atless
headless12289863headless
heatless113011463heatless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
henleys1334843h_enleys
herbless1336663herbless
hideless12278713hideless
hiltless11297123hiltless
hipless12399923h_ipless
hipness12277383hipn_ess
hitless103211193h_itless
hiveless14227933hiveless
holeless1189363holeless
hominess132712463hominess
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hotness1038613hotn_ess
hueless1058823h_ueless
humanness1443793humanness
humblers15379803humblers
humbles143215803humble_s
humblest15288283humblest
humorless1442963humorless
hurtless11307783hurtless
hymens1437993hym__ens
hymnals1543533hymn_als
hymned1535323hymn_e_d
hymnist1546633hymn_ist
hymnists1644903hymnists
hymnlike2043123hymnlike
hymns1337523hymn___s
hyphenless2151843hyphenless
hypnoses1646633hypnoses
innless7288293_innless
kinless113310273_kinless
limbless12246313limbless
limeless10249663limeless
manless93012933_manless
moonless10278043moonless
nameless10248373nameless
nounless837253nounless
painless10108343painless
planless1036813planless
pumpless14236373pumpless
rainless8129703rainless
reinless8139433reinless
rimless9369363rim_less
rumpless12256543rumpless
runless72810423_runless
shameless1435923shameless
shyness1344993shy_n_ess
sinless73014213_sinless
skinless12216973skinless
sonless72612613_sonless
spanless10247363spanless
spinless10238703spinless
sumless92611123sum_less
sunless73013693_sunless
tameless10259903tameless
thornless1243633thornless
thumbless1643433thumbless
timeless10239543timeless
tombless1236783tombless
townless1135653townless
unless62413073__unless
veinless11136263veinless
winless103212283_winless
womanless1443383womanless

Search took 7 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621025.79625217.7
3Display Results1021020.0462217.4
 (SQL Overall)1786911026.26228535.8
 
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.