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

100 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
pillaging134557(None) 
pillaring1237651pillaring
collaging1337932collaging
pilling103722562pill__ing
pillowing1545492pillowing
tallaging1146502tallaging
allaying12339313_allaying
alleging1038473_alleging
bilging114212683bi_l_ging
billabong1441963billabong
billeting1236643billeting
billing103823853bill__ing
billowing1545873billowing
cellaring1238533cellaring
collaring12310563collaring
collating12312783collating
dialoging1246313dialoging
dilating102714913di_lating
epilating12310973epi_lating
fellating1339253fellating
filiating1339253filiating
filleting1335853filleting
filling113520803fill__ing
filliping1544233filliping
gilling93520383gill__ing
gillying13306813gill_ying
hilling113821773hill__ing
hilloaing1375433hilloaing
hilloing12158303hill_oing
hollaing12167103holla_ing
illuding1035803_illuding
illuming1135873_illuming
imaging1138083_i_maging
incaging1288673_incaging
inlacing1158373_inlacing
inlaying1247893_inlaying
killing123118723kill__ing
milling103223683mill__ing
mislaying1557913mislaying
mispaging1537803mispaging
nilling83619563nill__ing
packaging1945163packaging
paging104020403p___aging
palleting1238743palleting
palliating1347893palliating
palling104024493pall__ing
palpating1438543palpating
parlaying1537303parlaying
passaging1345613passaging
pellagrin1253263pellagrin_
pellagrins1353423pellagrins
pelleting1237953pelleting
pickaxing2543103pickaxing
pigging123614673pi__gging
pilfering1536393pilfering
piling95025593pi_l__ing
pillage103412603pillag__e
pillaged12298093pillag_ed
pillager11278553pillag_er
pillagers12276923pillagers
pillages113012613pillag_es
pillorying1642793pillorying
piloting1139693pi_loting
pinging113419553pi__nging
pirating11314513pi_rating
placing123815283p__lacing
plaguing1236033p__laguing
planing103418253p__laning
plating103823073p__lating
playing133816093p__laying
pleading123011443p_leading
pleasing112611593p_leasing
pleating112916053p_leating
pledging13276363p_ledging
plugging13306893p_lugging
plunging12357673p_lunging
poleaxing1944873poleaxing
polkaing1534633polka_ing
pollarding1444243pollarding
pollening1236923pollening
polling102920383poll__ing
polluting1235703polluting
portaging1346843portaging
presaging1339393presaging
prilling113413413prill__ing
prologing1338953prologing
pulling103821073pull__ing
pulsating1236343pulsating
rilling84023623rill__ing
salvaging1465283salvaging
spilling113113943spill__ing
tillering1037883tillering
tilling83522783till__ing
villain1038483villa_in_
villains1138013villa_ins
villainy1444883villa_iny
violating1337443violating
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.423422437.4
2DLD Change Limit1486411007.29620372.9
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.76523012.4
 
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.