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

52 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
palmfuls154347(None) 
palmful1445051palmful_
armfuls1275012_armfuls
pagefuls1474342pagefuls
pailfuls1343842pailfuls
panfuls1237172pa_nfuls
aimful1166703_aimful_
almuds9378773_alm_uds
almugs9396423_alm_ugs
ampuls1098893_a_mpuls
armful1167163_armful_
bagfuls1334753ba_gfuls
baleful1238003baleful_
cagefuls1484343cagefuls
canfuls1248423ca_nfuls
capfuls1436523ca_pfuls
carfuls1249133ca_rfuls
earfuls1036863ea_rfuls
falafels1453113falafels
hamauls12387813ha_mauls
handfuls15115753handfuls
harmful1535763harmful_
hatfuls1386023ha_tfuls
jarfuls1754773ja_rfuls
ladlefuls1342133ladlefuls
lapfuls1234503la_pfuls
pageful1346353pageful_
pailful1236103pailful_
pailsful1343263pailsful_
painful1246403painful_
palatals1037773palatals
palliums1236703palliums
palls74332563pal___ls
palmers113513623palm_ers
palmists12268813palmists
palms94921753palm___s
palmtops1443543palmtops
palmyras1544033palmyras
palpus104210283pal_pu_s
panful1179743pa_nful_
pipefuls1543753pipefuls
platefuls1443963platefuls
playful1544653playful_
potfuls1236293p_otfuls
rackfuls1744643rackfuls
roomfuls1342823roomfuls
sackfuls1744163sackfuls
spadefuls1542683spadefuls
tablefuls1443223tablefuls
tankfuls1543803tankfuls
vatfuls1384853va_tfuls
wamefuls1643863wamefuls

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 Limit146162526.47022590.7
3Display Results52520.0163250.0
 (SQL Overall)178691526.90625874.7
 
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.