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

46 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
fistfuls145456(None) 
fistful1365901fistful_
kistfuls1553831kistfuls
dishfuls1554312dishfuls
fistula1045502fist_ula
fistulas1155402fist_ulas
fitful1256332fi_tful_
kistful1465302kistful_
wistful1365712wistful_
boatfuls1344823boatfuls
chestfuls1742883chestfuls
cistus84611343cist_u_s
dishful1455433dishful_
distills9319043distills
distils83015803dist_ils
factful1536373factful_
faithfuls1842303faithfuls
feastful1444923feastful_
fiscals1238003fis_cals
fishtails1543663fishtails
fists85527543fist___s
fistulae1144533fist_ulae
fistular1144253fist_ular
fistulous1243313fist_ulous
fitfully1744993fi_tfully
forkfuls1843553forkfuls
fretful1346143fretful_
hatfuls1386023_hatfuls
jestful1745333jestful_
listels74212433list_els
lustful1045283lustful_
mistrals101212633mistrals
moistful1343853moistful_
pipefuls1543753pipefuls
pistils93314303pist_ils
pistols93213983pist_ols
pistous92714383pistou_s
potfuls1236293_potfuls
restful1038623restful_
sistrums1055323sistrums
tinfuls1036593ti_nfuls
tristful1144933tristful_
vatfuls1384853_vatfuls
wishful1664503wishful_
wistfully1844213wistfully
zestful1945243zestful_

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.436409841.7
2DLD Change Limit146162467.03320782.3
3Display Results46460.0133538.5
 (SQL Overall)178691467.48223882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.