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

95 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
pickaxe224462(None) 
pickax2135911pickax_
pickaxed2443511pickaxed
pickaxes2344911pickaxes
package16128012package
pickle144215652pick_le
picrate112014142picrate
pikake11115802pi_kake
wickape1843722wickape
cicale10314503cic_ale
cockade1638133cockade
dickie133913113dick_ie
dictate10311663dictate
dockage1535723dockage
fickle153912973fick_le
hickie153812473hick_ie
kickable1535583kickable
linkage1295963linkage
lockage1436613lockage
mickle143715133mick_le
nickle123814483nick_le
nickname1642793nickname
nictate9310223nictate
packable1838633packable
packaged18115753packaged
packager17136153packager
packages17138733packages
packwax2542853packwax_
packwaxes2743413packwaxes
parkade1437583parkade
pectase112410363pectase
pectate112214693pectate
pica85831493pic_a__
pical95524373pic_a_l
picante11310523picante
picara10311903pic_ara
picaro10311323pic_aro
picas94626523pic_a_s
piccata1345703piccata
pice84641093pic___e
pick125933813pick___
pickadil1742633pickadil
pickaxing2543103pickaxing
picked154421313pick_ed
pickeer153710113pickeer
picker144422173pick_er
pickerel1645273pickerel
pickers153718093pickers
picket144924313pick_et
picketed17167383picketed
picketer16187433picketer
pickets154314183pickets
pickier153912973pickier
picking163418333picking
pickled164011883pickled
pickles153215443pickles
pickoff2143693pickoff
picks135226143pick__s
pickup1655633pick_up
pickups1754253pickups
picky165416943pick__y
picotee11311473picotee
picowave18102793picowave
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite
picture1158613picture
pika106322953pi_ka__
pikakes1245823pi_kakes
pikas114218093pi_ka_s
pike106335213pi_k__e
pileate93815923pileate
pillage103412603pillage
pinkeye16326493pinkeye
pinkie124414273pink_ie
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinwale1257843pinwale
pipage1199143pi_page
pipeage1236203pipeage
pirate82322883pi_rate
plicae10410953plic_a_e
plicate11314513plic_ate
poleaxe1656303poleaxe
prickle153611013prick_le
pucka133412803pucka__
sickee124622223sick_ee
sickie123715743sick_ie
sickle124418323sick_le
sinkage1287263sinkage
spicae104313703spic_a_e
spicate113214193spic_ate
tickle124616743tick_le
wickapes1943703wickapes

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 Filter1786911340270.436409841.7
2DLD Change Limit134027956.50020619.5
3Display Results95950.0332878.8
 (SQL Overall)178691956.96925640.8
 
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.