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

99 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
joyful194384(None) 
boxful18145272boxful
jarful1646682jarful
joyfully2442832joyfully
joyous16276762joyous
jugful1734602jugful
potful1138082potful
sobful1136332sobful
topful1136542topful
unjoyful2151422unjoyful
woeful1236362woeful
woful1158172wo_ful
aidful1057073aidful
aimful1166703aimful
armful1167163armful
artful968273artful
awful1178143_awful
bagful1237213bagful
boatful1236283boatful
bookful1644773bookful
bowlful1544613bowlful
boxfuls19113603boxfuls
canful11610263canful
capful1368173capful
carful11610973carful
consul82312303consul
coypu12349873coypu_
coypus13389303coypus
cupful1356423cupful
doleful1146333doleful
doofus1036163doofus
doomful1343663doomful
earful958963earful
eyeful1235903eyeful
fitful1256333fitful
forkful1744773forkful
formful1545183formful
foul77027583fo__ul
hatful12108743hatful
honeyful1743533honeyful
hopeful1545903hopeful
ireful948713ireful
jarfuls1754773jarfuls
jarsful1744603jarsful
jestful1745333jestful
jonquil2342773jonquil
jorum145513743jo_rum
joual12311653jo_ual
jouk156015993jo__uk
joule124918203jo__ule
jovial1636543jovial
jowl146120303jo__wl
joy137036363joy___
joyed164811833joy_ed
joyfuller2251473joyfuller
joying173810803joying
joyously2143293joyously
joypop2063133joypop
joys146624663joy__s
jugfuls1843063jugfuls
jugsful1842683jugsful
lapful1156483lapful
lawful1235493lawful
loyal84513483loy_al
manful11610213manful
moanful12105003moanful
moghul1244473moghul
mogul8310213mo_gul
mugful1235403mugful
nonfuel1045733nonfuel
odorful1143483odorful
offal1136243_offal
panful1179743panful
playful1544653playful
potfuls1236293potfuls
poutful1236743poutful
poyou102611523poyou_
poyous112911623poyous
roomful1244183roomful
royal85014703roy_al
rueful948203rueful
sinful938803sinful
songful1145173songful
soul46435713so__ul
soulful1045293soulful
soyuz1748853soy_uz
swayful1643003swayful
tinful938043tinful
tofu76921333to_fu_
tofus86415423to_fus
toilful1044813toilful
topfull1244153topfull
trayful1344583trayful
tubful1136683tubful
useful947013useful
vatful12107083vatful
voyeur1232863voyeur
waeful1238123waeful
wilful1235963wilful

Search took 9 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 Filter1786911127160.376475242.0
2DLD Change Limit112716997.70314632.7
3Display Results99990.0303300.0
 (SQL Overall)178691998.10922036.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.