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

64 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
worthiness164591(None) 
earthiness1377242earthiness
frothiness1645722frothiness
portliness1246832portliness
swarthiness1743382swarthiness
unworthiness1853242unworthiness
wordiness13138632wor_diness
worminess14127612wor_miness
worthies14310282worthi_e_s
worthiest1538322worthi_est
worthinesses1845762worthinesses
worthless1544922worth_less
airworthiness1971703airworthiness
artiness81615403_art_iness
artsiness937653_artsiness
corkiness152810443cor_kiness
corniness112611183cor_niness
costliness1245993costliness
courtliness1343903courtliness
dirtiness1039473dirt_iness
dorkiness14248053dor_kiness
dottiness1058043do_ttiness
earthliness14144143earthliness
filthiness1643713filthiness
forkiness16268703for_kiness
goriness9310753gor__iness
goutiness1038763gout_iness
growthiness1842493growthiness
horniness12309143hor_niness
horsiness12259473hor_siness
loathness1244703loath_ness
loftiness1236573loft_iness
lordliness1144883lordliness
marshiness1555063marshiness
morphines1648233morphine_s
northings13185573northin_gs
pithiness1437563_pithiness
porkiness15249193por_kiness
pottiness1179703po_ttiness
rootiness979063root_iness
seaworthiness1962003seaworthiness
sootiness999833soot_iness
sorriness939583sor_riness
sportiness1278233sport_iness
tartiness92112053tart_iness
touchiness1544613touchiness
wariness11313213war__iness
washiness1537043w_ashiness
wealthiness1742853wealthiness
wintriness1345543wintriness
wiriness1138953wir__iness
wittiness12197223w_ittiness
wobbliness1742903wobbliness
wontedness1445503wontedness
woodiness13147873wo_odiness
wooliness12147693wo_oliness
woolliness1343563woolliness
wooziness21125213wo_oziness
worldliness1542493worldliness
wornness1136363wor__nness
worshipers1842523worshipers
worshipless1951073worshipless
worthier1436713worthi_e_r
worthing15178053worthin__g

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 Filter1786911406030.406440125.6
2DLD Change Limit140603646.34322166.6
3Display Results64640.0331939.4
 (SQL Overall)178691646.78226347.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.