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
peppered123612(None) 
pepperer1145271pepperer
coppered153410542coppered
kippered17255622kippered
lappered13288212lappered
lippered13287952lippered
loppered13326752loppered
pampered15229222pampered
papered122513162p_apered
paupered13216932paupered
peered93819482pe__ered
peltered112510442peltered
pepped103113392pepp__ed
pepper93512942pepper__
pepperers1244892pepperers
peppers103311442pepper_s
peppery13286242pepper_y
pestered112814952pestered
petered103314962pe_tered
repapered1445232repapered
tempered13248212tempered
zippered22244822zippered
appeared1336143_appeared
beavered1437503beavered
bettered113011833bettered
bumpered1536003bumpered
capered123014043_capered
centered112513523centered
chippered1945003chippered
choppered1964883choppered
ciphered1637053ciphered
compered153414923compered
coopered133310933coopered
cyphered1934653cyphered
dapperer1335763dapperer
deepened1235653deepened
depermed1436453de_permed
depleted12258713depleted
deplored1237223deplored
diapered1238003diapered
entered82718883_entered
experted1838053_experted
expired1736403_expired
fendered13258673fendered
festered122512103festered
fettered12259493fettered
fevered14339723fe_vered
gendered11258873gendered
gettered10258613gettered
hampered16239933hampered
happened1635653happened
hepper133412663hepper__
jeered143912793je__ered
kepped15309533kepp__ed
kipperer16294723kipperer
lappeted13255833lappeted
lechered1437523lechered
leered73816223le__ered
lettered92910783lettered
levered114212303le_vered
lippened13255223lippened
membered1535903membered
metered103514013me_tered
neutered937423neutered
paltered113012483paltered
pamperer14228333pamperer
pandered121812573pandered
paperer113111903p_aperer
pattered112714203pattered
peeked134314573pe__eked
peeled94119703pe__eled
peened94318153pe__ened
peeped113915383pe__eped
peeper103614803peeper__
peepers113713673peeper_s
peeved124112883pe__eved
pelleted1138193pelleted
peopled1238493peop_led
peplumed1543033peplumed
pepperbox2151303pepperbox
peppering1337083peppering
pepperoni1253453pepperoni
peppertree1351933peppertree
peppier10268323pepp_ier
peptized22237513peptized
perdured12287383perdured
perjured18286263perjured
perpend12259343perpe_nd
perpended1546073perpended
perplexed2143253perplexed
perspired1444203perspired
perverted1546093perverted
pesterer102412703pesterer
pewterer13256313pewterer
pilfered1435853pilfered
pipped104516543pipp__ed
pondered126411293pondered
popeyed1535703p_opeyed
popped104117813popp__ed
popper93615963popper__
poppers103414863popper_s
poppied11388983popp_ied
poppled11339233popp_led
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643p_owered
premiered14237083premiered
prepared132210863prepared
prepped11329893prepp__ed
properer1259203properer
prospered1446973prospered
puckered1736103puckered
pupped105013273pupp__ed
puttered112611143puttered
rapiered1136053rapiered
rappeled1335003rappeled
reappeared1543013reappeared
rendered102512263rendered
reopened1138503reopened
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
telphered1544213telphered
temperer12227723temperer
tendered102510603tendered
tentered96412103tentered
tethered1238493tethered
veered103612743ve__ered
veneered1235983veneered
weltered12238433weltered
westered122511863westered

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621556.59322169.3
3Display Results1551550.0632460.3
 (SQL Overall)1786911556.81226231.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.