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

176 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
puckered173610(None) 
puckerer1645791puckerer
suckered1537831suckered
tuckered1535961tuckered
bickered17108002bickered
bucketed1736762bucketed
bucklered1844542bucklered
bunkered15177182bunkered
cockered17710212cockered
dackered16116892dackered
dickered16117532dickered
hunkered16186922hunkered
lackered15108682lackered
nickered15117022nickered
packeted17148292packeted
pickeered1843462pickeered
pickerel1645272pickerel
picketed17167382picketed
pocketed17147142pocketed
pucker143817632pucker__
puckerers1744512puckerers
puckerier1754322puckerier
puckers153514672pucker_s
puckery18306262pucker_y
puttered112611152puttered
unpuckered1942322unpuckered
bickerer16106783bickerer
brokered1536083brokered
bucked155121063buck__ed
buckeen1536703bucke_en
bucker145420463bucker__
buckeroo1644313buckeroo
buckers153517453bucker_s
buckeye1835683buckeye_
buckeyes1945263buckeyes
buckled164411883buck_led
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
butchered1744583butchered
buttered112712633buttered
cankered153010223cankered
cered85227443__c_ered
checkered2144683checkered
cockerel16107113cockerel
cockeyed2096123cockeyed
cuckooed1743303cuckooed
cumbered15157963cumbered
daikered1495223daikered
docketed16156583docketed
ducked144718013duck__ed
ducker134317993ducker__
duckers143214713ducker_s
duckweed1943023duckweed
euchred13106163euc_hred
flickered1943753flickered
fucked164114483fuck__ed
fucker153414423fucker__
fuckers163611593fucker_s
fullered1236383fullered
guttered10259173guttered
hankered16289443hankered
huckstered2041963huckstered
hungered13217053hungered
jacketed22146543jacketed
jockeyed2563413jockeyed
juddered1833583juddered
junketed2033523junketed
knackered1543683knackered
lackeyed18104513lackeyed
lechered1437523lechered
lucked135118023luck__ed
lumbered13188233lumbered
lustered92510613lustered
mackerel1644863mackerel
mucked153816093muck__ed
mucker143816393mucker__
muckers153612803mucker_s
murdered1236033murdered
mustered112511513mustered
muttered112610803muttered
nickeled15115513nickeled
numbered13147143numbered
ochered132610283_ochered
packaged18115753packaged
packed154822603pack__ed
packer144223403packer__
packers153818893packer_s
paltered113012503paltered
pampered15229233pampered
pandered121812573pandered
papered122513173p_apered
pattered112714213pattered
paupered13216943paupered
pecked155019103peck__ed
pecker144615363pecker__
peckers153312673pecker_s
peered93819493p__eered
peltered112510453peltered
peppered1236133peppered
pestered112814973pestered
petered103314973p_etered
pickaxed2443513pickaxed
picked154421313pick__ed
pickeer153710113picke_er
pickeers16347243pickeers
picker144422173picker__
pickerels1743723pickerels
pickers153718093picker_s
picketer16187433picketer
pickled164011883pick_led
pictured1346573pictured
pilfered1435853pilfered
pinkened1535753pinkened
plucked16367963pluck__ed
plucker15368253plucker__
pluckers16316563plucker_s
plundered1344323plundered
pocked154818983pock__ed
pocketer16157373pocketer
pondered126411293pondered
portered112311553portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643p_owered
puckeriest1843823puckeriest
puckering1835883puckering
puked124716223pu_k__ed
pummeled1543373pummeled
punctured1444183punctured
punker123718833punker__
punkers133714863punker_s
purebred1344253purebred
pureed95017813pu_re_ed
purred94218073pu__rred
purveyed1743363purveyed
putterer10209913putterer
quavered2144823quavered
queered17117223qu_eered
quickened2543163quickened
quivered2144833quivered
racketed15169133racketed
rocketed15157793rocketed
rubbered1335383rubbered
rucked134718763ruck__ed
ruckled144111033ruck_led
shickered19115723shickered
sickened1546783sickened
snickered16115343snickered
socketed15177343socketed
sputtered12166323sputtered
succeed1235983succe_ed
succored13135173succored
sucked134120493suck__ed
sucker124120663sucker__
suckers133717623sucker_s
suckled144212513suck_led
suffered1536733suffered
summered1338143summered
sundered10312153sundered
supered10316123su_pered
ticketed15146643ticketed
tinkered1387683tinkered
tochered1437913tochered
tucked134017493tuck__ed
tucker124316953tucker__
tuckers134014353tucker_s
ulcered1037973_ulcered
umbered121510113_umbered
ushered1139153_ushered
uttered82712443_uttered
vouchered1843853vouchered
whickered22114033whickered
wuthered15157433wuthered
yucked164013563yuck__ed

Search took 9 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.420425454.8
2DLD Change Limit1461621767.75018859.6
3Display Results1761760.1431230.8
 (SQL Overall)1786911768.31321495.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.