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

97 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
handfuls1511575(None) 
handful14127251handful_
canfuls1248422can_fuls
handguns1344362handguns
handouts1238232handouts
handsels12317252handsels
handsful1544082handsful_
hatfuls1386022ha_tfuls
headfuls1544312headfuls
panfuls1237172pan_fuls
tankfuls1543802tankfuls
aidful1057073_aidful_
annuls64711733_an_nuls
armfuls1275013_armfuls
bagfuls1334753ba_gfuls
baneful1237893baneful_
cagefuls1484343cagefuls
candours11408643candours
canful11610263can_ful_
cansful1236833cansful_
capfuls1436523ca_pfuls
carfuls1249133ca_rfuls
earfuls1036863ea_rfuls
hamauls12387823ha_mauls
handaxes1938403handaxes
handbags15116363handbags
handball1487033handball
handballs15116183handballs
handbell14114523handbell
handbells1594363handbells
handbill14115163handbill
handbills15114743handbills
handcars1437623handcars
handcuff2042553handcuff
handcuffs2152013handcuffs
handers114224333hand_ers
handfast1546733handfast
handfasts1644593handfasts
handgun1244623handgu_n
handheld1644463handheld
handhelds1743763handhelds
handhold1645633handhold
handholds1745003handholds
handily143610873hand_ily
handle104219293hand__le
handlers124014143handlers
handles114020653hand_les
handless123512063handless
handoffs1844733handoffs
handout11314103handou_t
handrails1346513handrails
hands95327383hand___s
handsaws1545873handsaws
handsel11308723handsel_
handsets12258343handsets
hangouts1236183hangouts
hangul1049223han_gul_
hangups1364823han_gups
hansels104011663han_sels
harmful1535763harmful_
hateful13107683hateful_
hatful12108743ha_tful_
hatsful13106193hatsful_
hauls86123733ha___uls
headful1445563headful_
heedful1444313heedful_
hindguts1343013hindguts
hopefuls1644073hopefuls
jarfuls1754773ja_rfuls
landaus8310343landau_s
landfall1244203landfall
landfalls1343813landfalls
landfill1253883landfill
landfills1343413landfills
lapfuls1234503la_pfuls
lungfuls1242773lungfuls
mandrels1137313mandrels
mandrils1138493mandrils
manful11610213man_ful_
mindful1344613mindful_
needfuls1242403needfuls
pagefuls1474343pagefuls
pailfuls1343843pailfuls
palmfuls1543473palmfuls
pandours11317993pandours
panful1179743pan_ful_
rackfuls1744643rackfuls
sackfuls1744163sackfuls
sandals82715203sand_als
sandburs11105623sandburs
sandfly1435643sandf_ly
tankful1445163tankful_
thankful1843253thankful_
tinfuls1036593tin_fuls
vandals113211663vand_als
vatfuls1384853va_tfuls
wamefuls1643873wamefuls

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 Filter1786911461620.453394461.4
2DLD Change Limit146162977.64019131.2
3Display Results97970.0462108.7
 (SQL Overall)178691978.13921954.9
 
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.