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

111 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
pocketer1615737(None) 
picketer16187431picketer
pocketed17147141pocketed
pocketers17196491pocketers
rocketer14158331rocketer
docketed16156582docketed
packeted17148292packeted
pickeer153710112picke_er
picketed17167382picketed
picketers17196482picketers
pocket144622622pocket__
pockets154612252pocket_s
pockier153911602pock_ier
puckerer1645792puckerer
rocketed15157792rocketed
rocketeer15174492rocketeer
rocketers15186882rocketers
socketed15177342socketed
bickerer16106783bickerer
bucketed1736763bucketed
cocker144320393cock__er
cockered17710213cockered
cockerel16107113cockerel
cockeye1867223cockeye_
cockeyed2096123cockeyed
cockeyes1967033cockeyes
cockier154013623cock_ier
coveter122912063co_veter
cricketer1744573cricketer
crocheter1645563crocheter
crocketed1845123crocketed
docker134417653dock__er
docket134721173docket__
dockets144412243docket_s
excreter1766123excreter
hocker155118563hock__er
huckster1743823huckster
jacketed22146543jacketed
jockette2165033jockette
jockettes2254383jockettes
jockeyed2563413jockeyed
jokester1934443jo_kester
junketer1943713junketer
locater93113603loc_ater
locker124019423lock__er
locket123922473locket__
lockets134612203locket_s
lockstep1643813lockstep
marketer1437383marketer
mocker143315443mock__er
ocker113915753_ock__er
packager17136153packager
packer144223403pack__er
packet144726503packet__
packets155114773packet_s
pecker144615363peck__er
peckier153910523peck_ier
peter74427593p___eter
pickeers16347243picke_ers
picker144422173pick__er
pickerel1645273pickerel
picket144924313picket__
pickets154314183picket_s
pickier153912973pick_ier
picometer1548913picometer
pocked154818983pock__ed
pocketful2052413pocketful
pocketing1875853pocketing
pointer93814933po_inter
poker115122883po_k__er
pokier124914633po_k_ier
politer92417073po_liter
pollster1037103pollster
polluter1035403polluter
polyester1445353polyester
ponderer112410193ponderer
poofter1237163po_ofter
porker124917543pork__er
porkier133712343pork_ier
porter84224413po__rter
poster84129173po__ster
potometer1349843potometer
potter83926983po__tter
potterer102310263potterer
poulter93712013po_ulter
pouter83923983po__uter
powderer14245593powderer
powter114116033po__wter
proceeder1444173proceeder
pucker143817633puck__er
puckered1736103puckered
puckerers1744513puckerers
puckerier1754323puckerier
racketed15169133racketed
racketeer15174633racketeer
racketier15165423racketier
ricketier15134583ricketier
rocker124319573rock__er
rocket125425283rocket__
rocketeers16173593rocketeers
rocketry1744503rocketry
rockets134615363rocket_s
rockier134911883rock_ier
secreter1038513secreter
sickener1436603sickener
socket123923523socket__
sockets134012983socket_s
sockeye1666413sockeye_
sockeyes1765763sockeyes
ticketed15146643ticketed
wickeder1843983wickeder

Search took 10 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 Filter1786911461620.843211970.3
2DLD Change Limit1461621118.29617618.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911119.18519454.7
 
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.