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

62 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
fanfolds1510407(None) 
fanfold1485371fanfold_
enfolds11136252_enfolds
fanfolded1742312fanfolded
fantods11177622fanto_ds
infolds11137022_infolds
mangolds1235192mangolds
manifolds1583672manifolds
pinfolds1445142pinfolds
tenfolds1244412tenfolds
unfolds11146802_unfolds
affords1435023_affords
aholds10469483_a_holds
anoles64827423_an_oles
canfields1542833canfields
canfuls1248423canful_s
cannolis1037863cannolis
canolas9313993can_olas
enfold10137613_enfold_
eyefolds1542623eyefolds
factoids1446243factoids
fandoms13229473fando_ms
fanfares1436773fanfares
fanfics1535173fanf_ics
fanfolding1842743fanfolding
fanions103713073fanio_ns
fanons96115213fan_o_ns
fanos85926503fan_o__s
fantod102010033fanto_d_
fantoms12189153fanto_ms
fanworts1446103fanworts
farfals13268503farfal_s
farfels13348213farfel_s
fatwoods1585953fatwoods
faulds10438963fa__ulds
finfoots1444153finfoots
folds95221693___folds
fungoids1343993fungoids
ganoids939333gan_oids
gatefolds1443003gatefolds
handholds1745003handholds
infold10128163_infold_
kinfolks1453013kinfolks
mandolas1139133mandolas
mangold1137213mangold_
manholes13311183manholes
manhoods1447243manhoods
manifold1484943manifold_
manyfold1792743manyfold_
menfolks1742903menfolks
nailfolds1341843nailfolds
panfuls1237173panful_s
pinfold1336233pinfold_
refolds11298953_refolds
santols73513323santol_s
scaffolds1841573scaffolds
tenfold1145713tenfold_
twofolds1541613twofolds
unfold10179703_unfold_
unmolds10135743_unmolds
upfolds13133753_upfolds
vanloads1264163vanloads

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.1561145455.1
2DLD Change Limit146162628.34317519.1
3Display Results62620.0163875.0
 (SQL Overall)178691628.51520985.4
 
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.