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

155 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
peppered123613(None) 
pepperer1145281pepperer
coppered153410542coppered
kippered17255622kippered
lappered13288212lappered
lippered13287952lippered
loppered13326752loppered
pampered15229232pampered
papered122513172p_apered
paupered13216942paupered
peered93819492pe__ered
peltered112510452peltered
pepped103113402pepp__ed
pepper93512942pepper__
pepperers1244902pepperers
peppers103311442pepper_s
peppery13286252pepper_y
pestered112814972pestered
petered103314972pe_tered
repapered1445232repapered
tempered13248222tempered
zippered22244822zippered
appeared1336143_appeared
beavered1437503beavered
bettered113011843bettered
bumpered1536003bumpered
capered123014043_capered
centered112513523centered
chippered1945003chippered
choppered1964883choppered
ciphered1637053ciphered
compered153414923compered
coopered133310943coopered
cyphered1934653cyphered
dapperer1335763dapperer
deepened1235663deepened
depermed1436453de_permed
depleted12258723depleted
deplored1237233deplored
diapered1238003diapered
entered82718883_entered
experted1838053_experted
expired1736403_expired
fendered13258673fendered
festered122512113festered
fettered12259493fettered
fevered14339723fe_vered
gendered11258873gendered
gettered10258613gettered
hampered16239933hampered
happened1635653happened
hepper133412663hepper__
jeered143912793je__ered
kepped15309543kepp__ed
kipperer16294723kipperer
lappeted13255833lappeted
lechered1437523lechered
leered73816223le__ered
lettered92910783lettered
levered114212303le_vered
lippened13255223lippened
membered1535903membered
metered103514013me_tered
neutered937423neutered
paltered113012503paltered
pamperer14228333pamperer
pandered121812573pandered
paperer113111903p_aperer
pattered112714213pattered
peeked134314583pe__eked
peeled94119713pe__eled
peened94318163pe__ened
peeped113915393pe__eped
peeper103614803peeper__
peepers113713673peeper_s
peeved124112893pe__eved
pelleted1138203pelleted
peopled1238513peop_led
peplumed1543043peplumed
pepperbox2151303pepperbox
peppering1337083peppering
pepperoni1253453pepperoni
peppertree1351933peppertree
peppier10268323pepp_ier
peptized22237523peptized
perdured12287403perdured
perjured18286273perjured
perpend12259353perpe_nd
perpended1546083perpended
perplexed2143263perplexed
perspired1444223perspired
perverted1546103perverted
pesterer102412713pesterer
pewterer13256313pewterer
pilfered1435853pilfered
pipped104516543pipp__ed
pondered126411293pondered
popeyed1535713p_opeyed
popped104117813popp__ed
popper93615963popper__
poppers103414863popper_s
poppied11388993popp_ied
poppled11339243popp_led
portered112311553portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643p_owered
premiered14237093premiered
prepared132210873prepared
prepped11329903prepp__ed
properer1259203properer
prospered1446973prospered
puckered1736103puckered
pupped105013273pupp__ed
puttered112611153puttered
rapiered1136053rapiered
rappeled1335003rappeled
reappeared1543013reappeared
rendered102512263rendered
reopened1138523reopened
repaired1148953repaired
reperked15177793re_perked
repoured1139563repoured
repowered1544663repowered
repped114616723repp__ed
respired1148993respired
revered112819333re_vered
sceptered1444723sceptered
scuppered1643933scuppered
severed113513863se_vered
sewered112911243se_wered
simpered1338253simpered
skippered1843433skippered
slippered1434823slippered
speered103614813_speered
sphered133512313_sphered
spiered104412463_spiered
stoppered1444473stoppered
supered10316123_supered
syphered1755013syphered
tampered13279463tampered
tapered102612933_tapered
teddered11255183teddered
teetered9258303teetered
telfered1234883telfered
telphered1544223telphered
temperer12227723temperer
tendered102510603tendered
tentered96412103tentered
tethered1238493tethered
veered103612743ve__ered
veneered1235983veneered
weltered12238443weltered
westered122511873westered

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.420425454.8
2DLD Change Limit1461621558.98616265.5
3Display Results1551550.390397.4
 (SQL Overall)1786911559.79618241.2
 
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.