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

47 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
pipefuls154375(None) 
pipeful1445641pipeful_
hopefuls1644062hopefuls
pagefuls1474342pagefuls
cagefuls1484343cagefuls
capfuls1436523cap_fuls
cupfuls1444343cup_fuls
dipperfuls1851623dipperfuls
direful1156613direful_
dishfuls1554313dishfuls
eyefuls1343843_eyefuls
fistfuls1454563fistfuls
hopeful1545903hopeful_
ireful948713_ireful_
kistfuls1553833kistfuls
lapfuls1234503lap_fuls
lifeful1344613lifeful_
pageful1346353pageful_
pailfuls1343843pailfuls
palmfuls1543473palmfuls
panfuls1237173p_anfuls
peepuls1134923p_eepuls
piceous11310693piceou_s
piculs103511753pi__culs
pileous9510523pileou_s
pileups11365433pile_ups
pileus84514943pile_u_s
pineals93212843pine_als
pipals104213643pip__als
pipeages1336423pipeages
pipefish1844533pipefish
pipeless12107663pipeless
pipers104318663pipe__rs
pipes96030143pipe___s
pipets105714773pipe__ts
pipettes1237563pipettes
piteous9310683piteou_s
pitiful1245863pitiful_
pixels15478533pixe__ls
platefuls1443963platefuls
potfuls1236293p_otfuls
prideful1443913prideful_
spadefuls1542683spadefuls
spiteful1344303spiteful_
tinfuls1036593ti_nfuls
wamefuls1643863wamefuls
wipeouts1354203wipeouts

Search took 8 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 Limit146162476.89321204.4
3Display Results47470.0133615.4
 (SQL Overall)178691477.32624391.3
 
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.