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 “pillaring” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
pillaring123765(None) 
pillaging1345561pillaging
cellaring1238532cellaring
collaring12310552collaring
pilfering1536392pilfering
pilling103722562pill__ing
pillorying1642792pillorying
pillowing1545492pillowing
pollarding1444232pollarding
tillering1037882tillering
allaying12339313_allaying
alluring939073_alluring
ashlaring1344493ashlaring
billabong1441963billabong
billeting1236643billeting
billing103823853bill__ing
billowing1545873billowing
blaring104317113__blaring
blearing113111943_blearing
bullring11388423bull_ring
clearing113014883_clearing
collaging1337923collaging
collating12312773collating
declaring1339573declaring
dilating102714913di_lating
epilating12310973epi_lating
fellating1339253fellating
filiating1339253filiating
filleting1335853filleting
filling113520803fill__ing
filliping1544233filliping
filtering13199723filtering
flaring114116803__flaring
fullering1336653fullering
gilling93520383gill__ing
gillying13306813gill_ying
glaring93714883__glaring
hilling113821773hill__ing
hilloaing1375433hilloaing
hilloing12158303hill_oing
hollaing12167093holla_ing
hollering1337743hollering
illuding1035803_illuding
illuming1135873_illuming
inlacing1158373_inlacing
inlaying1247893_inlaying
killing123118723kill__ing
milling103223683mill__ing
mislaying1557913mislaying
nilling83619563nill__ing
palleting1238743palleting
palliating1347893palliating
palling104024483pall__ing
palpating1438543palpating
paltering122612893paltering
paring94236493p___aring
parlaying1537303parlaying
pellagrin1253253pellagrin_
pellagrins1353413pellagrins
pelleting1237953pelleting
peltering122011673peltering
philtering1646253philtering
philtring1544173philtring
pickaxing2543103pickaxing
picturing1436033picturing
piling95025593pi_l__ing
pillar8314023pillar___
pillared11228093pillar_ed
pillars9313493pillar__s
pilloried1265313pilloried
pillories1189573pillories
piloting1139693pi_loting
pirating11314513pi_rating
placing123815283p__lacing
planing103418253p__laning
plating103823073p__lating
playing133816093p__laying
pleading123011443p_leading
pleasing112611593p_leasing
pleating112916053p_leating
poleaxing1944873poleaxing
polkaing1534633polka_ing
pollening1236923pollening
polling102920383poll__ing
polluting1235703polluting
preparing14311643preparing
prilling113413413prill__ing
pulling103821073pull__ing
pulsating1236343pulsating
rilling84023623rill__ing
silvering1337923silvering
spilling113113943spill__ing
tallaging1146493tallaging
tilling83522783till__ing
villain1038483villa_in_
villains1138013villa_ins
villainy1444883villa_iny
violating1337443violating
wildering1456743wildering
willing113821613will__ing
willowing1645323willowing
willying15306713will_ying

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411026.70322175.3
3Display Results1021020.0502040.0
 (SQL Overall)1786911027.17324911.6
 
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.