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

57 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
pickaxing254310(None) 
packaging1945162packaging
picketing1835682picketing
picking163418332pick__ing
pickling17239202pick_ling
bickering1837663bickering
coaxing173511703__coaxing
dickering1737463dickering
dicking153617613dick__ing
dictating1338883dictating
kickboxing25111553kickboxing
kicking133314023kick__ing
licking144118283lick__ing
nickeling1645393nickeling
nickering1636573nickering
nicking143516323nick__ing
nickling15278703nick_ling
nicknaming1952113nicknaming
nictating1237573nictating
packagings2042543packagings
packeting1836853packeting
packing164420723pack__ing
pecking164017783peck__ing
pickadil1742633pickadi_l
pickadils1842303pickadils
pickaninny215823pickaninny
pickax2135913pickax___
pickaxe2244623pickax__e
pickaxed2443513pickax_ed
pickaxes2344913pickax_es
pickeering1943533pickeering
pickings17359383pick__ings
picoting1338883pic_oting
picowaving2152233picowaving
picturing1436033picturing
piking133719643pi_k__ing
pillaging1345553pillaging
pillaring1237643pillaring
pinkening1634993pinkening
pinking143918943pink__ing
pirating11314513pi_rating
pocketing1875853pocketing
pocking163916763pock__ing
poleaxing1944873poleaxing
polkaing1534633polka_ing
pricking173212603prick__ing
prickling1836533prick_ling
puckering1835883puckering
ricking143920233rick__ing
sickening1635993sickening
sicking143720173sick__ing
sickling152910333sick_ling
sicklying1943883sicklying
ticketing1635633ticketing
ticking143218753tick__ing
tickling15309433tick_ling
wicking173414773wick__ing

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.440406115.9
2DLD Change Limit148641576.31323545.2
3Display Results57570.0301900.0
 (SQL Overall)178691576.78326343.9
 
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.