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

65 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
pillories118957(None) 
pilloried1265311pilloried
apiologies1339063apiologies
axillaries1744873axillaries
billies93923503bill__ies
billowier1444293billowier
billowiest1543633billowiest
biologies12311183biologies
calories102919553_calories
capillaries1554453capillaries
dillies84122163dill__ies
fillies103420253fill__ies
fulleries1248723fulleries
galleries10311703galleries
gillies84120963gill__ies
glories81915913__glories
grilleries1145593grilleries
helleries122611683helleries
hickories1845313hickories
hilloes103815963hillo__es
histories12412473histories
illogics1144593_illogics
ivories10310713_i_vories
killies113318113kill__ies
lories64933043___lories
millerites1247933millerites
milliaries1248243milliaries
pallors9314363pallor__s
pedlaries12108783pedlaries
pedleries1298783pedleries
pellitories1354833pellitories
pelorias10410593p_elorias
peltries10313023p_eltries
philologies1747203philologies
phyllaries1844453phyllaries
piclorams1544163piclorams
pierogies1245873pierogies
piggeries13107893piggeries
pilgrims1344143pi_lgrims
pillages113012613pill_ages
pillared11228093pillar_ed
pillaring1237643pillaring
pillarless1242543pillarless
pillars9313493pillar__s
pillboxes2053353pillboxes
pillory12247453pillor__y
pillorying1642793pillorying
pillowed14156383pillo_wed
pillowing1545493pillowing
pillows122610123pillo__ws
pineries102419083pi_neries
pirogies1139423pi_rogies
piscaries13410073piscaries
poultries1148453poultries
priories10312453p_riories
psaltries1185743psaltries
railleries1046643railleries
rifleries1247683rifleries
signories10107853signories
sillies73425083sill__ies
tilburies1144343tilburies
victories1448913victories
willies103920153will__ies
willowier1563783willowier
willowiest1643233willowiest

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 Filter1786911486410.406440125.6
2DLD Change Limit148641656.25023782.6
3Display Results65650.0331969.7
 (SQL Overall)178691656.68926714.2
 
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.